use select statement with just those 5 variables: proc sql; create tabl

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 / vinod swarna

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is intially documentation in sas?

5052

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1157

If a variable contains only numbers, can it be a character data type?

1085

How would you define the end of a macro? : sas-macro

1094

how to generate the test data in sas without input data? : Sas-administrator

1135

what is sas metadata repository? : Sas-bi

1117

Which statement does not perform automatic conversions in comparisons?

1783

what is the use of sas management console? : Sas-di

1096

Explain append procedure?

1084

what are the scrubbing procedures in sas? : Sas programming

1285

what type of graphs we will create(for 2+years candidates)?

2309

What is interleaving in SAS?

1112

how many types prompting framework can be broken down to? : Sas-bi

1076

What is maximum storage capability of SAS?

1423

explain the function of substr in sas? : Sas-administrator

1011