topic Re: obtain required Id using defined macro in SAS Programming

obtain required Id using defined macro

BrahmanandaRao — Mon, 07 Dec 2020 03:38:49 GMT

data dup;
input id city$;
cards;
1 hyd
2 blg
2 chn
3 hyd
3 gurg
4 mumb
;
run;




%let Req_id=4;
proc print data=dup noobs;
where id='&Req_id';
run;

Here I have sample table then i defined macro variable Req_id; to get required id

but above code shows error

Re: obtain required Id using defined macro

mkeintz — Mon, 07 Dec 2020 06:15:32 GMT

Two issues:

The macro process will pass on the quotes, so the regular sas language compiler will see those quotes and presume you expect ID to be a character variable.
But even if ID were a character variable here, your program would fail to find an observation. This is because there is an important relationship between the macro interpreter and single quotes vs double quotes. Namely, the macro interpreter will not attempt to resolve the macrovar value inside single quotes, but will resolve text inside double quotes. If ID were a character variable, you would need to use double quotes.

Re: obtain required Id using defined macro

BrahmanandaRao — Mon, 07 Dec 2020 06:44:29 GMT

solution please

Re: obtain required Id using defined macro

Kurt_Bremser — Mon, 07 Dec 2020 07:28:54 GMT

@BrahmanandaRao wrote:
solution please

You have already got it, with a nice explanation. Don't be rude to people trying to help you.

Re: obtain required Id using defined macro

PaigeMiller — Mon, 07 Dec 2020 13:15:03 GMT

First, get this code to work WITHOUT macro variables. You have not done this. Once you get it to work without macro variables, then it will be easy to get it to work WITH macro variables. If you can't get it to work WITHOUT macro variables, then it will never work WITH macro variables.

The above is the process you ought to follow for any attempt to use macro variables or macros.

Show us working code WITHOUT macro variables.

Re: obtain required Id using defined macro

Tom — Mon, 07 Dec 2020 14:53:01 GMT

The macro processor ignores & and % inside of single quotes. So the macro processor ignored this line.

where id='&Req_id';

so you tried to compare the value if ID to ampersand followed by letters Req_id.

Since you defined ID as numeric you want to write a line like this:

where id=4;

So how should you change the line of code to have that text generated by the macro processor?