topic Re: Problem in import a CSV file with delimiter as “;” in Statistical Procedures

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

Neal3321 — Fri, 29 Jan 2021 12:52:51 GMT

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=p0k757c8q63cfun1n3k3ha2pqmdz.htm&locale=en).

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.

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

Kurt_Bremser — Fri, 29 Jan 2021 12:59:41 GMT

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

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

Ksharp — Fri, 29 Jan 2021 13:03:34 GMT

Try
delimiter=';';

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

Aku — Fri, 29 Jan 2021 13:18:09 GMT

Remove semicolon after replace, because that closes Proc Import .

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

Neal3321 — Fri, 29 Jan 2021 13:20:03 GMT

Thanks!!!!