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
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is the difference between unique key and primary key? : Sas-di
Explain input and put function?
Differentiate between sas functions and sas procedures.
What is the purpose of _character_ and _numeric_?
name several ways to achieve efficiency in your program? : Sas programming
what type of graphs we will create(for 2+years candidates)?
What are the difference between ceil and floor functions in sas?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
describe about metadata object? : Sas-di
Compare sas with other data analytics tools.
for whom is sas data integration studio designed? : Sas-di
How can sas program be validated?
what is transformation in sas data integration? : Sas-di
how to read the variables in sas? : Sas-administrator