I have to extract data from excel sheets iif I use this procedure it works fine
but I have to create a mackro for this so that I can extract data from diffrent sheets and need not copy paiste all code again and again but when I execute macro it produces the same output data set with new name which I have given. plz help me with this urgently. Thanks in advance.
PROC IMPORT OUT=S11515
DATAFILE="G:\sa sas BI\sd\Complete Spreadsheet 10 Asthma patients.xls"
DBMS=EXCEL2000 REPLACE;
SHEET="'Subject Demo$'";
GETNAMES=YES;
RANGE='a2:f32';
MIXED=YES;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
options mprint mlogic symbolgen serror merror;
%let ss="G:\sa sas BI\sd\Complete Spreadsheet 10 Asthma patients.xls";
%macro datain(sht,rng);
PROC IMPORT OUT=h11
DATAFILE=&ss
DBMS=EXCEL2000 REPLACE;
SHEET="'&sht$'";
GETNAMES=YES;
RANGE='&rng';
MIXED=YES;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
%mend;
%datain(History,A2:O22);