why is the use of Retrive statement and give me with
example?
- 1 Answers
- 4109 Views
- ME, I also Faced
- E-Mail Answers
Answer / aravind rangaraj
i hope there is no such statemnet, make sure that wch
statement it is..
| Is This Answer Correct ? | 5 Yes | 2 No |
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 a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
How to write duplicate records into a separate dataset using sort?
What is the difference between verification and validation?
What is the size of PDV?
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
What is difference between N and n????
what other SAS features do you use for error trapping and data validation?
How would you delete observations with duplicate keys?
Why do we use QUIT commmand for proc datasets and proc sql ???
what are the component of range? : Sas-bi
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
Teradata 
