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?
Answers were Sorted based on User's Feedback
Answer / imran syed
KEEP statement is the most effective form of code.
keep var-1 var-2 var-3 var-4 var-5;
| Is This Answer Correct ? | 24 Yes | 0 No |
Answer / john sikha
Use keep followed by variables you required
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / aravind9882
u can use keep dataset option or keep statement to limit
the no of variables depending on ur requirement. if u want
process only those 5 variables, u can use keep dataset
option. if u want to limit d variables after d data is
processed u can use keep statement.
data new;
set old(keep=v1 v2 v3 v4 v5);
run;
or
data new;
set old;
keep v1 v2 v3 v4 v5;
run;
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ganesh
We can either use keep or drop option for selecting those
five variables.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / vinod swarna
use select statement with just those 5 variables:
proc sql;
create table only5 as
select var1,var2,var3,var4,var5
from example;
quit;
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / chandra
data set options keep is best and using proc sql is also.
| Is This Answer Correct ? | 6 Yes | 0 No |
data xyz first obs=first
obs=last;
set zyx;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
What does the trace option do?
what is Business Intelligence?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
what are the component of range? : Sas-bi
Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara
what is in stream data in SAS?
Differentiate between ceil and floor functions.
What is difference between N and n????
How to select the observations randomly from a SAS dataset
How do you debug and test your SAS programs?
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?