Hi all!!
I have a problem to make an infile of this csv file:
a b c d
1 asd 10/10/2000 adfg
2 abd 10/10/2000 vdfg
3 afd 10/10/2000 bdf
4 axd 10/10/2000 bfdg
It is ok, when I make the input until data sas(I would like to have data sas in number format without any character format), but after I have a problem to make an import of column d.
The final dataset, shows correctly the columns a,b,c but the columns d is completely missing.
what should I do? how do you make the input file?
Thanks!
From the code that was posted earlier...
data infile;
length a 8
b $4
dt 8
cd $4;
infile csv firstobs=2 delimiter=';' missover dsd;
input a
b $
dt ddmmyy10.
cd $;
run;
As well as removing that DSD option (but only when appropriate)
I would suggest inserting : before the ddmmyy10. format.
this ensures the floating -type input continues through the date.
What code have you tried?
I have resolved the problem.
it was the dsd option.
it dosn't need.
From the code that was posted earlier...
data infile;
length a 8
b $4
dt 8
cd $4;
infile csv firstobs=2 delimiter=';' missover dsd;
input a
b $
dt ddmmyy10.
cd $;
run;
As well as removing that DSD option (but only when appropriate)
I would suggest inserting : before the ddmmyy10. format.
this ensures the floating -type input continues through the date.
Hi Peter,
it work with : before the data.
Thank you.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.