input SAS date

[Rakeon]

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!

[Peter_C]

What code have you tried?

[Rakeon]

I have resolved the problem.

it was the dsd option.

it dosn't need.

[Peter_C · Accepted solution]

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.

[Rakeon]

Hi Peter,

it work with : before the data.

Thank you.