how can u create zero observation dataset?

Answer Posted / srilatha

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.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the trace option do?

667


Do you need to know if there are any missing values?

597


How substr function works in sas?

701


What can be the size of largest dataset in SAS?

717


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

692






what is data governance? : Sas-di

625


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

2691


What is the difference between %put and symbolgen? : sas-macro

671


What is by-group processing?

576


How would you include common or reuse to be processed along with your statements?

1900


For what purposes have you used sas macros? : sas-macro

540


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

610


What is the use of function Proc summary?

655


List out some key concept of SAS

621


What is the use of PROC gplot?

641