Hi @RW9, Yes that was an example. I wrote the code: data Observation;
infile "/folders/myshortcuts/Observations/file.csv" dlm=";";
length Code $8. Townname $20. State_Code $20. State_Name $20. State_M_Name $20. Township_Code $20. Township_Name $20. Township_M_Name $20.;
format Code $8. Townname $20. State_Code $20. State_Name $20. State_M_Name $20. Township_Code $20. Township_Name $20. Township_M_Name $20.;
informat Code $8. Townname $20. State_Code $20. State_Name $20. State_M_Name $20. Township_Code $20. Township_Name $20. Township_M_Name $20.;
input Code Townname State_Code State_Name State_M_Name Township_Code Township_Name Township_M_Name;
run; And it worked. However, I did not understand the technique cited on running a proc import on the csv file. I think it is because it uses the delimiter "," and not ";". I have a csv file with semicolon as delimiter maybe because the laptop is french. The log gives me: 86 data WORK._OBSERVATION2 ;
87 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
88 infile '/folders/myshortcuts/Observations/file.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
89 informat Code_Townname_State_Code_State $76. ;
90 format Code_Townname_State_Code_State $76. ;
91 input
92 Code_Townname_State_Code_State $
93 ;
94 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
95 run; Also, it is the wrong informat, format and input. That is maybe why I have a weird file with the proc import. Thanks a lot, Stephanie
... View more