topic Macro functionality in SAS Programming

Macro functionality

DPraba79 — Mon, 24 Jan 2011 19:47:10 GMT

Hi All,

I have a situation like, I have two macro varibales "Y2008" & "Y2009" with the values of 7 , 3 respectively. on the otherside, my data files has one variable "YEAR_END" and two obervarion with the values of 2008 & 2009. I have to resolve this YEAR_END vairbal with the above macro values (7 ,3) .

Please do see my code,

%let Y2008 = 7 ;
%let Y2009 = 3 ;

data data1;
input YEAR_END $4.;
out_var = &Y.&YEAR_END. ; <-- here i am getting error
cards;
2008
2009
;
run;

I want the output of data1 is,
out_var = 7 YEAR_END=2008
out_var =3 YEAR_END=2009

Kindly note, i don't want to hard code if condition , like, if YEAR_END=2008 then out_var = &Y2008
Thanks,

Re: Macro functionality

sbb — Mon, 24 Jan 2011 19:57:37 GMT

What you are wanting to use is "macro variable" resolution within your DATA step.

So, you want the SYMGET function within your DATA step and concatenate the character "Y" with the "input character variable YEAR_END.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step programming symget function site:sas.com Message was edited by: sbb

Re: Macro functionality

Ksharp — Tue, 25 Jan 2011 03:34:57 GMT

Hi. call execute is very useful for your situation.

[pre]
%let Y2008 = 7 ;
%let Y2009 = 3 ;

data _null_;
input YEAR_END $4.;

if _n_ eq 1 then call execute('data data1;');
call execute('out_var=&Y'||year_end||';');
call execute('year_end='||year_end||';');
call execute('output;');

datalines;
2008
2009
;
run;
[/pre]

Ksharp

Re: Macro functionality

deleted_user — Tue, 25 Jan 2011 14:58:32 GMT

Hello,

you can try the resolve function with single quotes in order to delay the resolution until the DATA step executes:

[pre]
data data1;
input YEAR_END $4.;
out_var=input(resolve(cats('&Y',YEAR_END)),best12.);
cards;
2008
2009
;
run;
[pre]

Marius

Re: Macro functionality

Ksharp — Wed, 26 Jan 2011 05:36:52 GMT

Great!
Which remaind me another simple solution.

[pre]

%let Y2008 = 7 ;
%let Y2009 = 3 ;
data data1;
input YEAR_END $4.;
out_var=symgetn('Y'||year_end);
cards;
2008
2009
;
run;
[/pre]

Ksharp