topic Re: Question on updating a existing macro variable macro using proc SQL in SAS Programming

Question on updating a existing macro variable macro using proc SQL

Smijoss — Tue, 01 Apr 2014 23:18:56 GMT

Hi ,

I have an issue with a macro variable. When i run it for first time, it runs fine ... in the 2nd run when i change the input year, it still retains the value from previous run. although i do see taht the correct row is fetched (since I have not mentioned noprint its displaying the result.) but the log shows the macro is still retaining a year from the prev run..

			PROC SQL ;
				SELECT TRIM(MAX(NAME)) into :Max_date
				FROM DICTIONARY.COLUMNS
				WHERE LIBNAME='WORK' AND MEMNAME = 'ADDT_LOOKUP'
				AND substr(NAME,1,5) = "D&YEAR.";
			QUIT;

Re: Question on updating a existing macro variable macro using proc SQL

Smijoss — Tue, 01 Apr 2014 23:20:01 GMT

I have tried using %symdel and then recreate it but it does not work

Re: Question on updating a existing macro variable macro using proc SQL

Reeza — Tue, 01 Apr 2014 23:27:10 GMT

Post your full log with the %put statements between each call.

Use option mprint and symbolgen to see what is occurring.

Re: Question on updating a existing macro variable macro using proc SQL

Smijoss — Wed, 02 Apr 2014 16:13:29 GMT

Hi Reeza,

Thank you for your response. I have found the reason.

Earlier i was using the call execute which was causing this issue.

DATA _NULL_ ;

Set MSAFrmt.regions_list ;

call execute('%FETCH_RECORDS('||Orgnm||")");

Run;

Now instead of using the sas data step if i directly call the macro %FETCH_RECORDS(co) it does not give this issue.

Thanks again.