topic Re: Find business day of the last month in datetime format in SAS Programming

Find business day of the last month in datetime format

Nihal — Wed, 28 Nov 2018 13:13:53 GMT

Hello,

I'd like to build a new variable based on a new existing macro variable &simuldate how has a format date9.

The new variable should be the business day of the last month and has a datetime format .

I've tried the code below

data _null_;
call symputx('datdt',put(intnx('WEEKDAY', intnx('MONTH', &simuldate, -1, 'END'), 0),DATE9.));
run;

this works

But when tried to convert the date in datetime format:

data _null_;
call symputx('datdt_m', put(dhms('&datdt'D,0,0,0),datetime.));
run;

I got
ERROR: Invalid date/time/datetime constant '&datdt'D.

can anyone help.

Thank you

Nihal

Re: Find business day of the last month in datetime format

r_behata — Wed, 28 Nov 2018 13:19:35 GMT

Enclose the macro variable in double quote :

data _null_;
call symputx('datdt_m', put(dhms("&datdt"d,0,0,0),datetime.));
run;

%put &=datdt_m;

Re: Find business day of the last month in datetime format

SuryaKiran — Wed, 28 Nov 2018 14:15:39 GMT

Hi,

Macro variables enclosed in single quotes will not be resolved. You have to always use double quotes only.

Re: Find business day of the last month in datetime format

Nihal — Wed, 28 Nov 2018 16:24:35 GMT

Thank you r_behata its works.

Can the 2 "data _null_ " merged on one step?

Thanks,

Re: Find business day of the last month in datetime format

r_behata — Wed, 28 Nov 2018 16:37:11 GMT

Hope this helps :

data _null_;
	datdt=intnx('WEEKDAY', intnx('MONTH', &simuldate, -1, 'END'), 0);
	call symputx('datdt_m', put(dhms(datdt,0,0,0),datetime.));
run;

%put &=datdt_m;