If you have a data set that contains 100 variables, but you
need only five of those, what is the code to force SAS to
use only those variable?
Answer Posted / ram pabba
It is true to use KEEP option on a dataset to only select
few variables from 100 variables.
We can use KEEP option either on set statement or data
step statement. If we use on SET statement then only the
five variables are created on pdv and only these variables
are sent to the output dataset. If we use KEEP option on
data step statement then all the variables are copied into
pdv and after any maniuplation only the selected variables
on data step statement are processed and sent to output
dataset.
data abc;
set xyz (keep= ab cd ef gh);
run;
data abc(keep= ab cd ef gh ij);
set xyz;
ij=ab+jk;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
what is sas enterprise intelligence architecture? : Sas-bi
Explain how merging helps to combine data sets.
Explain how you can debug and test your SAS program?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
What is the role of sas grid administrator? : sas-grid-administration
What are the different types of sas functions?
What is the general format of function in sas? : sas-grid-administration
What are the new features included in the new version of SAS Programming Language?
what is sas application server? : Sas-di
What is the difference between reading data from an external file and reading data from an existing data set?
how can you put a "trace" in your program? : Sas programming
How many ways to overcome a missing values???
What do the PUT and INPUT functions do?
what are the considerations when picking a SAS/STAT procedure?