Create a date variable in a sas dataset

foxrol94 — Thu, 22 Feb 2018 10:44:01 GMT

Hi,

I have some trouble cause i would like to create a date variable dat in a sas dataset and i'm doing lke this:


%let date_traitement=%sysfunc(intnx(month, %sysfunc(today()),-1,e), ddmmyyn8.);
%put NOTE: DATE de Traitement ====> &date_traitement.;
data test;
	set sashelp.Prdsal2;
	date0= put(input(&date_traitement.,ddmmyy10.), ddmmyy10.);
run;

Dateset is created but the variable dat have values 3101202 instead of 31012018. I'm a bit confused.

Thnaks for your support

Re: Create a date variable in a sas dataset

FredrikE — Thu, 22 Feb 2018 11:20:07 GMT

Try put &date between quotes:

"&date_traitement."

//Fredrik

topic Create a date variable in a sas dataset in SAS Programming

Create a date variable in a sas dataset

Re: Create a date variable in a sas dataset