BookmarkSubscribeRSS Feed
tipscode
Obsidian | Level 7

I am generating a large number of proc tabulates (30 or so) using ods csv all in SAS 9.4, and the last table doesn't show when I select to open the csv file from the initial prompt. When I try to open this initial file from the file destination - still no last table.

 

I have to manually select the table from Results, click on the csv icon under the table itself, to open another csv file that will have the last table.

 

Is there a way to resolve this so that the last table will appear on the initial run?

 

Thank you.

2 REPLIES 2
Reeza
Super User

Can you provide some sample code so we can replicate your issue?

Its likely there's something in that last process that's ending early or an error that's causing it to not generate.

ballardw
Super User

I would not think CSV is a good target output for proc tabulate as spanned rows and or columns make the output potentially extremely difficult to read or interpret.

 

And would get worse with multiple tables in a single file.

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 760 views
  • 0 likes
  • 3 in conversation