BookmarkSubscribeRSS Feed
sheren_deep1
Calcite | Level 5

Hi, 

 

I have the following proc tabulate codes 

 

TITLE j=left "Jadual 5.1: Jumlah penduduk mengikut taraf perkahwinan, kumpulan umur, jantina dan negeri, Malaysia, 2010";
Title2 font=bold italic j=left "Table 5.1: Total population by marital status, age group, sex and state, Malaysia, 2010";
title3 j=left " ";
title4 j=left "Jumlah:Malaysia";
Title5 font=bold italic j=left "Total";
ods escapechar='^';

proc tabulate data=work.table5dot1 class AGE_GROUP GENDER Marital_status1;
	var ID;
	table (GENDER={LABEL=' '} ALL='Grand Total') * (AGE_GROUP={LABEL=' '} 
		ALL='Jumlah ^S={font_style=italic}/ Total'), 
		ALL='Jumlah ^S={font_style=italic}/ Total' 
		Marital_status1='Taraf Perkahwinan
	^S={font_style=italic} / Marital status' / 
		Box='Jantina dan kumpulan umur ^S={font_style=italic} / Sex and age group';
	keylabel N=' ';
run;

The above codes generate the following table: 

 

 

 

 

Proc tabulate.PNG

 

However, I need the line separator to be eliminated from the body of the table and only the headers has lines to separate the rows . The output has to be like the following image 

proc tabulate result.PNG

 

 

Could anyone please help me on how to get the output as per the above image. 

 

Thank you. 

1 REPLY 1
SAS_Cares
SAS Employee

Sheren,

See SAS Documentation under Tabulate Procedure - Indenting Row Headings and Eliminating Horizontal Separators http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1azfrb23t8082n1jk3xq... Appears that might resource might be helpful to you!  

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 587 views
  • 0 likes
  • 2 in conversation