Date Read Error

BrahmanandaRao — Thu, 09 May 2019 07:26:49 GMT

data dsn;
input id 1-3 visit_date 4-12 ;
informat visit_date date 10.;
format visit_date date 11.;
datalines;
001 05-may-2019
002 05-jun-2019
003 05-jul-2019
004 05-aug-2019
005 05-sep-2019
;
run;

I got error like below

NOTE: Variable date is uninitialized.
NOTE: Invalid data for visit_date in line 144 4-12.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
144 001 05-may-2019
id=1 visit_date=. date=. _ERROR_=1 _N_=1
NOTE: Invalid data for visit_date in line 145 4-12.
145 002 05-jun-2019
id=2 visit_date=. date=. _ERROR_=1 _N_=2
NOTE: Invalid data for visit_date in line 146 4-12.
146 003 05-jul-2019
id=3 visit_date=. date=. _ERROR_=1 _N_=3
NOTE: Invalid data for visit_date in line 147 4-12.
147 004 05-aug-2019
id=4 visit_date=. date=. _ERROR_=1 _N_=4
NOTE: Invalid data for visit_date in line 148 4-12.
148 005 05-sep-2019
id=5 visit_date=. date=. _ERROR_=1 _N_=5
NOTE: The data set WORK.DSN has 5 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

149 ;
150 run;

Re: Date Read Error

PeterClemmensen — Thu, 09 May 2019 08:55:03 GMT

Is there a reason you want to use column pointers? Why not simply:

data dsn;
input id visit_date :date11.;
format visit_date date11.;
datalines;
001 05-may-2019
002 05-jun-2019
003 05-jul-2019
004 05-aug-2019
005 05-sep-2019
;
run;

Re: Date Read Error

Astounding — Thu, 09 May 2019 09:09:10 GMT

Format and informat names must be one word, not two. Remove the extra blank:

format visit_date date11.;
Informat visit_date date11.;

topic Date Read Error in New SAS User

Date Read Error

Re: Date Read Error

Re: Date Read Error