two questions about read data from a csv file

[tianerhu]

the first question:

how to read the data in the csv file which have variable names in the first row? like below :

the second question:

the 'Hire Date' variable, there is one blank in it , how to read ?

Name,Hire Date,Company,Country,Date of Birth
Gisela S. Santos,8/12/17,Pede Nunc Sed Limited,Micronesia,8/21/1971
Maxwell L. Cooley,9/4/17,A LLP,Somalia,4/30/1975
Thane P. Obrien,10/28/17,Consectetuer Limited,Jamaica,4/23/1988
Minerva C. Conley,1/5/18,Feugiat Tellus Lorem Institute,Fiji,2/18/1975
Kylee R. Finch,10/31/17,Magna Incorporated,Myanmar,5/18/1973
Calista F. Chambers,9/11/17,Facilisis Incorporated,Libya,3/4/1972
Fuller X. Bradford,1/27/18,Morbi Incorporated,Saint Pierre and Miquelon,12/1/1976

[Kurt_Bremser]

You use FIRSTOBS=2 in the INFILE statement to read over the header line.

And you define the names of variables in the code (particularly the INPUT statement), so what is written in the header line is mostly irrelevant.

[tianerhu]

Thank you for your help.

[Reeza · Accepted solution]

how to read the data in the csv file which have variable names in the first row?

FIRSTOBS=2 in the INFILE statement.

there is one blank in it , how to read ?

Look at the TRUNCOVER/MISSOVER options on the INFILE statement. 

if the delimiter is properly specified in the middle it will read correctly, if it's at the end you need to ensure it doesn't try to read from a new line so the TRUNCOVER option is required. Your example doesn't show any missing data however so not sure what you're referring to.

Probably worth skimming the documentation to see what other options are available. 

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/n1rill4udj0tfun1fvce3j401plo.htm

---

@tianerhu wrote:

the first question:

how to read the data in the csv file which have variable names in the first row? like below :

the second question:

the 'Hire Date' variable, there is one blank in it , how to read ?

Name,Hire Date,Company,Country,Date of Birth
Gisela S. Santos,8/12/17,Pede Nunc Sed Limited,Micronesia,8/21/1971
Maxwell L. Cooley,9/4/17,A LLP,Somalia,4/30/1975
Thane P. Obrien,10/28/17,Consectetuer Limited,Jamaica,4/23/1988
Minerva C. Conley,1/5/18,Feugiat Tellus Lorem Institute,Fiji,2/18/1975
Kylee R. Finch,10/31/17,Magna Incorporated,Myanmar,5/18/1973
Calista F. Chambers,9/11/17,Facilisis Incorporated,Libya,3/4/1972
Fuller X. Bradford,1/27/18,Morbi Incorporated,Saint Pierre and Miquelon,12/1/1976

---

[tianerhu]

Thanks a lot.