Hi: I have 280K records in left table and over a million in table 2. My join brings me 100K records only. I don't understand the problem as to why data is dropped in left join. I have tried it two ways but both bring back 100K records. Help will be greatly appreciated.   Methods1: PROC SQL; CREATE TABLE WORK.ASSIGNS AS SELECT DISTINCT t1.ACCT_NO, t1.ACCT_NO_DET, t1.PROD_ONE, t1.PROD_TWO, t1.START_DATE, t1.END_DATE, t2.PROD_DETAILS FROM WORK.CUSTOMER t1 LEFT JOIN SCHEMA.PRODUCTS t2 ON (t1.ACCT = t2.ACCT_NO) AND (t1.ACCT_NO_DET = t2.ACCT_NO_DET) WHERE t2.PROD_DETAILS LIKE 'ACCESSORY' ; QUIT;   Method 2: PROC SQL; CREATE TABLE WORK.ASSIGNS AS SELECT DISTINCT t1.ACCT_NO, t1.ACCT_NO_DET, t1.PROD_ONE, t1.PROD_TWO, t1.START_DATE, t1.END_DATE, t2.PROD_DETAILS FROM WORK.CUSTOMER t1 LEFT JOIN SCHEMA.PRODUCTS t2 ON (t1.ACCT = t2.ACCT_NO) AND (t1.ACCT_NO_DET = t2.ACCT_NO_DET) WHERE t2.PROD_DETAILS LIKE 'ACCESSORY' or t2.PROD_DETAILS is  missing ; QUIT;     ... View more

PROC TABULATE DATA=RESULT ; VAR SRVC_ID; CLASS " Deal"n / ORDER=UNFORMATTED MISSING style=[ font_weight=medium]; CLASS Week/ ORDER=UNFORMATTED MISSING style=[ font_weight=medium cellwidth=175]; TABLE /* Row Dimension */ Week= ' ' all='Total', /* Column Dimension */ 'Deal'n = ' ' *(SRVC_ID=' '*N=' ') All= ' '* n = 'Total' ; RUN;   I want the cellwidth of Week as 175 but when I do Week= ' ' (in above code) then cellwidth=175 does not work. However cellwidth works when I put Week all = 'Total'.   Can someone help me adjust width of field Week? Thanks! ... View more

I have formula for next Sunday and previous Monday of the week. SUNDAY:   intnx('week.1',datepart(ACTVN_DAT),1) Monday:   intnx('WEEK.2',datepart(ACTVN_DAT),0)   But I realized that it is giving me next Sunday if my ACTVN_DAT falls on Sunday itself (which tells formula is good). Example is below:     How can I amend my formula to keep my Next_Sunday as it is if it falls on Sunday. This is what I want in my data: March 21st & Jan 3rd was Sunday. So I want Next_Sunday as 03/21/2021 & 01/03/2021 respectively. However. Jan 21st is Thursday so my formula works right for this date.   Thanks for your help.   ... View more

I have the code and output below. I would like to remove decimal this code produces in column Blg_Mo. Help would be greatly appreciated.   compute blg_mo_calc/char; blg_mo_calc=put(blg_mo,8.); endcomp; break after blg_mo / summarize; compute after blg_mo; blg_mo_calc = 'SubTotal'; call define (_row_, 'style', 'style=[fontweight=bold background=#B1E599]'); endcomp; rbreak after / summarize style=[background=cxf0f0f0 fontweight=bold fontsize=12pt]; compute after; call define ('_c1_', 'style', 'style=[pretext="Grand Total"]'); endcomp; label blg_mo_calc= 'Blg_Mo';   OUTPUT:   ... View more

Hello: I use next/prior logic in Brio and looking to build same logic in SAS. I'm looking to create column Next Match(below) and Prior match. Here is my what I asking for help with: Next match: if(Duplicate=0 and (End_Date=Next(Create_date))) then 'No Break' elseif(ID_No=Next(ID_No) and (End_Date != Next(Create_date))) then'After few Days'   Prior match: if(ID_No=Prior(ID_No) and (Create_date=Prior(End_Date))) then 'No Break' else if(ID_No=Prior(ID_No) and (Create_date != Prior(End_Date))) then 'After few Days'   Thank you!   Acct No ID No Duplicate Create date End Date Next Match Prior Match 486 486 1 20201106 20201113     177 177 1 20210105 20210111     126 126 1 20200812 20201027     651 651-001 0 20200923 20200928 No Break   651 651-001 1 20200928 20210119   No Break 390 390 1 20201208 20201214     229 229 1 20201112 20201211     411 411 1 20200804 20200814     674 674-001 0 20201009 20201104 No Break   674 647-001 1 20201104 20201105   No Break 681 681 1 20201023 20201113     19 19 0 20200730 20200819 No Break   19 19 1 20200819 20201105   No Break ... View more