Question { 16957 }

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

by using the views.
ex: proc sql;
create view emp_v
as
select empno,sal,deptno,comm from emp;
quit;

Question { CitiGroup, 21052 }

how can u create zero observation dataset?

Answer

creating a data set by using the like clause.

ex: proc sql;
create table latha.emp like oracle.emp;
quit;

in this the like clause triggers the existing table
structure to be copied to the new table.using this method
result in the creation of an empty table.

Question { Parexel, 21731 }

what is the main difference between rename and label? (don't
say that they both perform the same function).

Answer

label : assigns descriptive lables to variables.
lables allows upto 256 characters.
rename : changes the name of the variable.
rename allows upto 64 characters only.