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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SAS informats?

840


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2466


What is the difference between class statement and by statement in proc means?

888


What areas of SAS are you most interested in?

1257


what is data access? : Sas-di

855


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

723


what is the use of proc contents and proc print in sas? : Sas-administrator

820


What is by-group processing?

749


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

721


What versions of SAS have you used (on which platforms)?

1237


how does sas handle missing values in assignment statements? : Sas programming

779


what is metadata? : Sas-bi

788


Describe the function and untility of the most difficult SAS macro that you have written.

1832


What is the length assigned to the target variable by the scan function?

891


how does sas handle missing values in a merge? : Sas programming

763