topic Re: Importing csv file with date format error in SAS Programming

Importing csv file with date format error

Yughaber — Tue, 20 Oct 2020 07:15:21 GMT

I am trying to import a csv file using the code below, however, for the date column SAS is giving me the NOTE: Invalid data for Date in line 2 40-48. And it also says DOB=. _ERROR_=1 _N_=1

data BH;

infile 'C:\desktop\NewDemo\apeal2.csv' dsd firstobs=2 truncover;

length ID 8 Race $32. Ethnicity $32 Gender $20;

input ID Race Ethnicity Gender Date;

format Date date9.;

run;

Re: Importing csv file with date format error

Kurt_Bremser — Tue, 20 Oct 2020 07:43:30 GMT

There is no variable DOB in the code you posted, so the log message cannot be from that step.

Please post the complete log from the failing step; use this button to post the log:

Re: Importing csv file with date format error

Shmuel — Tue, 20 Oct 2020 07:47:48 GMT

You did not assigned informat for the input date.

Please post:

a sample of your input CSV file - at least 3 lines.
please post the full log.
Use the '<>' menu option and copy/paste the sample lines as the log into the open window.

Re: Importing csv file with date format error

Yughaber — Tue, 20 Oct 2020 16:17:14 GMT

I am sorry but I don't have/see that </> in my toolbar

237 data BH;
238 infile 'C:\desktop\NewDemo\apeal2.csv' dsd firstobs=2 truncover
238! firstobs=2 truncover;
239 length ID 8 RACE $32 ETHNICITY $40 Gender $20;
240 input ID RACE ETHNICITY Gender Date;
241 format Date mmddyy10.;
242 run;

NOTE: The infile
'C:\desktop\NewDemo\apeal2.csv' is:
Filename= C:\desktop\NewDemo\apeal2.csv,
RECFM=V,LRECL=35677,File Size (bytes)=18522591,
Last Modified=19Oct2020:22:08:43,
Create Time=18Oct2020:00:57:44

NOTE: Invalid data for Date in line 2 50-58.
RULE: ----+----1----+----2----+----3----+----4----+----5----
2 333333333,Other,Hispanic or Latino,Male,6/20/
55 1953 58
ID=333333333 RACE=Other ETHNICITY=Hispanic or Latino
Gender=Male Date=. _ERROR_=1 _N_=1
NOTE: Invalid data for Date in line 3 54-61.
3 333333333,Asian,Non Hispanic or Latino,Male,3
55 /2/1970 61
ID=333333333 RACE=Asian ETHNICITY=Non Hispanic or Latino
Gender=Male Date=. _ERROR_=1 _N_=2

Re: Importing csv file with date format error

Kurt_Bremser — Tue, 20 Oct 2020 16:33:47 GMT

Add a delimiter to the INFILE statement, and the proper informat:

data BH;
infile
  'C:\desktop\NewDemo\apeal2.csv'
  dlm=','
  dsd
  firstobs=2
  truncover
;
length ID 8 RACE $32 ETHNICITY $40 Gender $20 date 4;
input ID RACE ETHNICITY Gender Date :mmddyy10.;
format Date mmddyy10.;
run;

Re: Importing csv file with date format error

Yughaber — Tue, 20 Oct 2020 19:56:34 GMT

Thank you so much!! This worked 🙂 I was pounding my head for so long. I've been following your replies in numerous posts and there is a lot to learn from you.