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

What are pdv and it functions?

1243

---

what is the purpose of _error_? : Sas programming

1188

---

What are the special input delimiters used in SAS?

1238

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2306

---

What is SAS informats?

1162

---

How do dates work in sas?

1187

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1110

---

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1082

---

How to test the debugging in sas?

1243

---

what is sas olap server? : Sas-di

1293

---

Mention the category in which sas informats are placed?

1076

---

what is the primary data source for the wrs? : Sas-bi

1332

---

explain the difference between proc means and proc summary?

1182

---

Difference between informat and format?

1141

---

Describe crosslist option in tables statement?

1263

---