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

name some data transformation used in sas di? : Sas-di

0 Answers  


If a variable contains only numbers, can it be a character data type?

0 Answers  


how do we get duplicate observations in a separate dataset?

6 Answers   CitiGroup,


How are numeric and character missing values represented internally?

0 Answers   Quintiles,


What has been your most common programming mistake?

4 Answers   Wipro,






what is in stream data in SAS?

1 Answers  


What are the main differences between sas versions 8.2, 9.0, 9.1?

4 Answers  


explain about sas business intelligence? : Sas-bi

0 Answers  


How do you use the do loop if you don’t know how many times you should execute the do loop?

0 Answers  


How can you put a "trace" in your program?

2 Answers   Quintiles,


I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  


explain what is factor analysis? : Sas-administrator

0 Answers  


Categories