Problem in import a CSV file with delimiter as “;”

[Neal3321]

Hello all,

I have a csv file that use ";" as the delimiter. I use the following code to import based on this instruction (https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=p0k757c....  

proc import datafile="C:\downloads\2002-09.txt"
out=test
dbms=dlm
replace;
dlm=';';
run;

However, SAS mentions the error as following.

103
104  proc import out=test DATAFILE= "C:\Downloads\2002-09.csv"
105  out =test
106  dbms=dlm
107  replace;
NOTE: The previous statement has been deleted.
108  dlm=";";
     ---
     180
ERROR 180-322: Statement is not valid or it is used out of proper order.

109  run;


NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

How could I address this problem? Many thanks

P.s. I attach a screenshot for the dataset.

[Kurt_Bremser]

Remove the second OUT= option from the PROC IMPORT statement.

[Ksharp · Accepted solution]

Try
delimiter=';';

[Neal3321]

Thanks!!!! 

[Aku]

Remove semicolon after replace, because that closes Proc Import .