topic tagsets.excelxp: special characters to create indentation? in ODS and Base Reporting

tagsets.excelxp: special characters to create indentation?

gzr2mz39 — Tue, 20 May 2014 19:14:35 GMT

I'm using ods tagsets.excelxp to output my results.
Are there any special characters I can add in front of "-Lost-Time" so that "-Lost-Time" appears indented (3-5 spaces is fine) when I output in Excel using proc report?

proc format;
value $oshaf "a_reg"="Reg"
"b_lost"="-Lost-Time"
"c_darb"="DARB"
;
run;

Re: tagsets.excelxp: special characters to create indentation?

Chevell_sas — Tue, 20 May 2014 20:32:27 GMT

You can use the non breaking space characters to add the space and then use the PROTECTSPACIALCHARS= attribute so that they are not protected.

proc format;
value $oshaf    "a_reg"="Reg"
                        "b_lost"='   -Lost-Time'
                         "c_darb"="DARB" ;
run;

data one;
length a $10.;
a="a_reg";
output;
a="b_lost";
output;
a= "c_darb";
output;
run;

ods tagsets.ExcelXP file="c:\temp.xlml";

proc print style(data)={protectspecialchars=off};
format a $oshaf.;
run;

ods tagsets.ExcelXp close;

Re: tagsets.excelxp: special characters to create indentation?

gzr2mz39 — Tue, 20 May 2014 22:34:45 GMT

Thank you for the protectspecialchars suggestion. However, I'm not sure what is the character(s) needed to create space(s) in Excel? Thank you.

Re: tagsets.excelxp: special characters to create indentation?

Reeza — Tue, 20 May 2014 22:42:43 GMT

Notice that in Chevell's code he's manually added spaces in his proc format.

proc format;

value $oshaf "a_reg"="Reg"

"b_lost"=' -Lost-Time'

"c_darb"="DARB" ;

run;

Re: tagsets.excelxp: special characters to create indentation?

gzr2mz39 — Tue, 20 May 2014 22:53:28 GMT

Yes, I saw that. It doesn't seem to work for me. No space is added.

Re: tagsets.excelxp: special characters to create indentation?

Reeza — Wed, 21 May 2014 01:54:50 GMT

ALT+255?

I can't test it right now

http://www2.sas.com/proceedings/sugi31/055-31.pdf

Re: tagsets.excelxp: special characters to create indentation?

Cynthia_sas — Wed, 21 May 2014 02:33:28 GMT

Hi:

I tried the HTML named entity for non-breaking space with Chevell's code -- just changed the format to:

proc format;
value $oshaf    "a_reg"="Reg"
                "b_lost"='   -Lost-Time'
                "c_darb"="DARB" ;
run;

Where I used the following: & nbsp ; (ampersand-nbsp-semi-colon) without ANY spaces. I am writing it this way so you can see what needs to be typed. I am also attaching a pix of the syntax and a shot of the output. Since this posting mechanism uses HTML, it may "eat" the non-breaking space entity.

Cynthia

Drat! the post ate my ampersand-nbsp; -- without any spaces -- look at the screen shot.

Re: tagsets.excelxp: special characters to create indentation?

gzr2mz39 — Wed, 21 May 2014 18:17:06 GMT

Thank you.