how can u create zero observation dataset?
Answers were Sorted based on User's Feedback
Answer / chandra sekar
Use the following step
data test;
delete;
run;
| Is This Answer Correct ? | 15 Yes | 3 No |
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 |
Answer / nagendra
data class;
set sashelp.class;
if _n_ >= Then delete;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vishnu
for example
data vishnu;
length name $ age ;
run;
proc print data=vishnu;
run;
| Is This Answer Correct ? | 7 Yes | 11 No |
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
What is the pound sign used for in the data_null_ ?
What are the ways to do a “table lookup” in sas?
hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..
Code the MEANS to produce output to be used later.
Approximately what date is represented by SAS date value of 730
%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What can you learn from the SAS log when debugging?
Can you execute macro within another macro? : sas-macro
Why is SAS considered self-documenting?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?