topic Re: Create a macro value // passing value to macro variable in SAS Programming

Create a macro value // passing value to macro variable

hhchenfx — Wed, 22 Nov 2017 23:19:13 GMT

Hi Everyone,

I want to create a macro variable that take the value of today date in the form yyyymmdd.

I can do it with my code below but I have to start with a dataset "mydata".

I thought that there should be a way to use _NULL_ data but I cant work it out.

Can you help me?

Thank you,

*SOLUTION --------------------------------

data _NULL_;
format today yymmdd8.;
today=date(); 
ymd=year(today)*10000+month(today)*100+day(today);

   call symputx('next_month',put(ymd,10.));

run;

%put &next_month;


data TEMP; 		set Mydata;
format today yymmdd8.;
today=date(); 
ymd=year(today)*10000+month(today)*100+day(today);run;

	proc sql;
	select Max(ymd) into:todaydate
	from  TEMP;quit;

	%put &todaydate;

Re: Create a macro value // passing value to macro variable

Reeza — Wed, 22 Nov 2017 19:46:03 GMT

Look up %SYSFUNC and note the two parameters.

%let today = %sysfunc(today(), yymmdd8.);

%put &today.;

Re: Create a macro value // passing value to macro variable

hhchenfx — Wed, 22 Nov 2017 20:17:37 GMT

Thank you for the suggestion.

I am more concern with manipulating the value a bit before passing it to macro variable.

Re: Create a macro value // passing value to macro variable

SuryaKiran — Wed, 22 Nov 2017 20:25:58 GMT

hi,

Check out "CALL SYMPUT" which can pass the value to a macro variable with DATA _NULL_

Re: Create a macro value // passing value to macro variable

Tom — Wed, 22 Nov 2017 20:27:37 GMT

I don't really understand what your question is.

You do not need to have an input dataset to run a data step.

data _null_;
   x=today();
   next_month=intnx('month',x,1,'b');
   call symputx('next_month',put(next_month,yymmddn8.));
run;

Re: Create a macro value // passing value to macro variable

hhchenfx — Wed, 22 Nov 2017 23:17:59 GMT

Thanks a lot.
HC