I was wondering if it's possible to create a macro variable with the same name for different BY groups? And be able to call the macro with the BY groups?   data: group siteid counts 1 MX004   22 2 MX004  15 3 MX004   37 1 MX005   106 2 MX005   48 3 MX005   154 1 MX006   108 2 MX006   56 3 MX006   164 1 MX007   18 2 MX007  10 3 MX007  28 1 MX008   49 2 MX008   28 3 MX008   77   want: 1.  macro variable called "group1" of group=1 counts by siteid 2.  macro variable called "group2" of group=2 counts by siteid 3.  macro variable called "group3" of group=3 counts by siteid       ... View more

Hi   I want to pull all distinct values from variable "SITEID" and then using them in a macro without typing all 118 SITEID values into  a proc step below:   proc sort data=x; by subject; where siteid= "&siteid"; run; ... View more

Hello,     I have a dataset with 50 different geographic locations (variable "COUNTRY") I need to subset.    Rather than creating a macro and manually calling all 50 locations, I was wondering if there's an efficient process where I can collect all the values of variable "COUNTRY" and produce ONE rtf output (each page will have different locations)?  I know you can use BY statement in proc report but my original program is a bit more complex than the example shown below.   %macro location(location=); proc sort data=cars (keep=model color country); by country; where country=&location; run; proc sql; select (strip(put(count(distinct model), best.))) into :var1 from cars; quit; %put &var1; ods rtf "c:/desktop/carmodel.rtf"; title1= "2021 car models in &location"; proc report data=cars; column model ; define model display "&location (&var1)"; run; %mend location; %location (location='USA'); %location (location='MEX'); %location (location='CHN'); %location (location='CAN'); %location (location='JAP'); %location (location='KOR'); %location (location='RUS'); %location (location='AFR'); %location (location='AUS'); %location (location='PR'); %location (location='BRA'); %location (location='IND'); %location (location='AMS'); %location (location='ENG'); ... View more

Hi, I need to create an output by "siteid".  There are 118 siteid's that need to be subset, so it wouldn't make sense for me to individually type it all out. Is there a way where I can automate this process? data=final; set x; where siteid='site1'; run; *Get denominator , Big N; proc sql; select (strip(put(count(distinct usubjid), best.))) into :trt1 from final where siteid; select (strip(put(count(distinct usubjid), best.))) into :trt2 from final where siteid; select (strip(put(count(distinct usubjid), best.))) into :trt3 from final where siteid; quit; %put &trt1 &trt2 &trt3; ... View more

Hi,   I get an error message when calculating binomial (95%CI) in the proc freq step because one of the 4 treatment groups have zero counts.  How can I still proceed and output "(0.00, 0.00)" for 95% CI when there are zero counts? proc sql; create table ce1_1_3 as select distinct(usubjid), TRT01A, ceoccur/*, ceterm*/ from ce_1 where cetoxgrn>=3 order by usubjid; quit; data ce1_1_3; merge adsl ce1_1_3; by usubjid; run; proc sort data=ce1_1_3; by trt01a; run; proc freq data=ce1_1_3 order=data; by TRT01A; table ceoccur/*ceterm*// missing exact binomial(level=2) cl; ods output onewayfreqs=ae_freqs_soc_3 binomial=ae_ci_soc_3(where=(name1 in ('XL_BIN', 'XU_BIN'))); run; Thank you ... View more