Code:
ods listing close;
ods html file="X:\Work\UG_AWARD\Validate\2223awards_oldcode.xls" style=journal;
proc tabulate data=hist.awards2223_sas missing f=dollar11. noseps;
class prog_fac level source level2 category awardname;
var awardamt;
tables level,source*level2*category all,awardamt=' ' / rts=40 indent=3 misstext='$0';
tables level,source*level2*category all,(prog_fac='Home Faculty' all)*awardamt=' ' / rts=40 indent=3 misstext='$0';
*tables level,source*level2*category*(awardname all) all,(prog_fac='Home Faculty' all)*awardamt=' ' / rts=40 indent=3 misstext='$0';
keylabel sum=' ';
run;Error:
ERROR: A component of C:\Users\username\AppData\Local\Temp\SAS Temporary
Files\computer_name\X:\Work\UG_AWARD\Validate\2223awards_oldcode.xls is not a directory.
ERROR: No body file. HTML output will not be created.
Reference:
SAS Support Usage Note 61280: The ODS HTML statement generates errors in the SAS® 9.4 TS1M5 windowing environment when the FILE= option includes a fully qualified path
Fix:
- Tools>Options>Preferences…>Results
- Uncheck “Use WORK folder”
Cause: The problem occurs because the “Use WORK folder” option is set as the default in the SAS registry and preferences. This causes the WORK folder to be prefixed to the path that is specified with the FILE= option. Separating the File and Path options can also fix the problem