topic Creating a Macro variable By using ODS in SAS Programming

Creating a Macro variable By using ODS

kuridisanjeev — Mon, 02 Apr 2012 12:25:29 GMT

Hi every one...

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

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

Thanks

Sanjeev.k

Creating a Macro variable use ODs

Gerd47 — Mon, 02 Apr 2012 12:27:32 GMT

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

Best regards,

Gerd

Creating a Macro variable By using ODS

kuridisanjeev — Mon, 02 Apr 2012 12:43:41 GMT

Hi Gerd47,

i think there is a way...

please go through bellow screen shot,

Regards..

Sanjeev.K

Creating a Macro variable By using ODS

Hima — Mon, 02 Apr 2012 12:46:25 GMT

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.

Creating a Macro variable By using ODS

Gerd47 — Mon, 02 Apr 2012 12:57:32 GMT

Ah, ok. Didn't know this option.

Creating a Macro variable By using ODS

kuridisanjeev — Mon, 02 Apr 2012 13:07:18 GMT

Thanks Hima