Read German date format in data step

[dirks]

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

[Cynthia_sas]

Hi:
Suggest you look up INFORMATS for dates. The form that your date is in does not appear to fall into the DATE normal representation. You might need to switch to a different date informat. Also, you need the colon modifier for ALL of your VALUE variables, too (not just the DATUM variable). Anything you read with an informat should use the : modifier.

cynthia

[PeterClemmensen · Accepted solution]

ddmmyy10. format will do the trick

data temp;
input datum:ddmmyy10.;
format datum ddmmyy10.;
datalines;
01.11.2017
;

[dirks]

Thanks a lot!

[PeterClemmensen]

Anytime, glad to help 🙂

[Kurt_Bremser]

To make the displayed format look exactly like the input, use the format

ddmmyyp10.

to replace the slashes with dots.