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 where and if statement?

805


how do the in= variables improve the capability of a merge? : Sas programming

1149


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1436


explain about various caches available in data integrator? : Sas-di

781


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

783






What is a pdv and what are its functions?

776


how to debug and test the sas program? : Sas-administrator

763


Which function is used to count the number of intervals between two sas dates?

817


What does PROC print, and PROC contents do?

945


What is the basic structure of a sas program?

784


Enlist the syntax rules followed in sas statements.

816


What is the difference between class statement and by statement in proc means?

875


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1140


List down the reasons for choosing sas over other data analytics tools.

1020


What was the last computer book you purchased? Why?

2074