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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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