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
What is the function of output statement in a SAS Program?
Where do you use proc means over proc freq?
What is your favorite all time computer book? Why?
how to do user inputs and command line arguments in sas?
Which date function advances a date, time or datetime value by a given interval?
Mention what are the data types does SAS contain?
what is transformation in sas data integration? : Sas-di
What is the difference between %put and symbolgen? : sas-macro
Explain data_null_?
Differentiate between proc means and proc summary.
What is the difference between using drop = data set option in data statement and set statement?
What are the advantages of using sas?
Enlist the functions performed by sas.
Name any two sas spawners? : sas-grid-administration
Name few SAS functions?