Hi,
I m trying to do this:
data temp;
infile datalines;
input datum : DATE10.
value1 COMMAX12.2
value2 COMMAX12.2
value3 COMMAX12.2
value4 COMMAX12.2;
datalines;
01.11.2017 366.020,57 273.972,60 83942020,57 83,94
;
run;
But I am not able to read the correct date.
Can someone help me out please?
Thanks!
Dirk
ddmmyy10. format will do the trick
data temp;
input datum:ddmmyy10.;
format datum ddmmyy10.;
datalines;
01.11.2017
;
ddmmyy10. format will do the trick
data temp;
input datum:ddmmyy10.;
format datum ddmmyy10.;
datalines;
01.11.2017
;
Anytime, glad to help 🙂
To make the displayed format look exactly like the input, use the format
ddmmyyp10.
to replace the slashes with dots.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.