topic Re: macro problem in SAS Programming

macro problem

Rohit12 — Wed, 27 Dec 2017 08:43:00 GMT

%let acctage_99=4567;

%macro new(var);

data new;

set old;

if &var<&var_99 then &var=&var_99;

run;

%mend;

%new(Acctage)

In the old dataset I am having a variable Acctage which I need to comapre with macro variable(acctage_99) and then assign the value of acctage_99 to variable acctage

how can I acheive this through macro

Re: macro problem

pau13rown — Wed, 27 Dec 2017 09:05:42 GMT

you should indicate what error or warning message you're seeing so that people can assist. I think you're missing a period '.' though ie after "&var" as follows: "if &var<&var._99 then &var=&var._99;"

Re: macro problem

Rohit12 — Wed, 27 Dec 2017 09:36:36 GMT

actually i am not getting any error .But mu code is not running what i want

if &var<&var_99 then &var=&var_99;

below line resolves into

if acctage<acctage_99 then acctage=acctage_99

there comes a note in the log

variable acctage_99 is uninitiliazed which is corect

what I want is this

if acctage< 4567 then acctage=4567

thanks

Re: macro problem

pau13rown — Wed, 27 Dec 2017 09:39:48 GMT

did you try what i suggested? if it is saying "acctage_99 is uninitiliazed" in the log then what i suggested is likely the problem

Re: macro problem

Kurt_Bremser — Wed, 27 Dec 2017 10:09:41 GMT

You set acctage_99, but you never use it. I guess it should have been

if &var. < &&var._99 then &var. = &&var._99;

Even better would be to use the max() function:

&var. = max(&var.,&&var._99);

Re: macro problem

Astounding — Wed, 27 Dec 2017 11:59:14 GMT

Given that &VAR is ACCTAGE, and given that you want to compare to the macro variable (not the DATA step variable) &ACCTAGE_99, you will need a slightly different expression:

if &var < &&&var._99 then &var = &&&var._99;

The three pieces within &&&var._99 are:

&& ==> &

&var. ==> Acctage

_99 ==> _99

So the whole thing resolves properly into &Acctage_99