Import CSV => SAS Strange Data

Hello,

I have a whole list of Csv files to import into SAS. I'm coding my import like this:
DATA WORK.mai1;
INFILE "C:\Loic\...\01 Juin.csv"
DELIMITER=','
MISSOVER
DSD
LRECL=32767
FIRSTOBS=2
;
format Titre $50.;
format date_et_nbr_appels_selectionnees $70.;
format _Temps_de_conversation $70.;
informat Titre $50.;
informat date_et_nbr_appels_selectionnees $70.;
informat _Temps_de_conversation $70.;
input
Titre
date_et_nbr_appels_selectionnees
_Temps_de_conversation
;

The original csv file is quite normal.
However, at the end of the import, when I print my table on the first 10 observations, every character of all my variables is preceded by a space. If I open my table with SAS viewer, then every character is preceded by |.
I have tried to compress my variables but that of course had no effect.
The original file does not seem to be corrupted because I opened it with the Windows command prompt and there didn't seem to be any particular issues.

Thank you in advance for your advice.
Configuration: Windows 2000 Internet Explorer 6.0

2 answers

  • Votes
  • Date
  • Descending date
  1. Hello,

    Work around the problem, a csv file is a file with a separator;

    Importing with a separator works very well :-)

    Might as well save your .csv file as .txt first... (but I don't think so)
    1. Have you tried the import with the proc import?
      If not, can you send the .csv file so we can see better what it does during the import?