The following Syntax ALWAYS worked in SAS9.1, but immediately stopped working the day SAS 9.2 was installed.I do not believe that SAS9.2 lost the functionality.  Instead, I believe that there may have been a change in some parameters setting when it was installed.....would anybody know? data sastable1        set teradata.table1;             where datepart(report_date) le &cutoffdate.; run; The format of &cutoffdate is a pure sasdate, such as 19103. However, after the cutover to SAS9.2  I could only get this to work if I compared report_date to something with a format of '21Apr2012'd by specifying "%sysfunc(putn(&cutoffdate.,date9.))"d. One explanation i received was that the "Where" statement is pushed to Teradata, and Teradata does not realize that 19103 is a date. Fair enough - but WHY did it always work in SAS9.1  ???        What could have changed?? ... View more

I am using SAS to write SAS code to a external dataset, which will later be brougt in by using a %include. The SAS code being written contains macro calls. I was very surprised to find that SAS was trying to resolve the macro call as I was writing it to the external file.  Obviously not the ime I want this to occur. How do I prevent SAS from trying to resolve these macro calls while I am writing the code to the external file? ... View more

If I have a macro variable which resolves to a variable name, how do I print the value of the variable? For example, if my macro variable is &&name&i. and when i=2 then &name2 resolves to acct_num, then how do I print the value of acct_num. put "&&name&i."; only prints the literal acct_num, not its value. Is there any way to do this? ... View more

If the mean of a variable is referenced in a tabulate, and then once again the variable is referenced as a denominator, will the mean be used? Suppose I have a dataset which contains 12 records. One for every month. On that record is a variable called call_dropped, and another variable called total calls. For a monthly report, the percent of calls dropped would be expressed as proc tabulate data=mydata calls_dropped = ''*sum='Calls Dropped'*f=comma6. total_calls = ''*sum='Total Calls'*f=comma9. calls_dropped =pctsum ='Percent Dropped'*f=pctfmt8.2, month=' ' /box='Call Data'; BUT, If I wanted a yearly average, I would do the following: calls_dropped = ''*mean='Avg. Calls Dropped per Month'*f=comma6. total_calls = ''*mean='Avg. Total Calls per Month'*f=comma9. calls_dropped =pctsum ='Avg. Percent Dropped per Month'*f=pctfmt8.2, month=' ' /box='Call Data'; Since there is no pctmean, what would the denominator for this expression be? The mean of all 12 months (as I would like), or the sum of all 12 months (not good). ... View more

I would like the color for the ALL keyword to extend across all of the columns. I've checked some documentation and it would appear that my syntax is correct. However, it is only highlighting the word "SubTotal"., and not expanding across. Can anyone see where my syntax is wrong? Or missing something? proc tabulate data=&period.level missing; class product1 product_raw; class &periodvar. / descending; var &balvar. ; tables (product1=''*(product_raw=' ' ALL='SubTotal') ALL='All Products')*[style= ], (&periodvar.="Calendar &period.")* (&balvar.=''*sum ='Outstanding Avg. $MM' *f=mmfmt. *[style=[tagattr='Format:$###,###,###,###.00;[Red][<0]$-###,###,###,###.00']]) / box="Product" rtspace=25 row=float; KEYWORD ALL / s=[font_weight=bold font_face=times font_size=1 background=liypk]; ... View more

Suppose I have 12 records, one per month. One variable on the record represents the dollar value of all loans defaulted within that month. The other variable on these monthly records, however, is not really "monthly". It represents the total value of all outstanding loans at this point in time. This works well for a monthly report. To calculate the percentage of defaulted loans, simply divide the value of the defaulted loans by the total value of all outstanding loans found on the monthly record. Since both of these variables are on the same record, it is quite easy. For a monthly report you would do the following: proc tabulate data=myinput; class asofmonth; var default outstanding; table default =' '*sum='Default $' outstanding =' '*sum='Outstanding' default =' '*pctsum ='Default Percent', asofmonth If you want to do a quarterly report however, things get a little more complicated. For the numerator you simply sum the value of defaulted loans for the three months. For the denominator you cannot sum the values, but MUST use the average of the three months. My question is this: How do you tell tabulate to use the average for the denominator? Is that possible? proc tabulate data=myinput; class asofquarter; var default outstanding; table default =' '*sum='Default $' outstanding =' '*mean='Outstanding' default =' '*?????????????='Default Percent', asofquarter Mathematically what I would like where the ?????? are is the mean of the outstandings calculated for this quarter. What is the syntax to accomplish this? Is it even possible? ... View more

For some reason I am losing the significant digits in some of my totals. Also, oddly some of the numbers in my rows are coming out as text. There does not appear to be any consistant reason to this occuring. proc tabulate data=monthlevel; class orig_yr_cohort asofyr; var net_book_bal acct; tables (orig_yr_cohort='Vintage Year' ALL='Calendar Total'),(asofyr='Calendar Year' ALL='Vintage Total')* (net_book_bal=''*sum ='Outstanding (Total) $MM' *f=mmfmt. *[style=[tagattr='Format:$###,###,###,##;[Red][<0]$-###,###,###,##']] net_book_bal=''*colpctsum ='Outstanding (Total) %' *f=perc6.2 *[style=[tagattr='Format:000.00%']]) / box="Vintage Year" rtspace=25 row=float; title1 "&titl1."; run; ... View more