topic Converting a csv file to a sas table in SAS Programming

Converting a csv file to a sas table

MILKYLOVE — Wed, 21 Sep 2022 09:39:33 GMT

Hello all,

I am trying to convert a csv file to a SAS table using the code below:

proc import out= work.scores
     datafile ="c:/mydir/scores_*.csv"
     dbms=csv
     replace;
     delimiter="|";
     getnames=YES;
run;

However the first column of my file is not giving the correct value in the table

CSV FILE:

Table:

Please help me to get the number right.

Re: Converting a csv file to a sas table

andreas_lds — Wed, 21 Sep 2022 12:06:15 GMT

The data you have posted is a perfect demonstration why relying on proc import is a bad idea. Instead of reading the first variable as char, the contents of the variable causes sas to set the wrong type. So: don't use proc import write a data step yourself.

Untested:

data work.scores;
  infile "C:/mydir/scores_*.csv" delimiter= "|" firstobs= 2 missover;
  length 
    number $14 
    dab rc construction flotte snt_col pre_col $ 1
    activities $ 200
  ;
  input number -- activities;
run;

If you want to see the real contents of a csv file, open it using a text editor, not Excel.