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 are the best practices to process the large data sets in sas programming? : Sas-administrator

776


What are the default statistics that proc means produce?

789


Describe what are the different levels of administrative users in sas? : sas-grid-administration

785


What are the implications?

1387


Mention what are the data types does SAS contain?

909


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

772


why is sas considered self-documenting? : Sas programming

858


how does sas handle missing values in procs? : Sas programming

868


How do you use the do loop if you don’t know how many times you should execute the do loop?

998


Explain what is data step?

926


How to test the debugging in sas?

849


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1520


How do you delete duplicate observations in sas?

801


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

916


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1095