Hi, I have a report I would like to make look a bit nicer in Excel.  It presently lists a varying number of items per person.  So the first person might have 3 lines and the second person 4 lines and the third person 2 lines etc.  In excel, instead of having the persons name show up on each line, you can merge them together and center them.  So the first person still has 3 lines, but the name shows up once and it shows up in the middle of the 3 lines.  Is there a way to do that using PROC Report? In the attached spreadsheet, the top table is an idea of what I'm producing and the bottom table is what I'd like to produce. This is the code I'm using to create the colors... compute nurse_analyst; if nurse_analyst in (&nurses.) then call define(_row_,"style","style=[background=lightgrey]"); if nurse_analyst = ' ' and _break_ ne "_RBREAK_" then do; mr_code='Total'; call define(_row_,"style","style=[background=lightblue]"); end; if nurse_analyst = ' ' and _break_ = "_RBREAK_" then do; mr_code='Grand Total';  call define(_row_,"style","style=[background=lightred]"); end; endcomp; I re-typed this in so there could be typos (sorry in advance) but the actual code does work. Thanks! ... View more

We have version 8.2; ancient I know. We would like to create an excel spreadsheet with the autofilter set to on. I can't seem to find an example outside of the excelxp tagset (which I don't think I can use in 8.2). I am using htmlcss as my parent tagset. Any help is greatly appreciated. Thanks! ... View more

There was a time when I was able to move SAS programs between our network drive and unix by using a FTP process. I'm pretty sure that way of moving programs has been eliminated by my company. I'm attempting to find a new way and was wondering if I could use proc download/upload. I'm getting an error trying to download. This is my code... %signon(unix); rsubmit; OPTIONS MSTORED SASMSTORE=HOME; filename locref 'z:\'; filename fref '/p02/data/penv/hgsa/intrnet'; proc download infile=fref('trend_12_graph.sas') outfile=locref; run; endrsubmit; This is my error... ERROR: Invalid file, z:\. I've tried a bunch of different file locations for locref but it always comes back as an invalid file. Any help is much appreciated. Thanks! ... View more

I have an xls spreadsheet that I am going to use as a template. It will consist of 1 tab and I'll call the tab Sheet1. What I would like to do is create a tab for each provider number that exists in a data set (called priority_scale below). I don't know what the activesheet syntax should be (other than it shouldn't be what I've written) and I'm sure I need a little help with the code after the first copy occurs. Any help is much appreciated. Thanks! OPTIONS NOXWAIT NOXSYNC; X "'C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE'"; DATA _NULL_; zzzz = SLEEP(2); RUN; FILENAME CMDEXCEL DDE 'EXCEL|SYSTEM'; DATA _NULL_; FILE CMDEXCEL; PUT "[OPEN(""N:\PUBLIC\Chip's Adhocs\MISC\priority_scale.xls"")]"; RUN; %MACRO BYPRV(PROV); data _null_; file CMDEXCEL; ACTIVESHEET.COPY AFTER:=ACTIVESHEET.NAME="&PROV"; RUN; %MEND BYPRV; data _null_; set PRIORITY_SCALE; BY PROV; IF FIRST.PROV THEN DO; call execute('%BYPRV('||PROV||')'); END; run; quit; ... View more

How do I append to an access database? Do I need all variables in my SAS data set or I can append to the Access table with just some of them? I tried this, but SAS didn't like my syntax. proc sql noprint; connect to odbc (dsn="CBR Tracker"); execute(insert * from to_tracking into Tbl_entry1) by odbc; disconnect from odbc; quit; Thanks! ... View more

I am attempting to open an Excel spreadsheet but because I have a single quote in the location, it's dying on me. Can I get around it? I've tried using a macro var in place of the network location but haven't had any success with that. DATA _NULL_; FILE CMDEXCEL; PUT '[OPEN("N:\PUBLIC\Chip's Adhocs\ADHOCS 2006\balanced_scorecard\XLS\Balance Scoreard Data.xls")]'; RUN; ... View more

Is there a way to import all Microsoft Access tables found within a network folder without naming them specifically? I will have a monthly folder that will be populated with several access databases. I need to read them all in but I'd prefer not to have to change the code each month to specifically name each database. Thanks! ... View more