Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 10 Answers
- 20159 Views
- Accenture, I also Faced
- E-Mail Answers
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 is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
How many ways to overcome a missing values???
How many tiers in sas architecture?
What is the pound sign used for the DATA _NULL_?
sas macros
When merging 2 datasets with a common variable (not merge key), how to keep both?
what are all the default values getting in PROC MEANS...???
Difference between informat and format?
How to sort in descending order?
what is slowly changing dimension? : Sas-di
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 ...
Differentiate between sas functions and sas procedures.
Teradata 
