Help using Base SAS procedures

Proc Freq questions

Accepted Solution Solved
Reply
Contributor
Posts: 27
Accepted Solution

Proc Freq questions

Say we have some data set called data1:

NameClassFSGroupGood
WillAMaths1Y
TeddyAPhy2Y
JeremyBBio3Y
BobBMaths2N


What SAS code would you write to generate frequency tables for each levels of Good (Y and N)?

. i.e.

Good=Y
Class
GroupAB
110
211
301
Total22

Good=N
Class
GroupAB
201
Total01

Accepted Solutions
Solution
‎08-18-2011 04:28 AM
Super User
Posts: 10,020

Proc Freq questions

Posted in reply to willy0625
data temp;
input Name $     Class $     FS $     Group     Good $ ;
cards;
Will     A     Maths     1     Y
Teddy     A     Phy     2     Y
Jeremy     B     Bio     3     Y
Bob     B     Maths     2     N
;
run;
proc sort data=temp;by good;run;
options missing=0;
proc tabulate data=temp format=best4. missing;
 by good;
 class group class;
 table group all,class*n='' ;
run;

Ksharp

View solution in original post


All Replies
Occasional Contributor
Posts: 5

Proc Freq questions

Posted in reply to willy0625

I guess proc freq is not the right procedure to create this type of table. You should try proc tabulate. It has lot of options to create different type of tables. Also, proc report might do it.

Solution
‎08-18-2011 04:28 AM
Super User
Posts: 10,020

Proc Freq questions

Posted in reply to willy0625
data temp;
input Name $     Class $     FS $     Group     Good $ ;
cards;
Will     A     Maths     1     Y
Teddy     A     Phy     2     Y
Jeremy     B     Bio     3     Y
Bob     B     Maths     2     N
;
run;
proc sort data=temp;by good;run;
options missing=0;
proc tabulate data=temp format=best4. missing;
 by good;
 class group class;
 table group all,class*n='' ;
run;

Ksharp

Valued Guide
Posts: 2,177

Proc Freq questions

Posted in reply to willy0625

keeping it simple, is it not just a case of using a "by good ;" statement in proc freq?

a very basic test

data d1 ;

input

Name $ Class $  FS $  Group  Good $ ;

list;cards;

Will A Maths 1 Y

Teddy A Phy 2 Y

Jeremy B Bio 3 Y

Bob B Maths 2 N

;

proc sort ;

   by good ;

run ;

proc freq ;

   by good ;

  table group * class ;

run;

Respected Advisor
Posts: 2,655

Re: Proc Freq questions

And even simpler, we could eliminate the sort and by statement, and use a three level table statement:

data d1 ;

input

Name $ Class $  FS $  Group  Good $ ;

list;cards;

Will A Maths 1 Y

Teddy A Phy 2 Y

Jeremy B Bio 3 Y

Bob B Maths 2 N

;

proc freq ;

  table good * group * class /nopct norowpct nocolpct ;

run;

Steve Denham

Super User
Posts: 10,020

Re: Proc Freq questions

Peter.C and Steve Denham

Yes. It would be more simple , but not exactly look like the output OP want.

Smiley Happy

Ksharp

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 147 views
  • 6 likes
  • 5 in conversation