I played around with this a little more and found out you can add an extension option like below.  The file will come with .htm instead of .txt.  Your users could open it with Excel and wouldn't have to rename it to open it.  If they want an Excel file, they would just have to remember to save it that way. FILENAME MYMAIL EMAIL       ('GARY.BALD@GLOBALCROSSING.COM')       SUBJECT = 'SPREADSHEET'       ATTACH=("TSM519.PDS.OUTPUT(OUTPUT)"      CONTENT_TYPE='HTML'      EXTENSION='HTM'); ... View more

I'm using Office 2007 but I think the issue is the same. I also use ods html3 on the mainframe to create files that I open with Excel. I allocate the file like this: FILENAME PDSEHTML 'TSM519.PDS.OUTPUT'          DSNTYPE=LIBRARY          DSORG=PO          DISP=(NEW,CATLG,DELETE);    ODS HTML3 BODY = 'OUTPUT' (URL='OUTPUT.HTM') RS=NONE           PATH = 'TSM519.PDS.OUTPUT' (URL=NONE)           TRANTAB = ASCII; ods listing close; run; other SAS code, usually proc tabulate run; ODS HTML3 CLOSE; When I send the file in an email from the mainframe, I use this code FILENAME MYMAIL EMAIL       ('GARY.BALD@GLOBALCROSSING.COM')       SUBJECT = 'SPREADSHEET'       ATTACH=("TSM519.PDS.OUTPUT(OUTPUT)"       CONTENT_TYPE='HTML'); The content_type is html rather than the default of text. The file comes as an attachment with a .txt extension, but I do a save as and give it .html extension. When I open the file in Excel everything is formated. I save it as an .xlsx file. I don't know if this will work in Office 2010, but it's worth a try.  Good luck! ... View more

A little bit of sql would keep the rewriting to a minimum.  Put code like this before your proc print; proc sql; create table new as select *, sum(cap) as capsum, sum(alloc) as allocsum from new; proc sql; create table new as select *, ((allocsum / capsum) * 100) as percent from new; proc print; run; ... View more

After you sort the data by the variable, use the first.  and  last.  to delete the records. For example: proc sort data=test;   by x; data test;   set test; by x; if first.x then delete; if last.x then delete; run; Dataset test should now have every record but the lowest and highest value of x. ... View more

It would be nice to see the log to know more about your program. You only have one double quote. Try  other="%nrstr(&custname)"; or other=%nrstr("&custname"); to force it to resolve. ... View more

before your put statement, try this if _n_ = 1 then do; put 'v1' '~' 'v2' '~' etc. end; ... View more

try changing line 301 to drop the input and put and change where the format is assinged datepart(start_dt) as max_start_dt format=yymmdd8. then you should be able to change line 306 to max_start_dt >= "START_YYYYMMDD" ... View more

trying changing : do i = 1 to 4; ress = 0; end; to: if _n_ = 1 then do i = 1 to 4; ress(i) = 0; end; I would also move: set meld; right after data final; data final; set meld; other statements ... View more

I was experimenting based on this post I found in the knowledge base http://support.sas.com/kb/24/843.html and got an error message that SAS was expecting a quoted string, $, &, /, //, :, =, ?, ~ (I think that's everything.) When I tried the $, I got the result I wanted. I tried the others too and some gave me the same results as the $ while others like / inserted a carriage return. I'm not sure exactly what's going on, but it works, so I decided to post it. ... View more

Try adding DLM='09'x DSD to your file statement change your put statement to put (_all_) ($); ... View more

The first thing you need to decide is whether you want to keep the variables as numeric or character. Also consider if the variables are padded with leading zeros or anything else that may effect comparing the final values. Below is code I used to keep the variable NUMBER as a character when it was stored as numeric. data temp (rename=(number2=number) drop=number); length number2 $10; set rev.mrc (keep = number); number2 = put(number,z10.); *NUMBER2 equals the numeric NUMBER with leading zeros. The original NUMBER is dropped, then NUMBER2 gets renamed to NUMBER in dataset temp.; If you want to change the character variables to numeric, you can substitute code like this in the appropriate places: length number2 8; number2 = input(put(number,$10.),10.); This converts the character to numeric. ... View more

I noticed you don't have a var statement. Is umony your analysis variable? ... View more

options validvarname=upcase; ... View more