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
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
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.
Thank you for your help.
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
Thanks a lot.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: