cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Diana_K
‎03-15-2023
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Adding blank line after a group

by Calcite | Level 5 in ODS and Base Reporting
‎01-13-2023 06:21 AM
‎01-13-2023 06:21 AM
Hello,   Thank you for the reply.   I am working on sensitive data and with a lot of internal macros I can't share and I was trying to avoid having to blind the information, thought my question was clear, I apologize 🙂   Please see below the output dataset, I need one empty line in the RTF report after each GROUP value, except for the last value, so no empty line after GROUP=7.   Please note nothing can be changed to the page layout, it's a standard and I can't update the widths for anything related to the footers and titles.     Hope this is enough, if not I will remove the question since I can't add anything more.   Thankyou Diana   ... View more

Adding blank line after a group

by Calcite | Level 5 in ODS and Base Reporting
‎01-13-2023 05:50 AM
‎01-13-2023 05:50 AM
Hello,   I have a report where I have introduced one blank line after each section, however my last observation crosses the next page because of the empty line the report adds after that last observation. Practically my last observation is the last section and now I am left with 1 row on the second page   Is there a way to condition this compute after, for it not to compute after the last observation?   compute after group; line @1 ""; endcomp;   I've tried writing the number of observations (which is 26) in my dataset, and using it as a macro variable but now the whole empty line disappears, something like this.   %if &nobs. lt 26 %then %do; compute after group; line @1 ""; endcomp; %end;   Thank you! Diana ... View more

Re: ODS - # character from column label doesn't appear in excel output

by Calcite | Level 5 in ODS and Base Reporting
‎01-06-2023 04:12 AM
‎01-06-2023 04:12 AM
Aaaaaah thank you, yes, I feel silly now. I've picked up this program from someone else, indeed changing the # into something else solved the issue.   Much appreciated!   ... View more

ODS - # character from column label doesn't appear in excel output

by Calcite | Level 5 in ODS and Base Reporting
‎01-06-2023 02:59 AM
‎01-06-2023 02:59 AM
Hello,   I am new with both ODS and proc reports, and I have a variable with the label as "Sample #" but I can't get the # to come through the excel report as well. I've attached a picture of the attributes of my variables, the proc report program as well as the excel output.   Thank you!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-15-2023 02:07 PM
Likes given to
View All
Quick links