topic Date Informat in SAS Programming

Date Informat

andreas4 — Fri, 17 Sep 2021 11:34:29 GMT

Hello!

What informat should i use to read the following data values as numeric variables form a csv?

"Sun, 22 Feb 2004"
input date:?????

Thanks in advance,

Andreas

Re: Date Informat

PaigeMiller — Fri, 17 Sep 2021 11:49:18 GMT

First, remove the day of the week from the text string. Compress the blanks, and then the date9 informat should work.

data a;
    y='22 Feb 2004';
    x=input(compress(y),date9.);
    format x date9.;
run;

Re: Date Informat

ballardw — Fri, 17 Sep 2021 21:23:37 GMT

@andreas4 wrote:

Hello!

What informat should i use to read the following data values as numeric variables form a csv?
"Sun, 22 Feb 2004"
input date:?????

Thanks in advance,

Andreas

If that is the way the data is in the CSV you likely will need to read the value as character then so something like:

data example;
  x="Sun, 22 Feb 2004";
  y= input(scan(x,2,','),anydtdte16.);
  format y date9.;
run;

to create a date value.