Desktop productivity for business analysts and programmers

proc report

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

proc report

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.  


Accepted Solutions
Solution
3 weeks ago
Contributor
Posts: 53

Re: proc report

Posted in reply to ManOfHonor

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;

View solution in original post


All Replies
Solution
3 weeks ago
Contributor
Posts: 53

Re: proc report

Posted in reply to ManOfHonor

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;
Occasional Contributor
Posts: 11

Re: proc report

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.
Contributor
Posts: 53

Re: proc report

Posted in reply to ManOfHonor
Try talking to you Admin about getting write access to that directory
Occasional Contributor
Posts: 11

Re: proc report

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

I will export to html manually.

 

Trusted Advisor
Posts: 1,613

Re: proc report

Posted in reply to ManOfHonor

Please post a sample of your data and your code.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 151 views
  • 0 likes
  • 3 in conversation