When I issue the code below in pass through it returns the box that says it can't find it and no table is created. create table #a (id char(9), ind_id int, account_id int, integration_id varchar(25), employer_id int, name varchar(100), LAST_TRANSFER_DATE datetime, NBR_TRANSFERS varchar(10), SHORT_NAME varchar(100), INVESTMENT_ACTIVE varchar(20), OFFICER_CODE varchar(4000), OFFICER_NAME varchar(200), CLOSE_DATE Datetime, ACCOUNT_ORIG varchar(4000), DATE7_ENTERED varchar(25))     ... View more

1. Why scheduler breaks - don't know why; outside my area of influence 2. Invest in another scheduler - have no control over this piece 3. Who can execute?  Likely someone in IT who is not a SAS user.   I need another way to do this that does not involve using VB scripts; e.g. running a series of projects from another project.   ... View more

proc report data = rank_ratio23 missing ; where rank_ratio ne . and upcase(major_market) = upcase("%bquote(&&mm&i)"); columns MULTIPLE_CUTOFF major_market cat tenure2 title_group fa_code financial_advisor tenure_pos cutoff total_kpi_revenue salary bonus adjuster adjuster = adjusterx total_kpi_revenue = si2 salary = sal2 bonus = bon2 ratio ratiox variance deposit_bal deposit_volume net_deposit loan_bal loan_volume net_loan ; define major_market / 'Major Market' order = data group noprint style(column)=[just = left width=1000% tagattr='wrap:No'] format=$F_MAJMKT. preloadfmt; define cat / "Category" order = data group style(column)=[just = left width=1000% tagattr='wrap:No']; define title_group /'Title^nGroup'; define fa_code /'FA'; define financial_advisor/'Financial Advisor' style(column)=[just = left width=1000% tagattr='wrap:No']; define tenure2 /'Tenure^nCategory^n(Years)' group descending order = internal style(column)=[just = left width=1000% tagattr='wrap:No'] f = tenureb.; define tenure_pos/'Tenure^n(Years)' mean f = comma10.1 ; define ratio/'Ratio' display f=comma10.1 style = [fontweight = bold] noprint; define cutoff/'Cutoff^nRating' order = data display style(column)=[fontweight = bold just = left width=1000% tagattr='wrap:No'] f=cutoff.; define total_kpi_revenue/' spread' noprint ; define salary / 'salary' noprint ; define bonus /'bonus' noprint ; define adjuster/ 'adjuster' noprint ; define ratiox/computed f=comma10.1 style = [fontweight = bold] 'Ratio'; define adjusterx/ mean analysis noprint ; define sal2/analysis sum noprint; define bon2/analysis sum noprint; define si2/analysis sum noprint; define net_loan/"Loan^nTransfers (000s)" format = comma32. style = { htmlstyle="mso-number-format:'#,###'"}; define net_deposit/"Deposit^nTransfers (000s)" format = comma32. style = { htmlstyle="mso-number-format:'#,###'"}; define loan_volume/"Loan^nVolume (000s)" format = comma32. style(column)={cellwidth = 4.0in} style = { htmlstyle="mso-number-format:'#,###'"}; define deposit_volume/"Deposit^nVolume (000s)" format = comma32. style = { htmlstyle="mso-number-format:'#,###'"}; define loan_bal /"Loan^nBalance (000s)" format = comma32. style = { htmlstyle="mso-number-format:'#,###'"}; define deposit_bal/"Deposit^nBalance (000s)" format = comma32. style = { htmlstyle="mso-number-format:'#,###'"}; define multiple_cutoff / noprint; define variance / computed 'Variance' format = comma32.1 style = [fontweight = bold]; compute ratiox; if cutoff = 0 then call define ('ratiox',"style","style=[color = green]"); else call define ('ratiox',"style","style=[color = red]"); endcomp; compute cutoff; if cutoff= 0 then do; call define (_col_,"style","style=[color = green]"); end; else do; call define (_col_,"style","style=[color = red]"); end; endcomp; compute variance; variance = ratiox - MULTIPLE_CUTOFF.sum; if round(variance,0.1)> = 0 then call define ('variance',"style","style=[color = green]"); else call define ('variance',"style","style=[color = red]"); endcomp; break after tenure2/skip; break after major_market/skip; break after cat/skip; rbreak after/skip; compute after major_market ; cat = "Major Market Total"; call define('ratiox',"style","style=[fontstyle = italic color = black fontweight=light]"); endcomp; compute after cat ; cat = "Category Total"; call define('ratiox',"style","style=[fontstyle = italic color = black fontweight = light]"); endcomp; compute after ; cat = "Overall"; call define('ratiox',"style","style=[fontstyle = italic color = black fontweight = light]"); endcomp; compute after tenure2 ; line ' '; endcomp; run; ... View more

The reports are generated using PROC REPORT and take about 3 hours to complete. I do not want a manual process because manual steps tend to be forgotten from time to time. This needs to be done automatically so the operator does not have to do anything post-hoc. ... View more

This is not what I want to do as this will make the same reports run more than once in two different packages which would cause the project to run much longer than it does (not desirable). For the last stage I want to take two existing sets of PDFs and append them together without having to create the same reports twice in SAS.   ... View more

Using this method is ok for a small number of files, but I have many that need to have PDFs appended. So rather than have duplicate runs of the same reports, I prefer to append sets together. Can this be done? ... View more