topic Import csv with 2 variables in New SAS User

Import csv with 2 variables

Lars45 — Wed, 25 Sep 2019 11:55:06 GMT

Hey SAS-Community,

i'm working on a programm which has to import periodical several csv-datas. My current solution looks like this:

%macro imp(infile);
PROC IMPORT datafile = "C:\Users\..."
OUT=work.&infile

DBMS=csv REPLACE;
DELIMITER = ';';

GETNAMES=YES;

datarow=2;

run;

Data work.&infile ;
set work.&infile ;
Reporting_month = Put(Today(),YYMMN6.);
run;

%mend imp;
%imp(System1_201909)
%imp(System2_201909)

So far, it works quite good. Now i'd like to change the "201909" of the macrovariables automatically to the acctual year and date. All my attemps were not successful, so far.

Thanks for your help!

Lars

Re: Import csv with 2 variables

FreelanceReinh — Wed, 25 Sep 2019 12:30:21 GMT

Hi @Lars45,

Do you mean this?

%imp(System1_%sysfunc(today(),yymmn6.))

Re: Import csv with 2 variables

Lars45 — Wed, 25 Sep 2019 12:36:49 GMT

I did not expect the solution to be so simple^^

Thank you!

Re: Import csv with 2 variables

ballardw — Wed, 25 Sep 2019 14:54:29 GMT

Relying on Proc Import to read many files often leads to inconsistency between the variable types and lengths of character variables. As a minimum I would suggest that you add a GUESSINGROWS statement to the Proc Import code with a largish value. Better in the long run might be to write a proper data step to read that file so you can control all of the variable properties.

Re: Import csv with 2 variables

Tom — Wed, 25 Sep 2019 17:57:11 GMT

If the text file only has two variables why are you using PROC IMPORT?

data want;
 infile 'myfile.txt' dsd dlm=';' truncover firstobs=2;
 input var1 var2;
run;