topic Re: Read German date format in data step in SAS Procedures

Read German date format in data step

dirks — Thu, 16 Nov 2017 13:29:37 GMT

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

Re: Read German date format in data step

Cynthia_sas — Thu, 16 Nov 2017 13:36:02 GMT

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

Re: Read German date format in data step

PeterClemmensen — Thu, 16 Nov 2017 13:36:29 GMT

ddmmyy10. format will do the trick

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

Re: Read German date format in data step

dirks — Thu, 16 Nov 2017 13:56:36 GMT

Thanks a lot!

Re: Read German date format in data step

PeterClemmensen — Thu, 16 Nov 2017 14:00:05 GMT

Anytime, glad to help 🙂

Re: Read German date format in data step

Kurt_Bremser — Thu, 16 Nov 2017 14:49:39 GMT

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

ddmmyyp10.

to replace the slashes with dots.