Hello community,
I've tried several different ways in an attempt to pass the location of the excel file to this macro.
But I keep getting nothing. My logs just showed the code I rant. So I started using option symbolgen and mlogic
to see if that would produce something for me. It did. It at least gave me the value of &path.
Also I did hard code this and it worked perfectly fine.
PLEASE HELP AND THANKS IN ADVANCE
I'm using Base SAS 9.4
options symbolgen mlogic; %Let path = C:\mysdtm\SDTM_METADATA.xlsx; %put NOTE: &path; %macro make_blank_dataset(metadatafile=,dataset=); proc import datafile="&metadatafile" out=_temp
options symbolgen mlogic;
%Let path = C:\mysdtm\SDTM_METADATA.xlsx;
%put NOTE: &path;
%macro make_empty_dataset(metadatafile=,dataset=);
proc import
datafile="&metadatafile"
out=_temp
dbms=excelcs
replace;
sheet="VARIABLE_METADATA";
run;
%mend make_empty_dataset;
%macro make_empty_dataset(path, AE);
dbms=excelcs replace; sheet="VARIABLE_METADATA"; run; %mend make_empty_dataset; %macro make_blank_dataset(path, AE);
... View more
