Hello @Q1983,   @PaigeMiller has nailed it. It's a typical rounding issue due to numeric representation error in the numbers involved.   The DATA step below, using your example numbers, shows how a sum A+B+C can be different from B+C+A on a computer in spite of the well known commutative law. It also demonstrates that standard formats, unlike HEX16., often hide the issue (all sums look the same) and how the ROUND function with a suitable rounding unit can help to avoid the issue. In your case, if there are only up to two decimals, 0.01 can be a suitable rounding unit.   data test; retain a b c; input s_ a b c; s1=a+b+c; s0=b+c+a; d=s0-s1; rs=round(s0,1e-8); put (s: rs d)(=/)// (s: rs)(=hex16./); cards; 315.07 43.59 233.71 37.77 ; Result (obtained with SAS 9.4 under Windows): s_=315.07 s1=315.07 s0=315.07 rs=315.07 d=5.684342E-14 s_=4073B11EB851EB85 s1=4073B11EB851EB85 s0=4073B11EB851EB86 rs=4073B11EB851EB85 ... View more

The label statement has two basic forms: single variable and label text, as in Label variablename='some text'; or a single Label followed my multiple variable="text" pairs. They are not comma separated lists Yours does not follow either of those and I expect that you log shows some interesting notes.   Instead of label Month_sort = 'FP Payment Date' label tot_cnt = 'Sent to NCCI for Doorknock(142)' label cancelled = 'Cancelled Next Day ', label ext_wait_def = 'Extended Waiting on Deferral', label _dec_eom_cnt = 'Decision By EOM', label inb_outb_aft_cnt = 'RPC IB/OB CONTACT AFTER DOOR KNOCK', label tot_cnt = 'Sent to NCCI for Doorknock(142)'; Try label Month_sort = 'FP Payment Date' tot_cnt = 'Sent to NCCI for Doorknock(142)' cancelled = 'Cancelled Next Day ' ext_wait_def = 'Extended Waiting on Deferral' _dec_eom_cnt = 'Decision By EOM' inb_outb_aft_cnt = 'RPC IB/OB CONTACT AFTER DOOR KNOCK' tot_cnt = 'Sent to NCCI for Doorknock(142)' ; / Box='FP Payment Date';  The editor was not showing the word "label" in blue because it was not in a valid position in the syntax so was not recognized as the key word label.  ... View more

Instead of using compress to remove characters, you can use it to keep characters, as in:   ssn=compress(ssn,'0123456789','k'); where 'k' says to keep the characters in the 2nd argument.   You can then prefix the resulting ssn with 9 zeroes, and take a substr of the last 9 characters:   data have; length ssn $9; input ssn $9.; datalines; 000000000 112334588 426-277 run; data want; set have; put 'Before: ' ssn= @; ssn=compress(ssn,'0123456789','k'); put @25 'between: ' ssn= @ ; ssn=substr(cats('000000000',ssn),lengthn(ssn)+1); put @45 ' After:' ssn ; run;     The substr function tells sas to take characters starting at position lengthn(ssn)+1.   lengthn will return a 0 for a blank argument, while length will return a 1).   I've added a fourth blank SSN to the sample data.    This means for ssn='426277' (after the first compress), you would get 000000000426277  as the first arg of the 2nd compress 7  as the 2nd arg of the 2nd compress which means the substr starts in position 7 of 000000000426277, yielding   000426277.      ... View more

Download the Excel file directly from the server, and check if it opens outside of an email. Also do a cross-check with LibreOffice. It may be that the size of the attachment is limited by constraints imposed on the email. Your ERROR now happens in a LIBNAME, not in PROC EXPORT. ... View more

WHICHC() function. ... View more

Did the rest of the code run correctly? Show your full log, I suspect your issue is at the first step and it flowed through. ... View more

Hello @Q1983  While there could be multiple approaches to address the issue, with the sample data you have provided, I would follow the following approach, I would like to have the data as csv. My code would be as follows: Please note I have reordered your variables. We would need to define a length for the Email column. data have (drop=_completion_date); infile cards DLM=',' dsd; Retain First Last Age Completion_date Email; length Email $ 50 _completion_date $ 50; format Completion_date mmddyy10.; input Email $ First $ Last $ Age _completion_date $ ; Completion_date=input(scan(_completion_date,1,''),mmddyy10.); cards; joesmith@email.com, Charles, Smith ,, 1/11/2016 01:50 PM America/New York ryna@email.com , Dennis ,Jones , 22, 1/1/2016 01:50 PM America/Washington ; run;   ... View more

The solution here should give you the answer. ... View more

@Q1983 wrote: Also in your response were you saying that its best to use a long version of date yymmd7 as opposed to the monyy5 "Long" meant the data set structure: one record per date instead of "wide" with multiple dates(hidden in variable names to an extent) per record.   You would have to share your formula for " returns as a percentage of sales". But Proc report does allow you to do calculations based on results of the statistics calculated. ... View more