How to import multiple xls files into sas. Out of those
files, how to get different values from a single variable
and how to find number of rows per value type?

We can do this using group by for one xls file with proc
sql. Was wondering how I can achieve this for multiple
files at the same time.


Any ideas?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SAS Interview Questions

Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


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

0 Answers  


what is the difference between %put and symbolgen?

6 Answers  


what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  


Describe how you would pass data to macro.

3 Answers  






you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.

6 Answers  


how to import HTML files into SAS datasets?

3 Answers   HP,


What are the best sas programming practices for handling very large datasets? : sas-grid-administration

0 Answers  


how would you create multiple observations from a single observation? : Sas programming

0 Answers  


What is instream data in SAS?

1 Answers  


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

0 Answers  


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?

0 Answers   Cognizant,


Categories