Summary report

[khalidamin]

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

[ballardw]

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.

[khalidamin]

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

Happy Halloweens!

[stat_sas · Accepted solution]

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;

[khalidamin]

Thank you so much 🙂

It worked perfectly.