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

Hi All:

Here's a tricky one - I would like to use PROC TABULATE to create an empty table.  Basically, my user wants the overnight job to build a table that they can use for data entry during the day.

Problem is that when all data is missing PROC TABULATE deletes the page (I use ODS to output the page with ExcelXP).  If I put 1 lone value in the table, PROC TABULATE works fine - all cells are empty except 1.

Is there a way to do this with no actual data for the table cells?

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Have you tried creating a custom format for that single value such that it displays a single space? If that doesn't work you might try a format that assigns a null character. In the Windows world that is done using the numeric keypad holding down the ALT key and typing 255 and releasing ALT.

View solution in original post

2 REPLIES 2
ballardw
Super User

Have you tried creating a custom format for that single value such that it displays a single space? If that doesn't work you might try a format that assigns a null character. In the Windows world that is done using the numeric keypad holding down the ALT key and typing 255 and releasing ALT.

OS2Rules
Obsidian | Level 7

Excellent!

Added a format to the reporting variable with low-high=' ', then used that on the tabulate.

Thanks again.

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!

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
  • 2174 views
  • 0 likes
  • 2 in conversation