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
where to use sas business intelligence? : Sas-bi
how do you debug and test your sas programs? : Sas programming
Where do you use proc means over proc freq?
why is a stop statement needed for the point=option on a set statement? : Sas programming
what is the basic structure sas administrator? : Sas-administrator
How do dates work in sas?
what versions of sas have you used (on which platforms)? : Sas programming
For what purposes have you used sas macros? : sas-macro
What’s the difference between var b1 – b3 and var b1 — b3?
how are numeric and character missing values represented internally? : Sas programming
Mention how to limit decimal places for the variable using proc means?
How can you create a macro variable with in data step? : sas-macro
Which function is used to count the number of intervals between two sas dates?
what is sas enterprise intelligence architecture? : Sas-bi
what is data access? : Sas-di