1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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?

Question Posted / jaipal reddy

Answers were Sorted based on User's Feedback



If you have a data set that contains 100 variables, but you need only five of those, what is the co..

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

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / john sikha

Use keep followed by variables you required

Is This Answer Correct ?    23 Yes 2 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

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

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / ganesh

We can either use keep or drop option for selecting those
five variables.

Is This Answer Correct ?    11 Yes 2 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / ravira

data set name ;
set old data set name ( keep = a b c d e);
run;

By using above concept u can read what r the variables u
want to read ,first create data set having many variables ,
then try to read from some variables

Is This Answer Correct ?    9 Yes 0 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

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

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / chandra

data set options keep is best and using proc sql is also.

Is This Answer Correct ?    6 Yes 0 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / gaurav verma

data xyz first obs=first
obs=last;
set zyx;
run;

Is This Answer Correct ?    0 Yes 0 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / santhi

we can use drop command for a limit

Is This Answer Correct ?    1 Yes 11 No

If you have a data set that contains 100 variables, but you need only five of those, what is the co..

Answer / guest

obs = 5

Is This Answer Correct ?    1 Yes 35 No

Post New Answer

More SAS Interview Questions

What do you know about symput and symget?

0 Answers  

I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  

what are all the default values getting in PROC MEANS...???

2 Answers  

Explain why double trailing @@ is used in input statement?

0 Answers  

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,




Name and describe three SAS functions that you have used, if any?

4 Answers   Accenture,

what is the purpose of _error_? : Sas programming

0 Answers  

Explain by-group processing?

0 Answers  

Tell e how how dealt with..

0 Answers  

i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers

3 Answers   SAS,

Explain the use of proc gplot? : sas-grid-administration

0 Answers  

What is instream data in SAS?

1 Answers  

For more SAS Interview Questions Click Here
Categories