How we can call macros with in data step? : sas-macro
No Answer is Posted For this Question
Be the First to Post Answer
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
How we will Developing new reports Using Data step programming and Macros ?
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 fact table and factless table?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Explain what is the use of proc gplot?
what is Global Symbol table and Local symbol table?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?
What are the functions used for character handling?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?