topic Re: Doe sthe SIZEKMG. format have limits? in SAS Programming

Does the SIZEKMG. format have limits?

Anne_A — Fri, 07 Jul 2023 13:29:28 GMT

Dear Community,

I would like to use the SIZEKMG. format (quite obviously to show file sizes) but I seem to encounter a limitation: when the value becomes "bigger" (example attached) the shown value (both when opening the dataset and when generating a report) is made of * only.

Any hint?

Many thanks in advance

Anne.

data have;
 format size sizekmg22.;
 input size;
cards4;
5744099328
1785724928
28157399040
1741762461696
17674880794624
;;;;
run;

Re: Doe sthe SIZEKMG. format have limits?

PaigeMiller — Fri, 07 Jul 2023 10:30:39 GMT

Generally, the first step I would recommend in situations like this is to check the documentation.

SIZEKMG FORMAT

Re: Doe sthe SIZEKMG. format have limits?

ErikLund_Jensen — Fri, 07 Jul 2023 11:04:47 GMT

Hi @Anne_A

I ran into the same problem, so I made this custom format:

proc format library=library;
	picture sizekmgt (round default=8)
	low - 1023 = '0009 bt'
	1024 - 1048575 = '009.9 KB' (mult = %sysevalf(10/1024))
	1048576 - 1073741823 = '009.9 MB' (mult = %sysevalf(10/1048576))
	1073741824 - 1099511627775 = '009.9 GB' (mult = %sysevalf(10/1073741824))
	1099511627776 - high = '009.9 TB' (mult = %sysevalf(10/1099511627776))
	;
run;

Re: Doe sthe SIZEKMG. format have limits?

Anne_A — Fri, 07 Jul 2023 12:26:22 GMT

Hi @PaigeMiller ,

Actually I had checked the documentation. Your comment seems to imply I should find relevant info in there, but even after looking again I don't see any. Is there anything I should have noticed?

Re: Doe sthe SIZEKMG. format have limits?

Anne_A — Fri, 07 Jul 2023 12:18:16 GMT

Awesome! Thank you so much @ErikLund_Jensen 😊!