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

How you can read the variables that you need?

1125

---

Explain why double trailing @@ is used in input statement?

1064

---

What is program data vector (pdv)?

1296

---

Can you explain the process of calendar?

1116

---

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

994

---

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

1094

---

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

1072

---

How to test the debugging in sas?

1179

---

What does P-value signify about the statistical data?

1364

---

Explain the purpose of retain statement.

1055

---

What are the applications primarily used by business analyst? : Sas-bi

997

---

Which command is used to save logs in the external file?

1100

---

What is the SAS data set?

1132

---

What do you understand by the term Normal Distribution?

990

---

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

2220

---