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 versions of sas have you used (on which platforms)? : Sas programming

1065

for report generation which one you used proc report or data_null_?

7770

Mention sas system options to debug sas macros.

1163

Tell me more about the parameters in macro? : sas-macro

1049

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

1054

Do you need to rearrange the order of the data for the report?

2303

Describe the ways in which you can create macro variables? : sas-macro

1059

What are types of transport files?

7984

If money were no object, what would you like to do?

3194

If you could design your ideal job, what would it look like?

2921

explain what is data set in sas? : Sas-administrator

978

What can you learn from the SAS log when debugging?

1370

what is sas olap server? : Sas-di

1248

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1014

For clinical entire study how many tables will create approx?

1962