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

What are the 3 components in sas programming?

0 Answers  


What is the purpose of the trailing @? The @@? How would you use them?

10 Answers   Accenture,


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

0 Answers   Oracle,


Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,


In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?

6 Answers   Cognizant,






what is sas database server? : Sas-di

0 Answers  


Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  


How do you debug macros?

3 Answers   Accenture,


what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,


what is fact table and factless table?

1 Answers  


What techniques and/or PROCs do you use for tables?

4 Answers   Oracle,


What is the command used to find missing values?

0 Answers  


Categories