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

I need level 2 to 5 sas using companies in india

2431

how does sas handle missing values in functions? : Sas programming

1274

How can you limit the variables written to output dataset in data step?

1373

how can you put a "trace" in your program? : Sas programming

1105

How does the internal authentication work in sas? : sas-grid-administration

1165

how to change the execute of macro

2375

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1307

what are validation tools that are used in sas? : Sas-administrator

1111

How can you create a macro variable with in data step? : sas-macro

1087

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1097

What do you know about symput and symget?

1314

What are the applications primarily used by business analyst? : Sas-bi

1049

What do the mod and int function do? : Sas programming

1292

What are the statements that are executed only?

1202

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1331