1.

How Will You Write A Code To Create A Sas Data Set With No Data In It/ Or How To Validate A Data Set Without Actual Creating It?

Answer»

1)Use OPTIONS OBS = 0
2) 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.
3) data check;
set _null_;
RUN;
4) data test;
delete;
run;

1)Use OPTIONS OBS = 0
2) 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.
3) data check;
set _null_;
run;
4) data test;
delete;
run;


Discussion

No Comment Found

Related InterviewSolutions