topic Re: two questions about read data from a csv file in SAS Programming

two questions about read data from a csv file

tianerhu — Wed, 19 May 2021 21:17:20 GMT

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

Re: two questions about read data from a csv file

Kurt_Bremser — Wed, 19 May 2021 21:32:34 GMT

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.

Re: two questions about read data from a csv file

Reeza — Wed, 19 May 2021 21:43:18 GMT

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

Re: two questions about read data from a csv file

tianerhu — Wed, 19 May 2021 23:25:20 GMT

Thank you for your help.

Re: two questions about read data from a csv file

tianerhu — Wed, 19 May 2021 23:25:57 GMT

Thanks a lot.