The following is a csv file
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
the following is my code:
data ABC;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
input name $16. hire_date company $ country $ date_of_birth;
run;
proc print data = ABC;
run;the following is output:
how to read the hire_date and date_of_birth ?
Accepted Solutions
the length is not enough, you are right.
data ABC;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
length name $ 20 company $ 32;
input name $ hire_date company $ country $ date_of_birth;
informat hire_date date_of_birth mmddyy10.;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;
now it is correct.
data ABC;
informat hire_date date_of_birth mmddyy10.;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
input name $ hire_date company $ country $ date_of_birth;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;
Now , the code is closer to the correct , leave the name and company variables is not read properly.
data ABC;
informat hire_date date_of_birth mmddyy10.;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
length name $ 16 company $ 25;
input name $ hire_date company $ country $ date_of_birth;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;
Perfect .
the length is not enough, you are right.
data ABC;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
length name $ 20 company $ 32;
input name $ hire_date company $ country $ date_of_birth;
informat hire_date date_of_birth mmddyy10.;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;now it is correct.
what I have done ? I am so careless.
Thank you for your remind.
data ABC;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
length name $ 20 company $ 32 country $10;
input name $ hire_date company $ country $ date_of_birth;
informat hire_date date_of_birth mmddyy10.;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;
My my my !
data ABC;
infile 'C:\Users\liaodong\Documents\My SAS Files\prep guide\base
\practice data\cert\new_hires.csv' dsd firstobs=2;
length name $ 20 company $ 32 country $ 25;
input name $ hire_date company $ country $ date_of_birth;
informat hire_date date_of_birth mmddyy10.;
format hire_date date_of_birth mmddyy10.;
run;
proc print data = ABC;
run;
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.
-
1975 views
-
0 likes
-
-
