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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 1132 views
  • 0 likes
  • 3 in conversation