options nocenter validvarname=upcase ls=145 ps=60 orientation=landscape nomprint nosymbolgen                        ------------                        1 ERROR 27-12: Option does not have a value. I am getting this error when using the above named code in a program with ODS tagset.  Is this familiar to anyone.  I heard there was an options statement that can be added to avoid this error.  This particular report is placed on a sharepoint sserver and deployed ... View more

data test(keep=ln tpr_date); set test1; by ln_no; if last.ln_no; run; If I had this output prior to running the above sas script it looks like this ln                              tpr_date 1                              09/15/2013 1                              10/15/2013 2                              06/15/2014 2                              06/22/2013 2                              06/22/2013 After running the program I would get this ln                              tpr_date 1                              10/15/2013 2                              06/22/2013 However I would miss the unique value or 2                              06/15/2014 because 2 is the last.ln in the series. I would want this output ln                              tpr_date 1                              10/15/2013 2                              06/15/2014 2                              06/22/2013 In this case both the ln and tpr_date need to capture the last unique values.  Any ideas here??? ... View more

I have been assigned to troubleshoot why a program will not run.  I know the issue.  It is an email script that is housing too many emails. Sample error message Email address:marcsmith@yahoo.com   jansmith@yahoo.com.......etc is too long  256 character limit The macro looks like this %email_out(110,msglist,); I am trying to locate the path for the above macro to modify or remove some of the email addresses.  The program references the location however this macro is no where to be found.  Is there a code that gives location for macro, much like option symbolgen gives descriptive information? ... View more

proc sql; create table action as select distinct Region,count(ln_no) as ln, sum(balance) as bal from main; where region = 'West'; quit; Sample output is Region             ln                          bal West           2500                     2300000 I created a proc tabulate with the intention of capturing both the count of the ln_no and the sum of the balance Proc tabulate data=action order= data format=10. S=[cellwidth=150];   Class Region;   Var ln;   Table Region=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]],         Region='Status '*ln=' '*sum=' '         all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='Investor Group';   TITLE 'Loan Status'; My results give me a summary of the count of the loan however I am not getting the total or sum of the balance.  Essentially I am getting the 2500 but not the 2300000.  In addition how would I format the bal so it reads as a dollar format such as $2,300,000.00 ... View more

proc sql; create table action as select distinct Region,count(ln_no) as ln, sum(balance) as bal from main; where region = 'West'; quit; Sample output is Region             ln                          bal West           2500                     2300000 I created a proc tabulate with the intention of capturing both the count of the ln_no and the sum of the balance Proc tabulate data=action order= data format=10. S=[cellwidth=150];   Class Region;   Var ln;   Table Region=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]],         Region='Status '*ln=' '*sum=' '         all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='Investor Group';   TITLE 'Loan Status'; My results give me a summary of the count of the loan however I am not getting the total or sum of the balance.  Essentially I am getting the 2500 but not the 2300000.  In addition how would I format the bal so it reads as a dollar format such as $2,300,000.00 ... View more

proc sql; create table FSDILX2 as select comm_cd,count(ln_no) as ln,sum(balance) as bal from FSDILX1 group by comm_cd having count(ln_no) and sum(bal); quit; Obviously this is wrong.  I am trying to get output in a summary form something like this: FSDILX (which is a comm_cd)  52 (which is the total loan numbers or ln_no)  $52,000 (which is the total balance or bal) Would I need two separate proc statements for the count and the sum?  Can I combine into one statement? ... View more

ODS LISTING CLOSE; Here is a portion of code used to create an excel file on a website.  I use SAS 9.3 EG.  I cannot figure out why I am getting the error listed in red below ODS TAGSETs.ExcelXP file="&ReportOut..xls" Path="&OutDir" style = styles.rtf; /*ODS TAGSETs.ExcelXP file="&ReportOut..xls" Path="&OutDir" style = styles.rtf*/ Title1 "&Investor_Nme for &mm_name1"; options(sheet_interval= 'None'           sheet_name= 'Rows 1 - 16'            Orientation= 'landscape'            Frozen_Headers = '1'            CENTER_HORIZONTAL = 'yes'           scale = '80'            ROW_REPEAT = '1'            CENTER_HORIZONTAL = 'yes'           EMBEDDED_TITLES = "No"            EMBEDDED_FOOTNOTES = "YES"            GRIDLINES ="YES"            AutoFit_Height = 'YES')                                     -                                     2   ; ERROR 2-12: Invalid option name. ... View more

data test(keep=ln_no,template); set test2; run; sample output ln_no                       template 0001444444             sample 0000000444            sample2 How can I display the ln_no to capture the leading zeros and show an actual 10 digit ln_no DEFINE  ln_no  /Display style(column)={tagattr="format:????????" cellwidth=80pt just=right}  "Loan Number"; ... View more

data test1; set test; by ln.no; run; sample output ln_no         template          status_chng 100            wwe               12/15/12 111            abc                 1/12/13 111           cdd                 11/12/13 data test2; set test1; by ln_no; if last.ln_no; run; sample output ln_no         template          status_chng 111           cdd                 11/12/13 Is there a way to show a next to last transaction in a dataset.  I need to show the last.ln_no such as the dataset in test2 and another dataset for test3 data test3; set test2; by ln_no; if ??????? run; sample output ln_no         template          status_chng 111            abc                 1/12/13 Is there a way to do a next to last transaction.  I know this is unusual ... View more

outods listing close; options missing=' ' topmargin=0.30in bottommargin=0.01in rightmargin=0.25in leftmargin=0.25in; ODS TAGSETS.ExcelXP file="&ReportOut..xml" Path="&OutDir" style=&t1_style; ODS TAGSETS.ExcelXP    options(sheet_interval='none'            default_column_width='8'            sheet_name="Sales Summary"            center_horizontal="no"            Orientation='Landscape'            embedded_titles='No'            fittopage="No"            blackandwhite="No"            Embedded_Footnotes='Yes'            autofit_height="Yes"); Proc tabulate data=FC_SALE2 order= data format=10. S=[cellwidth=150];   Class Col_group STEP_CODE_DESCRIPTION;   Var ln;   Table Col_group=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]],         STEP_CODE_DESCRIPTION='Description'*ln=' '*sum=' '         all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='Investor Group';            TITLE 'Sales Summary';   quit; Produces this output Investor Group Description Grand Total Sales Held Third Party Sale Sales Sch Bank1 22 8 30 Bank2 131 4 135 Sales1 86 4 90 Sales2 131 33 164 Repay1 104 4 1 109 Repay2 22 4 26 Grand Total 496 57 1 554 I thought that by inserting a title at the botom, the title would appear in the output at the top.  Instead only Descrption appears and I want the title to appear above trhe Description ... View more