Tell me more about the parameters in macro? : sas-macro
No Answer is Posted For this Question
Be the First to Post Answer
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
how do you test for missing values? : Sas programming
what are the differences between proc report and proc tabulate?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
How do dates work in sas?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
I need level 2 to 5 sas using companies in india
What statement do you code to write the record to the file?
what is the difference between %put and symbolgen?
which domain is better in sas? clinical trails or banking
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.