Help using Base SAS procedures

proc summary,tabulate,transpose or means

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 129
Accepted Solution

proc summary,tabulate,transpose or means

Proc sql;

Create table main3 as

Select ln,scenario,wk_station,

Case when ln ne ‘’ then 1 else ‘’ end as cnt_ln;

Quit;

Sample data

Ln         scenario           wk_station      cnt_ln

11         legal                             a                  1

12       legal                             a                   1

13       bk                                                      1

14      loss_mit                     c                   1

Desired output

scenario                           a          c      (blank) if wk_station is blank          Grand_Total

Legal                                2                                                                                 2

bk                                                                             1                                          1

loss_mit                                      c                                                                       1

Grand_Total                  2           1                            1                                         4

Essentially I need to summary these and show totals both horizontal and vertical.  it appears I may need a combination of proc statements, any ideas.  Note if the wk_station is blank I want to assign a 1


Accepted Solutions
Solution
‎08-24-2015 06:15 PM
Grand Advisor
Posts: 10,075

Re: proc summary,tabulate,transpose or means

If the data is only counts then this may provide a starting point:

proc tabulate data=have;

     class scenario;

     class wk_station / missing ;

     freq cntl_ln; /* this says to use the value of the variable as a count*/

     table scenario='' All="Grand Total",

              (wk_station='' All="Grand Total")*n='

               / misstext=' ' ';

run;

the ='' suppress the label or variable name appearing in the output

View solution in original post


All Replies
Solution
‎08-24-2015 06:15 PM
Grand Advisor
Posts: 10,075

Re: proc summary,tabulate,transpose or means

If the data is only counts then this may provide a starting point:

proc tabulate data=have;

     class scenario;

     class wk_station / missing ;

     freq cntl_ln; /* this says to use the value of the variable as a count*/

     table scenario='' All="Grand Total",

              (wk_station='' All="Grand Total")*n='

               / misstext=' ' ';

run;

the ='' suppress the label or variable name appearing in the output

☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 212 views
  • 0 likes
  • 2 in conversation