topic Re: Need Assistance in SAS Programming

Need Assistance

lisa2002 — Wed, 15 May 2019 20:03:39 GMT

Hello,

I need some assistance with creating a frequency table of smoking status by cholesterol status suppress the Row Pct and Col Pct

This is what I have to create a frequency table for smoking status however

proc freq data=sashelp.heart;
tables Smoking_Status/Chol_Status;
quit;

I tried to use example

proc freq data=SummerSchool order=data;
   tables Internship*Enrollment / chisq;
   weight Count;
run;

However I'm not getting smoking status by cholesterol status

Status Smoking_Status Chol_Status

dead Heavy (16-25) desirable

alive non-smoker desirable

dead moderate (16-25) high

alive non-smoker borderline

alive light (1-5) borderline

Re: Need Assistance

PaigeMiller — Wed, 15 May 2019 20:09:07 GMT

tables Internship*Enrollment / chisq nocol norow;

Please go back to your first post in this thread and provide a more meaningful title.

Re: Need Assistance

Reeza — Wed, 15 May 2019 20:47:53 GMT

@lisa2002 wrote:

Hello,

I need some assistance with creating a frequency table of smoking status by cholesterol status suppress the Row Pct and Col Pct

This is what I have to create a frequency table for smoking status however

proc freq data=sashelp.heart;
tables Smoking_Status/Chol_Status;
quit;

I tried to use example
proc freq data=SummerSchool order=data;
   tables Internship*Enrollment / chisq;
   weight Count;
run;  
However I'm not getting smoking status by cholesterol status

Status Smoking_Status Chol_Status

dead Heavy (16-25) desirable

alive non-smoker desirable

dead moderate (16-25) high

alive non-smoker borderline

alive light (1-5) borderline

Smoking_Status is not included in your PROC FREQ so it won't be included in the results. It depends on how you want it, but you could just add smoking_status to the table statement or put it as a BY statement to have it done for each status.

Re: Need Assistance

ballardw — Wed, 15 May 2019 21:21:09 GMT

Your code:

proc freq data=sashelp.heart;
tables Smoking_Status/Chol_Status;
quit;

generates errors because the / is used to indicate options such as the types of tests or output are required.

The * between variable names is used to request a cross-tabulation

proc freq data=sashelp.heart;
tables Smoking_Status*Chol_Status;
quit;