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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.