BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MaryA_Marion
Lapis Lazuli | Level 10

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?  

 

MM

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
*/

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Patrick
Opal | Level 21
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

 

 

View solution in original post

2 REPLIES 2
Patrick
Opal | Level 21
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

 

 

MaryA_Marion
Lapis Lazuli | Level 10
Thanks. I was looking at what MMDDYY could read in... MM

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 480 views
  • 1 like
  • 2 in conversation