I have a text file "Macro definition" which has two SAS macros definition. I would like to import them and apply on HTWT.csv data set. This dataset has 20 observations and 6 variables ID, Gender, Age,Height,Weight,Year. All are numeric except gender variable. I have the code below to import and apply the macros from the txt file to csv file. I am getting an error message on running this code as below.
%macro import_myfile(i=); proc import file="C:\Users\komal\Desktop\Advanced SAS\Macro definition.txt" out=Macrodefinition dlm='09x' replace; run; %mend import_myfile; %include Macrodefinition; Error: Unable to complete processing of INCLUDE. Expected a filename or fileref Failed to open macro : The system cannot find the file specified
Please let me know your advice on how to solve it. Thank you for your time.