I am a sas user at my company and have been asked to produce some reporting that automatically opens in excel. To accomplish this I have been trying to use the excelXP tagsets (multiple sheets are going to be required for this project).
I have tried many different things and searched a lot of different websites but no matter what I do, excel cannot open the file I create. I get a window message 'Problems during load...Style'.
Here is some sample code that I run that will produce this error:
data whole_v2;
set sashelp.prdsale;
where quarter = 1;
terr_id = substr(division,1,3);
productgroup = substr(product,1,1);
total_scripts = actual / 100;
bsm = region;
physician_name = substr(compress(country,'.'),1,2);run;
ODS TAGSETS.EXCELXP FILE=ODSFILE style=sasweb;
proc report data=whole_v2 nowd MISSING split='/';
COLUMN terr_id bsm physician_name
total_scripts, year, productgroup;
define terr_id/group 'Terr/ID';
define bsm/group;
DEFINE physician_name / group 'Phy/Name';
DEFINE year / across ' ';
DEFINE productgroup / across ' ';
DEFINE total_scripts / sum format=comma12. ' ';
break after terr_id/summarize
style=[font_weight=bold background=red];run;
ODS TAGSETS.EXCELXP CLOSE;
I found this code off of the forum as an example someone got to work. I am running SAS 9 (TS1M3). I assume this is 9.1.3 and Excel 2007. When I first used tagset excelxp I got a warning message of "Experimental Excel XP tagset." I could not find any information as to what version it was. Maybe somebody can tell based on the warning message I received.
I then went to
http://support.sas.com/rnd/base/ods/odsmarkup/index.html to get the update. I ran the same code but with this updated tagset. I got the same error message.