Error using ODS

[GreggB]

When I submit the following code, I get this error: 

ERROR: A component of C:\Users\gbibb\AppData\Local\Temp\SAS Temporary

       Files\_TD3472_DO-GBIBB-LT2_\G:\Departments\Research\MAP\1415\Longitudinal Match\Spring to

       Spring\math_long_match_by_Spr14_ELEMschool.xls is not a directory.

ERROR: No body file. HTML output will not be created.

HOWEVER, when I submit the same code a 2nd time, it works fine.  Is SAS creating a directory on the first submit that allows it to work on the second submit?

Code:

proc sort data=map2;

by school;

run;

ODS html body='G:\Departments\Research\MAP\1415\Longitudinal Match\Spring to Spring\math_long_match_by_Spr14_ELEMschool.xls';

proc tabulate data=MAP2;

by school;

where grade_s14 ne '' and grade_s13 ne '' and grade_s12 ne '' and grade_s14 not in ('10','11','12','9','8','7','6');

class grade_s14 grade_s13 grade_s12 Math_Met_SS_1314 Math_Met_SS_1213;

table grade_s12*grade_s13*grade_s14, Math_Met_SS_1213*(n*f=6.0 pctn<Math_Met_SS_1213>='PCT'*f=6.1) Math_Met_SS_1314*(n*f=6.0 pctn<Math_Met_SS_1314>='PCT'*f=6.1) / rts=25 box=_page_condense;

title'math results';

run;

ods html close;

[ballardw · Accepted solution]

I've seen this happen and is a combination of preferences using the work folder for default output. The referenced

C:\Users\gbibb\AppData\Local\Temp\SAS Temporary

       Files\_TD3472_DO-GBIBB-LT2_\

part of the error was very likely the location of the WORK library.

If I recall correctly HTML output works better with a Path="G:\Departments\Research\MAP\1415\Longitudinal Match\Spring to Spring" Body="math_long_match_by_Spr14_ELEMschool.xls" reference.

And since you apparently actually want Excel output you might use ODS tagsets.Excelxp and create Excel readable xml files.

[GreggB]

Thanks.  You actually touched on the real problem -- I need to learn more about using tagsets.  I've done some reading on them but haven't gotten a handle on it.  Any readings you can suggest would be greatly appreciated.

Gregg

[ballardw]

I suspect if you search this forum for "tagsets.excelxp" you will find more than enough examples (right and wrong) to get started.