Date:         Wed, 8 Aug 2007 08:52:31 -0500
Reply-To:     "data _null_;" <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_;" <datanull@GMAIL.COM>
Subject:      Re: PROC REPORT print character vairable with line command
Comments: To: John Keane <john.keane@watsonwyatt.com>
In-Reply-To:  <200708081043.l787fv8p014886@mailgw.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

If you supplied some test data it would be easier to debug, but I'm
pretty sure that you can't "LINE" a variable to the right of the
breaking variable.   Well you can but the "value" is missing.  Try
moving INDUSTRY to the left of the breaking variable in the column
statement.

You may find the following SUGI paper useful.

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

On 8/8/07, John Keane <john.keane@watsonwyatt.com> wrote:
> I can't seem to figure out why this doesn't work.
>
> I'm trying to print the value of a character variable (INDUSTRY) using the
> LINE command in a COMPUTE BEFORE.  Is this even possible?
>
> Code segment shown below.
>
> option nomprint nosymbolgen nomlogic nodate nonumber orientation=landscape
> nobyline;
> ods rtf file="d:\test.rtf" style=Exempt startpage=no;
> ods escapechar="^";
>
> title1 j=l "0923 Human Resources Administration Supervisor";
> title2 j=l height= 14pt "For Profit Organizations";
>
> proc report nowindows headskip headline ps=50
>  data=HRC.HRC_EXEMPT_GEO_RESULTS
>  style(report)={outputwidth=10.3in background=white}
>  style(header)={background=white};
>
>  by pos pos_title;
>
>  columns
>    POS groupvalue LEV INDUSTRY_TYPE INDUSTRY
>    SALARY_ORG SALARY_EMP;
>
>  define pos / order noprint;
>  define groupvalue / order noprint;
>  define INDUSTRY_TYPE / order noprint;
>  define INDUSTRY / order noprint;
>  define LEV / order noprint;
>
>  compute before groupvalue / style={just=left font_weight=bold
> font_size=7pt background=white bordercolor=white};
>   line INDUSTRY $char100.;
>  endcomp;
>
>  define SALARY_ORG/display "^n^n# OF^nORGS" style(column)=
> {cellwidth=0.45in cellheight=7pt just=right} style(header)={cellwidth=
> 0.45 in} format=5.0;
>  define SALARY_EMP/display "^n^n# IN^nPOS" style(column)={cellwidth=0.45
> in cellheight=7pt just=right} style(header)={cellwidth= 0.45 in}
> format=5.0;
>
> run;
> ods rtf close;
>