Plz help me with this code of macro urgent!!!

Parashar — Sun, 21 Jun 2009 18:04:41 GMT

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);

Re: Plz help me with this code of macro urgent!!!

deleted_user — Sun, 21 Jun 2009 18:46:20 GMT

Hello Parashar,

You enclosed the range between single quotes. If you proceed this way, the range variable will not be resolved. You have to enclose the range between double quotes.

Does it solve the problem?

Yoba

topic Re: Plz help me with this code of macro urgent!!! in SAS Procedures

Plz help me with this code of macro urgent!!!

Re: Plz help me with this code of macro urgent!!!