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 are the different operating system platforms in which we can use sas? : sas-grid-administration

1009

why is a stop statement needed for the point=option on a set statement? : Sas programming

1038

What are the different servers in sas? : sas-grid-administration

1006

what is the basic structure sas administrator? : Sas-administrator

956

Mention the category in which sas informats are placed?

976

what do you mean by data staging area? : Sas-di

1064

what is proc Index? and what is proc document?

2631

What is the use of divide function?

1009

what are the scrubbing procedures in sas? : Sas programming

1222

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1179

why is sas considered self-documenting? : Sas programming

1082

What does PROC print, and PROC contents do?

1169

What was the last computer book you purchased? Why?

2315

What is SAS? What are the functions does it performs?

1138

Mention what is SAS data set?

1086