topic Re: SAS CSV File error and file names in SAS Programming

SAS CSV File error and file names

sasuser101 — Tue, 29 May 2018 21:30:45 GMT

Hi,

i am reading multiple SAS Files assuming headers are on first row. i use firstobs=2 and there are no issues with files having headers on first row. but when headers span on row 2 and/or row 3 then i get error in log saying invalid data and has _error_= 1 and _n_=1 variable which is expected BUT is there a way to capture csv files names and count of those csv files IN macro variable when this error is triggered. i want to display custom message something like

"There are 2 files with incorrect headers and names of files are A.csv, B.csv. Please update file and rerun."

Re: SAS CSV File error and file names

Tom — Tue, 29 May 2018 21:52:20 GMT

Probably. Please explain in more detail what exactly you are currently doing. preferable with code that we can run to test.

Re: SAS CSV File error and file names

ballardw — Tue, 29 May 2018 22:16:07 GMT

Assuming, since no code was included, that your FIRSTOBS=2 is on a INFILE statement you might try adding a FILENAME= option to the infile statement which would add a temporary variable similar to _n_ you could reference

data want;

infile "path/name" dlm=',' firstobs=2 filename=myinfile;

input <varlist>;

if _error_=1 and _n_=1 then call symputx('possbadfile',myinfile);

run;

It would be up to you to provide additional logic for using that &possbadfile macro variable to make that message string.

Maybe. guessing because code would give a much better starting point.

Re: SAS CSV File error and file names

Reeza — Tue, 29 May 2018 22:39:09 GMT

Why a macro variable?

I think you need to explain more. There are ways to handle data with multiple headers.

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627