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

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

1842


What is the SAS data set?

675


How would you define the end of a macro? : sas-macro

607


Of all your work, where have you been the most successful?

4198


What are the best sas programming practices for handling very large datasets? : sas-grid-administration

564






How is character variable converted into numeric variable and vice versa?

593


what is slowly changing dimension? : Sas-di

620


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

551


which features do you use to check the data validations and errors? : Sas-administrator

544


What are the new features included in the new version of SAS Programming Language?

733


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

537


what are the considerations when picking a SAS/STAT procedure?

2896


How would you identify a macro variable? : sas-macro

528


Describe the ways in which you can create a macro variable?

622


what is sas data set?

664