Hi,
I have several excel workbook with multiple sheets that I'm dynamically loading. I have a couple of the workbooks that have a spreadsheets that are blank. This fails to load correctly as the dataset has no rows but does get created with data issues. I've tried %sysfunc(exist( but doesn't work correctly as the dataset does get created. How can I get this to work? I tried using an array to check and set a variable to skip it also. The array says the array is empty and stops.
data _null_;
set &&sheet&i;
array _c{*} _character_;
array _n{*} _numeric_;
if missing(coalesceC(of _c{*})) and missing(coalesce(of _n{*})) then do;
call symputx('emptyds','Y');
end;
else do;
call symputx('emptyds','N');
end;
run;
... View more