read in of date without using infile statement

MaryA_Marion — Wed, 16 Oct 2019 02:54:24 GMT

Unless I use the infile statement I don't seem to be able to have sas read in the date. Please check the following syntax. Why is the MMDDYYYY10. not loading?

data makeup;
input LastNamePart $7. +1  state $ @13 date MMDDYYYY10. receiver $ amount;
informat date MMDDYYYY10.;
format date MMDDYYYY10.;
cards;
Church  NY  01/02/1942 Birch   55
Church  Ny  02/03/1943 Johnson 45
Moorman ny  03/04/1944 Henry   65
Marion  Va  04/05/1945 Jackson 75
Church  VT  05/06/1946 Jones   25
;
run;
proc print; run;

/*
 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data makeup;
 74         input LastNamePart $7. +1  state $ @13 date MMDDYYYY10. receiver $
                                                        ___________
                                                        485
 74       ! amount;
 75         format date MMDDYYYY10.;
                        ___________
                        484
 NOTE 485-185: Informat MMDDYYYY was not found or could not be loaded.
 
 NOTE 484-185: Format MMDDYYYY was not found or could not be loaded.
 
 76         cards;
 
 NOTE: Invalid data for date in line 77 13-22.
 RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+---
 77         Church  NY  01/02/1942 Birch   55
 LastNamePart=Church state=NY date=. receiver=Birch amount=55 _ERROR_=1 _N_=1
 
 83         run;
 ...
 NOTE: There were 5 observations read from the data set WORK.MAKEUP.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.08 seconds
       cpu time            0.08 seconds
*/

Re: read in of date without using infile statement

Patrick — Wed, 16 Oct 2019 03:05:03 GMT

NOTE 485-185: Informat MMDDYYYY was not found or could not be loaded.

That's because the name of the format is MMDDYY and not MMDDYYYY

Re: read in of date without using infile statement

MaryA_Marion — Wed, 16 Oct 2019 03:24:09 GMT

Thanks. I was looking at what MMDDYY could read in... MM

topic Re: read in of date without using infile statement in New SAS User

read in of date without using infile statement

Re: read in of date without using infile statement

Re: read in of date without using infile statement