topic Re: proc tabulate create new line in label and capitalize for each word in SAS Enterprise Guide

proc tabulate create new line in label and capitalize for each word

merahilyana — Tue, 20 Aug 2019 03:39:12 GMT

TITLE;
TITLE1 j=left FONT='Arial' c=black Bold "student UITM";
TITLE2 j=left FONT='Arial' italic H=3 " 2000";
/* -------------------------------------------------------------------
Code generated by SAS Task

Generated on: Monday, August 19, 2019 at 1:04:19 PM
By task: Summary Tables (2)

Input Data: SASOA:WORK.Student
Server: SASOA
------------------------------------------------------------------- */

%_eg_conditional_dropds(WORK.AA);

/* -------------------------------------------------------------------
Run the tabulate procedure
------------------------------------------------------------------- */
ods escapechar='\';
PROC TABULATE
DATA=WORK.student (FIRSTOBS=1) STYLE={CELLPADDING=50 TEXTALIGN=C HEIGHT=20}

OUT=WORK.AA(LABEL="Summary Tables for Student UITM")

;
VAR STATE_ID;
CLASS REF_YEAR / ORDER=UNFORMATTED MISSING;
CLASS STATE_NAME_E / ORDER=UNFORMATTED MISSING;
TABLE
/* Row Dimension */
ALL={LABEL="Malaysia"} STATE_NAME_E={LABEL=" "} ,
/* Column Dimension */
REF_YEAR={LABEL=" "}*(STATE_ID={LABEL=" "}*N ={LABEL='Bilangan Numbers'}*F=COMMA12. STATE_ID={LABEL=" "}*ColPctN={LABEL="%"})
/*Table Options */
/ BOX={LABEL='Negeri State'};
;

RUN;
/* -------------------------------------------------------------------
End of task code
------------------------------------------------------------------- */
RUN; QUIT;
TITLE;

please help me:

1) how to split/ new line in Negeri State [BOX={LABEL='Negeri State'}] and Bilangan Numbers [N ={LABEL='Bilangan Numbers'}].

eg: in the table will be [Negeri state] but I want it will be like Negeri

State

2) how to do uppercase to be Capitalize each word

eg: KUALA LUMPUR will be Kuala Lumpur

Re: proc tabulate create new line in label and capitalize for each word

andreas_lds — Tue, 20 Aug 2019 05:58:12 GMT

@merahilyana wrote:

2) how to do uppercase to be Capitalize each word

eg: KUALA LUMPUR will be Kuala Lumpur

You can use the function propcase to apply the required changes.

EDIT: You will need to write a data step to use the function.

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Tue, 20 Aug 2019 07:25:50 GMT

i done try but it get error

Re: proc tabulate create new line in label and capitalize for each word

andreas_lds — Tue, 20 Aug 2019 07:45:14 GMT

@merahilyana wrote:

i done try but it get error

Because i don't work for nsa or cia i don't have access to your computer and can't see the log with the error message. You should post the log using the {i} icon.

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Tue, 20 Aug 2019 08:14:30 GMT

where place I must put propcase?? it is after proc tabulate or before or can put inside proc tabulate

Re: proc tabulate create new line in label and capitalize for each word

andreas_lds — Tue, 20 Aug 2019 08:37:35 GMT

@merahilyana wrote:

where place I must put propcase?? it is after proc tabulate or before or can put inside proc tabulate

You need a separate step before proc tabulate.

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Tue, 20 Aug 2019 08:56:37 GMT

Can you give me the example..

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Tue, 20 Aug 2019 09:15:17 GMT

data;
STATE_NAME_E=propcase(STATE_NAME_E);
run;

i did like this before proc tabulate.. but nothing changed in result

Re: proc tabulate create new line in label and capitalize for each word

andreas_lds — Tue, 20 Aug 2019 11:33:03 GMT

You haven't written any sas code, right?

You need something like

data work.ProperStateName;
  set INSERT_THE_NAME_OF_YOUR_DATASET_HERE;
  STATE_NAME_E=propcase(STATE_NAME_E);
run;

Afterwards you have to use work.ProperStateName in proc tabulate.

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Wed, 21 Aug 2019 03:17:26 GMT

ok tq..i will try

it appears on data set but not in the result tabulate..

how

Re: proc tabulate create new line in label and capitalize for each word

andreas_lds — Wed, 21 Aug 2019 05:52:45 GMT

@merahilyana wrote:

ok tq..i will try

it appears on data set but not in the result tabulate..

how

Have you changed the dataset in proc tabulate?

Re: proc tabulate create new line in label and capitalize for each word

merahilyana — Wed, 21 Aug 2019 10:56:16 GMT

Yay, Finally I can solve it question no 2. Thank you for helping me.

Re: proc tabulate create new line in label and capitalize for each word

LisaSklar — Tue, 27 Aug 2019 19:50:53 GMT

To insert a line break in the middle of a label, you just need to use your ODS Escapechar with the line break command, 'n'. Try this:

{LABEL='Negeri\nState'}

Cheers,

Lisa