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


Please Help Members By Posting Answers For Below Questions

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

859


how does sas handle missing values in sort order? : Sas programming

754


Where do you use proc means over proc freq?

787


What is the difference between match merge and one to one merge?

941


describe how to adjust the performance of data integrator? : Sas-di

787


what is intially documentation in sas?

4664


what are _numeric_ and _character_ and what do they do? : Sas programming

916


Name types of category in which SAS Informats are placed?

954


Enlist the syntax rules followed in sas statements.

870


what is sas and what are the functions? : Sas-administrator

772


What are the features of base sas system?

813


what is information maps?

1851


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2316


What are the different types of sas functions?

896


What is the work of tranwrd function?

984