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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.