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

Explain the difference between nodup and nodupkey options?

1017

---

Describe the function and untility of the most difficult SAS macro that you have written.

2093

---

what is slowly changing dimension? : Sas-di

1114

---

what is the function of catx syntax? : Sas-administrator

1092

---

What makes sas stand out to be the best over other data analytics tools?

1053

---

Explain append procedure?

1072

---

Mention the category in which sas informats are placed?

1011

---

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1007

---

Tell e how how dealt with..

2215

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

998

---

What are common programming errors committed in sas

1136

---

What is maximum number of rows and cols can be handled in SAS?

1570

---

AE datasets names? how many types?

2493

---

what is data integration? : Sas-di

1108

---

how will you locate the sas platform applications? : Sas-bi

1023

---