topic Re: input SAS date in SAS Procedures

input SAS date

Rakeon — Sun, 14 Sep 2014 16:09:04 GMT

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!

Re: input SAS date

Peter_C — Sun, 14 Sep 2014 16:42:39 GMT

What code have you tried?

Re: input SAS date

Rakeon — Sun, 14 Sep 2014 18:53:03 GMT

I have resolved the problem.

it was the dsd option.

it dosn't need.

Re: input SAS date

Peter_C — Sun, 14 Sep 2014 20:17:35 GMT

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.

Re: input SAS date

Rakeon — Fri, 19 Sep 2014 18:34:45 GMT

Hi Peter,

it work with : before the data.

Thank you.