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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.