Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 2 . Import the data file asthma _ Ex 2 . csv and write the SAS code to obtain the same output as the

Exercise2. Import the data file asthma_Ex2.csv and write the SAS code to obtain the same output as the one stored in the file report_Ex2.html. Hint: use proc print.
This is my asthma_Ex2 data:
\table[[Patient,Weight,Height,Age,BMI,Smoking,Asthma],[14,167,70,65,23.95939,never,no],[9,,74,64,never,yes,],[4,165,65,25,27.45444,occasional no,],[2,152,67,60,23.80397,heavy smo yes,],[13,161,70,77,23.09857,occasional yes,],[1,143,64,55,24.54321,occasional no,],[7,148,71,61,20.63956,occasional yes,],[11,281,69,45,41.49191,heavy smo yes,],[5,220,70,58,31.56327,occasional no,],[6,182,64,26,31.23682,never,no],[8,190,66,74,30.66345,occasional yes,],[12,,.,,39,,occasional yes],[3,190,69,63,28.05503,never,no],[15,148,67,53,23.17755,never,yes],[10,152,65,61,25.29136,never,yes],[16,182,172,58,27.43555,occasional no,]]
This is my code and it not working :
proc import out= Asthma
datafile ="//vdi-fileshare02/UEMprofiles/030158321/Desktop/asthnma_Ex2.csv"
dbms=csv replace;
run;
title' Asthma Patients Basic Data Set';
footnote'Data from Medical Records';
proc sort data = Asthma;
by patient;
run;
proc sort data= Asthma;
by smoking;
run;
proc print label noobs;
by smoking;
var patient asthma age bmi;
run;
It said i'm missing my variable smoking. Please help me this part.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Rules In Database Systems Third International Workshop Rids 97 Sk Vde Sweden June 26 28 1997 Proceedings Lncs 1312

Authors: Andreas Geppert ,Mikael Berndtsson

1997th Edition

3540635165, 978-3540635161

More Books

Students also viewed these Databases questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago