Hi @radhikaa4    You can try either: proc sql; create table group_denominator as select group, count(*) as count from test group by group; quit; or   proc freq data=test noprint; table group / out=group_denominator (drop=percent); run;   In PROC SQL, the GROUP BY clause enables to compute summary statistics (in your case: n) for each modality of the specified variable (in your case: group).   Best,   ... View more

Hi @radhikaa4    You can try this, using a proc format to specify Yes / No instead of 1 / 0: data have; input id reason_1 reason_2 reason_3; cards; 1 1 1 0 2 1 0 0 3 0 1 0 4 0 1 1 5 . . . 6 1 0 0 7 1 1 0 8 0 1 1 9 0 0 1 10 1 1 0 ; run; proc format fmtlib; value reason 0 = "No" 1 = "Yes"; run; data want; set have; format value reason.; by id; array reason_(3); do i=1 to dim(reason_); reason = vname(reason_(i)); value = reason_(i); output; end; drop i reason_:; run;   Output using proc freq: proc freq data=want; tables reason * value / nocum nocol nopercent; run;   or output using proc report: proc report data=want; column reason value, (n pct); define reason / group 'Reason'; define value / across; define n / "n" ; define pct / computed "%" f=percent8.0; /* Sum totals in row for further calculation */ compute before reason; _total = sum(_c2_, _c4_); endcomp; /* Compute percentages from frequencies (n) and totals in row (_total) */ compute pct; if _c2_> 0 then _c3_ = _c2_ / _total; else _c3_= 0; if _c4_> 0 then _c5_ = _c4_ / _total; else _c5_= 0; endcomp; ; run;   ... View more

Hi @Mick_lb  You need to be very careful with dates in macro variables. It should not be formatted to be used for further calculation Typically, 01JAN2017 (which is human-readable) is stored as the numeric value 20820 by SAS (= number of days since 01JAN1960)   Best,   %let date=01JAN2017:00:00:00; %put ===> &date; %let date_2=%sysfunc(datepart(%sysfunc(inputn(&date,datetime18)))); %let last_day=%sysfunc(day(%sysfunc(intnx(month,&date_2,-1,end)))); %let p_month=%sysfunc(month(%sysfunc(intnx(month,&date_2,-1,end)))); %let p_year=%sysfunc(year(%sysfunc(intnx(month,&date_2,-1,end)))); %put ===> &last_day.; %put ===> &p_month.; %put ===> &p_year.;   ... View more

Hi @sasuser1031    Once you've changed b=0 to b=1, do you want to run the code for this new value of b, or do you want to run this code only when b is initially different from 0? If it is the first cas, you can try the below code. Best, data want; set have; if b=0 then b=1; if b>0 then do; if (a < 1000) OR (a/b <.1 & c < 5000000 & d IN (0,.)) OR (a/b < .1 & c < 10000000 & d IN (0,.)) OR (a < 500000 & c < 5000000 & d IN (0,.)) OR (a < 1000000 & c < 10000000 & d IN (0,.)) then e = 1; end; run; ... View more

Hi @JDDowell    There is no need to create dummy variables to do that. You can try the following code: proc freq data=have; tables date*location / out=want nocum nopercent norow nocol; format date MONYY6.; run; ... View more

Hi @scify    Have you tried to remove the "across" option in the DEFINE col5 statement ? data test; input col1 $ col2 $ col3 $ col4 $ col5 $ @@ ; datalines; foo bar foo bar foo bar foo bar foo foo foo bar foo bar foo ; proc print ; run; proc report data=test spanrows nowd style(header)={bordertopwidth=.5 borderbottomwidth=.5 borderleftwidth=.5 borderrightwidth=.5 borderstyle=solid bordercolor=black}; column ('Overall' (("Group 1" (col1 col2)) ("Group 2" (col3 col4)) ("Group 3" (col5)) )); define col1 / " " style(column)={width=100%}; define col2 / " " style(column)={width=100%}; define col3 / " " style(column)={width=100%}; define col4 / " " style(column)={width=100%}; define col5 / " " style(column)={width=100% vjust=m just=c tagattr='wrap:yes'}; run; ... View more