topic Re: Alignment adjustment for footnote in SAS Studio

Alignment adjustment for footnote

sheren_deep1 — Tue, 02 Oct 2018 03:46:05 GMT

Hi,

I need help on adjusting alignment for footnotes. I have got the following codes currently:

TITLE j=left "Jadual B1 : Jumlah penduduk mengikut kumpulan etnik, kawasan pihak berkuasa tempa'tan dan negeri, Malaysia, 2010";
Title2 font=bold italic j=left "Table   B1 : Total population by ethnic group, local authority area and state, Malaysia, 2010";
title3 " ";
title4 j=left "Negeri : NEGERI SEMBILAN";
title5 font=bold italic j=left "State";

proc tabulate data=WORK.DOSM order=data;
	where not missing(NEW_ETHNICITY);
	class DISTRICT NEW_ETHNICITY NEW_CITIZENSHIP /Missing;
	classlev NEW_ETHNICITY;
	CLASSLEV NEW_citizenship;
	classlev district;
	var ID;
	table ALL DISTRICT=' ', ALL NEW_ETHNICITY='Warganegara Malaysia
Malaysian citizens' ALL 
		NEW_CITIZENSHIP='Bukan Warganegara Malaysia *Non-   Malaysian citizens *' 
		/Box='Daerah Pentadbiran/Kawasan Pihak Berkuasa Tempatan
										Administrative District/Local Authority Area' row=float MISSTEXT='0';
	keylabel N=' ';
	keylabel all='Jumlah Total';
	footnote font=arial bold j=left "Nota" font=arial bold italic "/Note";
	footnote2 j=l   f='ARIAL amt/bold' "Angka-angka di atas tidak disesuaikan untuk kurang penghitungan.";
run;

And i get the following result:

However, i need the footnote2 first word 'Angka' to start after Note/Nota as per the following example:

Could anyone please help me on this?

Thank you.

Re: Alignment adjustment for footnote

RW9 — Tue, 02 Oct 2018 07:57:47 GMT

There is no automatic way of doing this, valid alignements are left, right, and center. The simplest method is to add spaces to increment the footnote out to where you want it. I would also avoid putting footnotes in the proc step, there is no need and it just clutters the proc, and please avoid upper case coding, makes reading the code much harder.

Re: Alignment adjustment for footnote

sheren_deep1 — Tue, 02 Oct 2018 08:00:21 GMT

Hi,

Thank for your reply. Can you please explain to me how to add spaces to increment the footnote? I need the table precisely on this format; hence i need the footnote.

Re: Alignment adjustment for footnote

RW9 — Tue, 02 Oct 2018 08:14:58 GMT

Press the spacebar:

footnote font=arial bold j=left "Nota" font=arial bold italic "/Note";
footnote2 j=l   f='ARIAL amt/bold' "          Angka-angka di atas tidak disesuaikan untuk kurang penghitungan.";

You may have to add or remove a space to get the alignment. If you have to do this a lot, consider aligning the footnotes rather than offsettting them somewhat. Otherwise you may need a cat(repeat(" ",lengthn(previousfootnote)-1),"Your new footnote")

Re: Alignment adjustment for footnote

sheren_deep1 — Tue, 02 Oct 2018 08:20:34 GMT

Hi,

I have actually tried adding blank spaces before the first letter. However, this does not work for me :(. Any other suggestion?

Thanks

Re: Alignment adjustment for footnote

RW9 — Tue, 02 Oct 2018 08:59:26 GMT

"However, this does not work for me" - does not tell me anything. What did not work, was it not aligned, did it crash? As I said there is no automatic alignment for what you are asking (as its not a standard alignment), so you need to fix it in yourself somehow.

Re: Alignment adjustment for footnote

Ksharp — Tue, 02 Oct 2018 10:53:34 GMT

ods escapechar='~';
proc tabulate ........
..............

footnote font=arial bold j=left "Nota" font=arial bold italic "/Note";
	footnote2 j=l   f='~_~_~_~_~_~_~_~_~_ARIAL amt/bold' "Angka-angka di atas tidak disesuaikan untuk kurang penghitungan.";

Re: Alignment adjustment for footnote

sheren_deep1 — Thu, 04 Oct 2018 02:31:03 GMT

Hi,

It works. Thank you for the help. 🙂