Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the data types in sas?

1062


explain the key concept of sas? : Sas-administrator

1001


How many data types are there in SAS?

1078


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

1214


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

1013


What are all the problems you faced while validating tables and reports?

3470


What are SAS/ACCESS and SAS/CONNECT?

1149


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2119


Explain what is the use of proc gplot?

1198


What would be the value of month at the end of data step execution and how many observations would be there?

1147


What is data _null_?

1143


explain about sas business intelligence? : Sas-bi

1146


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

4668


Which are the statements whose placement in the data step is critical?

1265


Can you execute a macro within a macro? Describe. : sas-macro

1111