View original (French)

Import CSV => SAS Strange Data

LLP -  
 Marieb -
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 réponses

Réponse 1 / 2
yannours
 
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)
0
Réponse 2 / 2
Marieb
 
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?
0