How to read multiple excel sheets from a single excel file
at once????
Answer Posted / sravan
Using libname statement.
Libname <lib_name> excel 'file_specification';
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Tell e how how dealt with..
What does the trace option do?
Explain what is the use of proc gplot?
What are the parameters of scan function?
Do you need to rearrange the order of the data for the report?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
explain the proc in sas? : Sas-administrator
how does sas handle missing values in sort order? : Sas programming
what is treatment emergent events and treatment emregent adverse event
How would you identify a macro variable? : sas-macro
what is sas olap server? : Sas-di
What are the ways to do a “table lookup” in sas?
How substr function works in sas?
what is the Population you used in your project, is it ITT or PP?
How many data types are there in SAS?