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

Tell e how how dealt with..

1769

---

How would you include common or reuse to be processed along with your statements?

1899

---

What are the statements that are executed only?

672

---

What are the differences between proc means and proc summary?

602

---

Explain the purpose of retain statement.

601

---

---

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

550

---

What are the features of SAS?

576

---

do you prefer proc report or proc tabulate? Why? : Sas programming

572

---

how can you create zero observation dataset? : Sas programming

638

---

explain about sas business intelligence? : Sas-bi

596

---

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

696

---

What is Linear Regression?

687

---

what is sas application server? : Sas-di

538

---

What is the good sas programming practices for processing large data sets?

628

---

what are some good sas programming practices for processing very large data sets? : Sas programming

509

---