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 is hash files in sas and why we are using this one in sas?

2199

---

explain the proc in sas? : Sas-administrator

1077

---

Are you involved in writing the inferential analysis plan? Tables specfications?

2214

---

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1148

---

Which statement does not perform automatic conversions in comparisons?

1764

---

How would you invoke a macro? : sas-macro

1096

---

Tell me about % include and % eval? : sas-macro

1127

---

What are the different types of sas functions?

1257

---

Did you used proc test? when?

2025

---

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

1080

---

what is study design in while working with SAS? what are screening variables in SAS?

2221

---

Describe crosslist option in tables statement?

1210

---

What are the difference between ceil and floor functions in sas?

1333

---

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1011

---

What is the work of tranwrd function?

1230

---