topic Input antics - reading date fields with column input. in SAS Programming

Input antics - reading date fields with column input.

PGStats — Fri, 17 Feb 2012 18:16:46 GMT

I have a question about something I must have forgotten...

Why does test1 fail, but not test2 or test3?

data test1;
informat d date9.;
input d 1-9;
datalines;
01JAN1999
;

data test2;
length dTxt $9;
input dTxt 1-9;
d = input (dTxt, date9.);
datalines;
01JAN1999
;

data test3;
input d :date9.;
datalines;
01JAN1999
;

PG

Input antics - reading date fields with column input.

art297 — Fri, 17 Feb 2012 18:21:09 GMT

According to the documentation:

Note: You cannot use an informat with column input.

Input antics - reading date fields with column input.

PGStats — Fri, 17 Feb 2012 18:23:46 GMT

That settles that! Thanks.

PG

Input antics - reading date fields with column input.

Tom — Fri, 17 Feb 2012 20:28:47 GMT

Use @.

data test1b;

informat d date9.;

format d date9.;

input @1 d ;

put d=;

datalines;

01JAN1999

;

data test1c;

format d date9.;

input @1 d date9.;

put d=;

datalines;

01JAN1999

;