proc report data=post_deploy_3 nowd; columns SALE_REP_NM acct_exec_nm THRD_PARTY_ORIG_NM THRD_PARTY_ORIG_CD Total_Count; define SALE_REP_NM/ group Display style(column)={cellwidth=60pt just=center} "CRC" ; define Total_Count/analysis sum ; compute after; THRD_PARTY_ORIG_CD = "Total"; line "Total" Total_Count.sum ; endcomp; run;   The code works fine however the Total_Count (label=Grand Total) at the bottom needs to display under the total column.  Sample data enclosed.  It display near the middle of the bottom ... View more

proc sql; create table reg_1_summary as select sale_rep_id_cd,acct_exec_nm,THRD_PARTY_ORIG_NM,THRD_PARTY_ORIG_CD,count(ln_nbr) as ln from reg_2 group by sale_rep_id_cd,acct_exec_nm,THRD_PARTY_ORIG_NM,THRD_PARTY_ORIG_CD ;quit;   This produces sample data with the above decalred variables.  I created a proc tabulate for the datastep Proc tabulate data=reg_2_summary order= data format=10. S=[cellwidth=150]; Class sale_rep_id_cd acct_exec_nm THRD_PARTY_ORIG_NM THRD_PARTY_ORIG_CD /*THRD_PARTY_ORIG_NM Platform*/ ; Var ln ; Table sale_rep_id_cd=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]], acct_exec_nm='Acct Mgr '*ln=' '*sum=' '/*Platform='Platform '*ln=' '*sum=' '*/ all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='Sales Rep ID'; TITLE 'Post Deploy Summary'; footnote1 &dekeyp; run;   I am trying to sort in descending order by the Grand Total.   ... View more

data have; a=99.99999999 b=370.86899; run;   I want to convert a to read 99M and b to read 370K.  So in each case I want to read everything through the decimal point and then add the desired letters of either M or K.  I read about the picture function in sas though I have not used it much ... View more

Channel1 report_dt_p1 Metric count gross_amt gross_amt_avg fico high_risk fico_lt660 ltv_gt90 Emerging Banker Mar2015 STM 268 99.39263 370.868 773.0039 High Risk Categories 0 0.01701761 Emerging Banker Apr2015 STM 206 74.67056 362.4784 770.9701 High Risk Categories 0.00691839 0.037584412 Emerging Banker May2015 STM 204 70.71112 346.6232 768.778 High Risk Categories 0.007555388 0.058201864 Emerging Banker Jun2015 STM 220 72.48243 329.4656 770.7628 High Risk Categories 0.002306766 0.030465647 Emerging Banker Jul2015 STM 261 85.40261 327.2131 764.0758 High Risk Categories 0.010602721 0.068190841 Emerging Banker Aug2015 STM 231 65.51545 283.6167 764.4192 High Risk Categories 0.008735344 0.094368355 Emerging Banker Sep2015 STM 328 98.53859 300.4225 766.0572 High Risk Categories 0.00046214 0.06103769 Emerging Banker Oct2015 STM 307 90.8371 295.8863 763.8919 High Risk Categories 0.007851968 0.07552668                     Emerging Banker                                         Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15       Metric STM STM STM STM STM STM       Count 268 206 204 220 261 231       Loan Amt ($M) 99M 75M 71M 72M 85M 66M       Avg Loan Amt ($K) 371K 362K 347K 329K 327K 284K       FICO 773 771 769 771 764 764       High Risk Categories       % FICO <660 0.0% 0.7% 0.8% 0.2% 1.1% 0.9%       % LTV >90 1.7% 3.8% 5.8% 3.0% 6.8% 9.4%       I am attempting to convert the above data into a transposed or tabulated summary.   I am trying to determine the best way to handle this ... View more

I have a field called reporting_dt_bin shown as a character. It is a concatenate of reporting_Yr and reporting month, both of which were originally dates Reporting_dt_Bin = (Reporting_year_Bin || '-' || Reporting_month_txt); produces this output example   Reporting_dt_Bin 15- 3 15- 4 15- 5 15- 6 15- 7   Is there a way to maintain the reporting_dt_bin format and create another format that converts this into a date Example Reporting_dt_bin2 Mar15 Apr15 May15 The date format would be monyy5. ... View more

data legacy_detail; set rad_0; where coalesce(APPL_RECV_BY_LEND_DT,RECV_STAT_DT) >='01jan2015'd      or PRICE_Lock_date >='01jan2015'd   or            LOCK_IN_DT >='01jan2015'd   and STAT_AGGR_CD = '' ; if STAT_AGGR_CD in ('Purchased', 'Denied') then delete; if platform in ('RAD','LNS') then delete; run;   STAT_ACCR_CD is a character variable. The choices of 'Purchased', 'Denied' are also character variables. Yet for some reason the filter does not work. It does not eliminate those with Purchased and Denied. Has this ever happened to anyone and is this a bug with sas. What am I doing wrong because the coalesce filter is working. ... View more

I produced the dataset b_monthly with date1, which is a date varaible LN_NO TPR_DATA_AS_OF_DT Month YEARMONTH_KEY date1 0000000000 31Dec2014 201412 201412 201412 0000000000 29Nov2014 201411 201411 201411 0000000000 31Oct2014 201410 201410 201410 0000000000 30Sep2014 201409 201409 201409 0000000000 30Aug2014 201408 201408 201408 0000000000 31Jul2014 201407 201407 201407 Date1 is a date variable.  I tried the following to segment it into separate datasets %Macro dmart (date1); data d_Monthly_&date1.; set b_monthly; run; %Mend; I ran the code but nothing was produced.  I want to produce separate datasets such as d_monthly_201412 d_monthly_201411 ... View more

proc sql; create table test as select ln,monthyr from test99; quit; sample output ln      monthyr 11      201502 12      201503 13      201504 I performed a macro to segment each dataset into its own dataset %macro (monthyr); proc sql; create table test11_&monthyr as select * from test; quit; %mend; The objective is to create something like this test11_201502 test11_201503  etc The code runs however no segmenting occurs.  What is the issue with my code.  I am somewhat new to macro building.  Note MonthYr is a date data type ... View more

%macro FileExist; %if %sysfunc(fileexist(&InPath_Core.&InFileName)) %then   x rm "&InPath_Core.&InFileName."; %mend; %FileExist; I just inherited a report that includes the above named code.  I believe the x rm is referencing a string variable to be used later in the report.  Is there a best practices method of decoding when not quite sure as to what a macro code sequence is doing? ... View more