topic Re: how do I avoid any truncation in the fexist() function? in SAS Programming

how do I avoid any truncation in the fexist() function?

ZRick — Tue, 17 Apr 2012 01:15:25 GMT

%let fname=&dataroot&psep.st_26.csv;

%macro TABLES;

%if %sysfunc(fexist(&fname)) %then

%do;

filename st_spec &fname;

data st_26;

infile st_spec dsd firstobs=2 truncover dlm=',';

input date:mmddyy10.;

run;

%end;

%else %do;

%put No schedule table exists;

%end;

%mend

In a call to the FEXIST routine, the fileref /home/rwn/ksde/data/ftp/st_26.csv exceeds 8 characters, and will be truncated.

Because of this, it is returned the wrong result.

how do I fix it?

shivas — Tue, 17 Apr 2012 06:21:43 GMT

Hi,

Try this...Hope it helps..

%let fname=&dataroot&psep.st_26.csv;

%macro TABLES;

filename st_spec "&fname";

%if %sysfunc(fexist(&fname)) %then

%do;

data st_26;

infile st_spec dsd firstobs=2 truncover dlm=',';

input date:mmddyy10.;

run;

%end;

%else %do;

%put No schedule table exists;

%end;

%mend;

%tables;

Thanks,

Shiva

Ksharp — Tue, 17 Apr 2012 06:59:18 GMT

Use fileexist() to replace fexist().

Ksharp