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 do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

916


what is enterprise guide? What is the use of it? : Sas programming

754


what do the pad and dim functions do? : Sas programming

785


how do you want missing values handled? : Sas programming

727


How do you convert basic cube to transaction cube and transaction cube to basic cube?

2011


Explain data_null_?

804


explain the concepts and capabilities of business object? : Sas-bi

751


what is the use of sas management console? : Sas-di

817


Mention what are the data types does SAS contain?

920


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2476


Give some examples where proc report’s defaults are same as proc print’s defaults?

890


What are the different servers in sas? : sas-grid-administration

836


what is the difference between unique key and primary key? : Sas-di

838


Briefly explain input and put function?

839


How do dates work in SAS data?

916