topic Re: Import if exists in SAS Programming

Import if exists

Ronein — Sun, 26 Sep 2021 07:53:27 GMT

Hello

I want to import files into sas if they exists.

These files that I want to import has name structure RevenueYYYYMMDD.

It means that I enter dates in a data set and I want to import files with these names.

What is wrong with my code that I get an error

data Source&FileImport. ;
set datestbl;
filename = "/path/Revenue&FileImport..txt";
if fileexist(filename) then do;
 proc import datafile ="/path/Revenue&FileImport..txt"
 out=wanted&FileDate.
 dbms = dlm
 replace
 ;
 delimiter = ';';
 end;
run;     
/*47          proc import datafile ="/path/Revenue&FileImport..txt"*/
/*           _*/
/*           117*/
/**/
/*ERROR 117-185: There was 1 unclosed DO block.*/

Re: Import if exists

Patrick — Sun, 26 Sep 2021 08:31:51 GMT

You can't mix Data Steps and Proc Steps.

You could wrap your proc import into a SAS macro defined before the data step and then use call execute() in the data step to call the macro.

Call Execute() will stack up the macro calls and then execute them once the data step completed.

If your monthly data should always have the same structure and result in SAS tables with the same variable names AND variable attributes like lengths then I'd strongly recommend that you don't use Proc Import but an explicit INPUT statement.

Re: Import if exists

PaigeMiller — Sun, 26 Sep 2021 09:48:15 GMT

You can use the same solution as in your earlier thread at

https://communities.sas.com/t5/SAS-Programming/proc-delete-data-set-if-exists/m-p/755250

modified appropriately to use PROC IMPORT instead of PROC DELETE.

Re: Import if exists

Ronein — Sun, 26 Sep 2021 12:12:54 GMT

May you please let me know if this code will work well?

%macro import_one(date);
%if%sysfunc(fileexist(path/revenue&date..csv))
%then%do;
HERE write PROC IMPORT
%end;
%mend;

Data dates_tbl;
input dates $;
cards;
20210603
20210601
20210528
20210514
;
Run;


Data _Null_;
SET dates_tbl;
callexecute('%nrstr(%import_one('!!date!!'))');
Run;

Re: Import if exists

PaigeMiller — Sun, 26 Sep 2021 12:22:16 GMT

@Ronein wrote:

May you please let me know if this code will work well?

You can run it yourself and find out if it works.

Re: Import if exists

Ronein — Sun, 26 Sep 2021 12:23:16 GMT

I ask theortically if it will be fine after reading your inputs

Re: Import if exists

PaigeMiller — Sun, 26 Sep 2021 12:25:48 GMT

Some things you can find out for yourself.

Re: Import if exists

Ronein — Sun, 26 Sep 2021 12:37:18 GMT

I have no SAS now but i will have a look when I have SAS available,cheers