BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ManOfHonor
Obsidian | Level 7

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.  

1 ACCEPTED SOLUTION

Accepted Solutions
Criptic
Lapis Lazuli | Level 10

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

5 REPLIES 5
Criptic
Lapis Lazuli | Level 10

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;
ManOfHonor
Obsidian | Level 7
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.
Criptic
Lapis Lazuli | Level 10
Try talking to you Admin about getting write access to that directory
ManOfHonor
Obsidian | Level 7

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

I will export to html manually.

 

Shmuel
Garnet | Level 18

Please post a sample of your data and your code.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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