topic Re: Macrocode correction needed in New SAS User

Macrocode correction needed

PierreYvesILY — Thu, 14 Jan 2021 12:11:45 GMT

hello dear SAS experts,

I want to parametrize a macrovariable which I use in a bunch of programs. I wrote:

* Jahr eingeben ;

%let Jahr = 2022 ;

%put &Jahr. ;

* Macro-code fuer den Auswertungstag ;

%let Auswertungstag = '01JAN&Jahr.'D;

%put &Auswertungstag.;

I want to use &Jahr. to Change the year and get the Dates with the following form: '01JAN2022'D

What should I Change?

Regards

Shmuel — Thu, 14 Jan 2021 12:16:20 GMT

In order to resolve a macro variable it should be in double quotes. Try

%let Auswertungstag = "01JAN&Jahr."D;

%put &Auswertungstag.;

Kurt_Bremser — Thu, 14 Jan 2021 13:04:40 GMT

Maxim 28, Macro Variables Need No Formats.

%let Auswertungstag = %sysfunc(inputn(&jahr.0101,yymmdd8.));

%let Auswertungstag = %sysfunc(mdy(1,1,&jahr.));

The raw numeric value works just like the "ddmmmyyyy"d string in code, but is much easier to handle, as you need never worry about quotes.

PierreYvesILY — Thu, 14 Jan 2021 13:13:38 GMT

Thx to both of you.

PierreYvesILY — Thu, 14 Jan 2021 15:19:33 GMT

Thank you Kurt.
I wish you a happy and successfull year 2021.
Thank you for your help in 2020,
Regards