Interested to Buy Any Domain ? << Click Here >> for more details...
If you were told to create many records from one record
show how you would do this using arrays and with PROC
TRANSPOSE?
- 1 Answers
- 9435 Views
- HCL, Quintiles, I also Faced
- E-Mail Answers
Answer / trishnan.
Declare array for number of variables in the record and
then used Do loop Proc Transpose with VAR statement.
| Is This Answer Correct ? | 5 Yes | 0 No |
How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.
explain about data integrator metadata reports? : Sas-di
Are you sensitive to code walk-throughs peer review or QC review?
How substr function works in sas?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Mention what are the data types does SAS contain?
Under what circumstances would you code a SELECT construct instead of IF statements?
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.
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
what is cummaltive frequency,and varience in proc unviarte
What is maximum storage capability of SAS?
At compile time when a SAS data set is read, what items are created?
Teradata 
