Solved: Date

Timbim · Posted 10-18-2018 08:14 PM

Hi Community,

what does the following mean?

data test;

set detail.account_nii(where=(k_time="&day_date9."d));

run;

what is &day_date9?

Thanks for your help.

Magstar

mkeintz · Posted 10-18-2018 08:19 PM

This program expects there to be a previously defined macrovar named DAY_DATE9, with a value in the format ddMMMyyyy.For example, precede your program with a statement like:

%let day_date9=17OCT2018 ;

Presumably the variable k_time has sas date values in it.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

mkeintz · Posted 10-18-2018 08:19 PM

This program expects there to be a previously defined macrovar named DAY_DATE9, with a value in the format ddMMMyyyy.For example, precede your program with a statement like:

%let day_date9=17OCT2018 ;

Presumably the variable k_time has sas date values in it.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Date

Re: Date

Re: Date

Date

Re: Date

Re: Date

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away