Interested to Buy Any Domain ? << Click Here >> for more details...
How would you keep from overlaying the a SAS set with its
sorted version?
- 4 Answers
- 9621 Views
- I also Faced
- E-Mail Answers
Answer Posted / hsong001
I agree that we can use the out= options in proc sort to
create a new data set for the sorted version. However,
sometimes we just forgot it. To prevent overwritten the
original data set that in a permanent library, we can specify:
options noreplace;
This will prevent accidentally overlaying the original data
set in case out= option is not specified.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What makes sas stand out to be the best over other data analytics tools?
What is data _null_?
What is the order of application for output data set options, input data set options and SAS statements?
what versions of sas have you used (on which platforms)? : Sas programming
how to generate the test data in sas without input data? : Sas-administrator
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.
what is ae onset date n what is RDS
explain what is data set in sas? : Sas-administrator
Explain what is the use of proc gplot?
I need level 2 to 5 sas using companies in india
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
What are the five ways to do a table lookup in sas? : sas-grid-administration
what are all the reports you generated in your recent project?
Name validation tools used in SAS
What is PDV?
