Creating a Macro variable By using ODS

[kuridisanjeev]

Hi every one...

Is it possible to create a macro variable by Using ODS statement???

If YES ,could you please explain..,,,

Thanks

Sanjeev.k

[Gerd47]

No, use the %let statement to create a macro variable for example.

Best regards,

Gerd

[kuridisanjeev]

Hi Gerd47,

i think there is a way...

please go through bellow screen shot,

Regards..

Sanjeev.K

[Hima · Accepted solution]

The MATCHALL= option for the OUTPUT destination on the ODS statement can be used to name a macro variable that will
contain a list of SAS data tables. In the following example a PROC UNIVARIATE is executed with a BY statement. For each
value of the BY variable (PRODUCT) a data set will be created which will contain the summary known as MOMENTS. The
MATCHALL option requests separate data sets and the list of the names of these data sets is to be written to the macro
variable &NAMELIST.
ods output Moments(match_all=namelist)=work.Moments;
proc univariate data=magdata;
by product;
var ampida;
title1 'ODS Output - with BY Statement';
run;
ods output close;
Later these data sets can be combined by using the macro variable &NAMELIST.
data allmoments;
set &namelist;
run;
The LOG shows.

53
54 data allmoments;
55 set &namelist;
56 run;
NOTE: There were 6 observations read from the data set WORK.MOMENTS.
NOTE: There were 6 observations read from the data set WORK.MOMENTS1.
NOTE: There were 6 observations read from the data set WORK.MOMENTS2.
NOTE: There were 6 observations read from the data set WORK.MOMENTS3.
NOTE: There were 6 observations read from the data set WORK.MOMENTS4.
NOTE: The data set WORK.ALLMOMENTS has 30 observations and 11 variables.

[Gerd47]

Ah, ok. Didn't know this option.

[kuridisanjeev]

Thanks Hima