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? : Sas programming

538


What is the basic structure of a sas program?

596


What is the difference between one to one merge and match merge? Give an example.

571


why is sas data integration studio important? : Sas-di

559


Of all your work, where have you been the most successful?

4199






What do you code to create a macro? : sas-macro

578


How to limit decimal places for variable using proc means?

587


Hi, If anyone has base SAS certification dumps, please share.

1386


How long can a macro variable be? A token? : sas-macro

715


where are dashboard components are created and maintained? : Sas-bi

559


what is factor analysis? : Sas-administrator

610


What system options would you use to help debug a macro? : sas-macro

636


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2094


Name and describe few sas character functions that are used for data cleaning in brief.

668


explain about sas business intelligence? : Sas-bi

596