When I pass a file value as file path and file in a macro, why I continue to hit errors with an extra slash '/' in front of the file name:
%LET fn="/dir/folder/filename.xls";
%ImportDataSheet(df=&fn.);
The Macro code
"proc import datafile=&df dbms=xls out=resulename replace;"
got a "Can not load sas log" error, with the below file path/name showing:
/dir/folder//filename.xls
The program inserted an extra '/' in front of the file name, preventing successful loading of the file.
How do I successfully pass file path/name variables?
Appreciate your help on this very much!
... View more