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?
- 0 Answers
- 2575 Views
- I also Faced
- E-Mail Answers
Do you need to know if there are any missing values?
If a variable contains letters or special characters, can it be numeric data type?
hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
What is the SAS data set?
what do the pad and dim functions do? : Sas programming
what is metadata? : Sas-bi
How would you identify a macro variable? : sas-macro
How to merge the data using merge statement and proc format? Is the result is same ?
Name types of category in which SAS Informats are placed?
where are dashboard components are created and maintained? : Sas-bi
how to debug and test the sas program? : Sas-administrator
Teradata 
