what are input dataset and output dataset options?
Answers were Sorted based on User's Feedback
Answer / koduri
input data set options
obs,firstobs,where,in
output data set options
compress , reuse
both input and output dataset option
keep,drop,rename,obs,first obs.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / natrajboga
there is no specific I/P and O/P data set options
the data set options are classified as
Data set control options
Variable control options
Observation control options
miscellaneous options
and etc....
data set options take the action in which it appear .
it means If you apply to the output data set then data set
options take the action while writing to the data set
and If you specify with the I/P data set then data set
options takes the action while processing.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sumalatha.ch
what options we are using inthe data step those are all
input options..and output options are in proc step what we
are used..becoz based onthis we will get output...
ex..if keep option is used in data step that is input
option..at the same way keep option if u use in proc step
that is output option
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / thirumalesh.e.
dataset options which effect and protect records are input options, where as
options those effect output or dataset created after PDV process is done are output options.
ex. Alter, bufno, bufsize, compress, encoding, encrypt , keep and other who does the same role. are input options.
label, genmax, index, obs, outrep, replace and other who does the same role are output options.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bioni
i have 200 dataset and i need to output a number from each
of the dataset to one dataset. how to do this?
| Is This Answer Correct ? | 0 Yes | 0 No |
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
what is the difference between the SAS v8 and SAS v9?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
What’s the difference between var b1 – b3 and var b1 — b3?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
Why is SAS considered self-documenting?
what is pdv? how it is related to input buffer in sas?
What is the one statement to set the criteria of data that can be coded in any step?
What are the features of base sas system?
What is interleaving in SAS?
Diff between proc sql merge and join?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,