topic Re: Compute block indent / left margin only working for the first line in ODS and Base Reporting

Compute block indent / left margin only working for the first line

dstephenson — Fri, 11 Feb 2022 18:52:09 GMT

In the proc report I'm creating, I'm needing the left margin or indent to dynamically change with the value of a variable (which I have named "indent").

I have had this work before, with the exact same code, so I'm at a loss as to why it is suddenly not working correctly now.

Now, it is working for only some of my lines and just.... not working on the rest.

Code:

	compute textcol;
		if indent = 1 then do;
			call define(_col_, 'style', 'style={leftmargin=.22in}');
		end;
		if indent = 2 then do;
			call define(_col_, 'style', 'style={leftmargin=.38in}');
		end;
	endcomp;

Data:

Current Output:

Any ideas what could be causing this? A setting in the rtf template maybe??

Re: Compute block indent / left margin only working for the first line

ballardw — Fri, 11 Feb 2022 19:28:43 GMT

Really need to show the entire procedure code and possibly even the ODS destination and style options in effect.

And probably should include some example data. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

Re: Compute block indent / left margin only working for the first line

Cynthia_sas — Fri, 11 Feb 2022 21:59:27 GMT

Hi:
I agree with @ballardw -- the order of the variables in the column statement can impact what you're doing. Also the usage type of the INDENT variable can have an impact. Showing your data is useful, but showing the code is better. I don't quite understand how you're getting Courier New looking fonts out of PROC REPORT since the default font for most destinations is a fixed pitch font. So that's another question about what might be in your code.

In doing a quick test with some fake data, I see that LEFTMARGIN works for me in RTF and PDF output reports. I would not expect this to work in HTML or LISTING destinations. Here's an example in the PDF output file:

The RTF file looks the same. I made helper variables called row_ord and linenum in addition to indent and text variables. The code I used is shown below:

Note that in my code the INDENT variable is given a DISPLAY usage. If it was a numeric variable with the default analysis usage I would have needed to change the code in the COMPUTE block.

Cynthia