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

Identify statements whose placement in the DATA step is critical?

11 Answers  


define table lookup and how may ways it can be done...explian

3 Answers  


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

0 Answers  


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

3 Answers  


Explain how merging helps to combine data sets.

0 Answers  






what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


What are the differences between sum function and using “+” operator?

0 Answers  


Did you used proc lifetest? when?

2 Answers   Accenture, Parexel, Quintiles,


What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers   Accenture, Sciformix,


What is the SAS data set?

0 Answers  


Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1 Answers   Pfizer,


Categories