Answer Posted / lucylu

%macro read_moresheets(ifile, lib);
libname ixls excel &ifile;

proc sql;
select memname into :ds1 - :ds100
from sashelp.vtable
where libname = "IXLS" and index(memname,'$') = 0
;
quit;

%put _user_;

%do i = 1 %to &sqlobs;
data &lib..&&ds&i;
set ixls.&&ds&i;
run;
%end;
%mend;
%read_moresheets("C:\Ongoing\CallActivity.xls", work);

where to use sas business intelligence? : Sas-bi

1003

---

what are sas/access and sas/connect? : Sas programming

941

---

Can you execute a macro within a macro? Describe. : sas-macro

1067

---

What is the maximum and minimum length of macro variable

1165

---

Name types of category in which SAS Informats are placed?

1087

---

How to create list output for cross-tabulations in proc freq?

1060

---

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2125

---

Intern stastical programmer written test

679

---

What are the automatic variables for macro? : sas-macro

1139

---

If money were no object, what would you like to do?

3129

---

Have you ever used the SAS Debugger?

1693

---

what are validation tools that are used in sas? : Sas-administrator

1001

---

What is the use of %include statement?

995

---

What is the maximum length of the macro variable? : sas-macro

1045

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

997

---