Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create datasets by proc step ? (Proc contents, Means)?
- 2 Answers
- 3941 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / fabio
Yes you can, for example many proc (like sort for example) have the option OUT= to allow it
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the pound sign used for the DATA _NULL_?
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.
Baseline definition in your study
3 Answers Accenture, Quintiles,
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
is data integration and etl programming is same? : Sas-di
In SAS explain which statement does not perform automatic conversions in comparisons?
What is the basic structure of the SAS base program?
Differentiate input and infile.
When merging 2 datasets with a common variable (not merge key), how to keep both?
How do you write a test plan?
what is broad cast agent? : Sas-bi
How we will Developing new reports Using Data step programming and Macros ?
Teradata 
