BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Q1983
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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

1 REPLY 1
ballardw
Super User

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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