topic Re: proc report in SAS Enterprise Guide

proc report

ManOfHonor — Tue, 21 Nov 2017 08:27:48 GMT

I have a dataset consisting of two rows. I'd like to convert it to html table using proc report without summarizing and statistics. But istead I get a single row with sums by each column.

Re: proc report

Criptic — Tue, 21 Nov 2017 08:43:05 GMT

Hey I don't know why you want to use proc report but if you just want to output the table as HTML have you tried proc print with ods html?

data aaa;
    set sashelp.cars(obs=2);
run;

ods html;
proc print data=aaa noobs;
run;

ods html close;

Re: proc report

Shmuel — Tue, 21 Nov 2017 08:44:04 GMT

Please post a sample of your data and your code.

Re: proc report

ManOfHonor — Tue, 21 Nov 2017 09:00:36 GMT

I tried your code, got an error:
ERROR: Insufficient authorization to access /sas/config/Lev1/SASApp/sashtml3.htm.
ERROR: No body file. HTML output will not be created.

Re: proc report

Criptic — Tue, 21 Nov 2017 09:04:28 GMT

Try talking to you Admin about getting write access to that directory

Re: proc report

ManOfHonor — Tue, 21 Nov 2017 09:07:49 GMT

IT WORKED! Without ods html; and ods html close;

I will export to html manually.