topic Summary report in SAS Procedures

Summary report

khalidamin — Fri, 30 Oct 2015 22:38:36 GMT

Hi everyone,

I am fairly new to SAS and need your help. I have a dataset of school children with grades and food habits. Food habit section has five variables. each variable tells the no. of time one particular food is take. For example,

ID	Grade	Food A	Food B	Food C	Food D
101	7	Yes	No	Yes	Yes
102	8	No	No	No	Yes
103	7	Yes	Yes	No	Yes

How can I make a table showing grade and food food habit?

		Frequency
Grade 7
	Yes	6
	No	2
Grade 8
	Yes	1
	No	3

Would appreciate your help.

Thank you.

Khalid

Re: Summary report

ballardw — Fri, 30 Oct 2015 22:44:55 GMT

One way

proc tabulate data=have;
   class grade fooda foodb foodc foodd;
   table 
             grade *(fooda foodb foodc foodd),
             n
   ;
run;

this does all the foods at once. Grade * fooda , n ; would do just fooda.

Re: Summary report

khalidamin — Fri, 30 Oct 2015 22:50:03 GMT

@ballardw,
Thank you ... Will get back to you soon.

Happy Halloweens!

Re: Summary report

stat_sas — Sat, 31 Oct 2015 01:58:22 GMT

Try this to generate desired output:

data have;
input ID Grade FoodA $ FoodB $ FoodC $ FoodD $;
datalines;
101 7 Yes No Yes Yes
102 8 No No No Yes
103 7 Yes Yes No Yes
;

proc transpose data=have out=want;
by id grade;
var FoodA FoodB FoodC FoodD;
run;

proc tabulate data=want;
class Grade col1;
table grade*col1=' ',n='Frequency';
run;

Re: Summary report

khalidamin — Mon, 02 Nov 2015 14:52:19 GMT

Thank you so much 🙂

It worked perfectly.