Help using Base SAS procedures

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

Reply
Occasional Contributor
Posts: 5

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

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,A2Smiley Surprised22);
N/A
Posts: 0

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

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
Ask a Question
Discussion stats
  • 1 reply
  • 83 views
  • 0 likes
  • 2 in conversation