topic Re: Requesting Format name length - Value vs datasets(control sets) clarification please? in SAS Programming

Requesting Format name length - Value vs datasets(control sets) clarification please?

novinosrin — Fri, 10 Jul 2020 14:12:24 GMT

Good morning folks,

I would like to use a dataset contents as formats using control options(CNTLIN/OUT), however I want to be absolutely sure of the lengths and names of format names that my dataset concatenated variables that would go as FMTNAME. My concern is that I vaguely remember fmtnames in value/pic formats do not exceed 32 chars. I also vaguely remember the FMTNAME from a dataset doesn't quite have to conform to that rule??? I did a below test and it seems to be fine up to 40 chars, yet I want to confirm with you before I write the full code and move to production.

I know you would quite likely ask whether have I read the docs, hmm not quite. I am being cheeky here as I am really not feeling well and am tired this morning and would like some help. Pardon me please! Some confirmation from you folks will give me the confidence after all. That's my need!

PS Any additional caution, please please please let me know-



data fmt;
/*Assign a lengthy fmtname*/
 retain fmtname 'abcfkjjhgfkljsebnglwkjengkljwejnrwkjnjnrgvkjsnbvkjaesnbrkfbnabnvlseajbndlksjnvdasdbnsk';
 start=1;
 end=5;
 label='ok';
 output;
 start=.;
 end=.;
 label='NA';
 hlo='o';
 output;
run;

proc format cntlin=fmt fmtlib;
run;

data test;
 set fmt(keep=fmtname);
 do i=1 to 10;
  need=putn(i,fmtname);
  output;
 end;
 stop;
run;

The MAX LENGTH takes 40 chars. Can this be modified to accommodate higher lengths?

Re: Requesting Format name length - Value vs datasets(control sets) clarification please?

Kurt_Bremser — Fri, 10 Jul 2020 12:54:00 GMT

When you look at the output of proc format. you will see that the name has been truncated.

So while you can use longer variables, everything after character 32 (or 31 for character formats) will have no effect, and such names might lead to funny results (inadvertently "concatenated" or replaced formats).

Re: Requesting Format name length - Value vs datasets(control sets) clarification please?

Reeza — Fri, 10 Jul 2020 14:56:28 GMT

Just out of curiousity, adding on to this question, do you need to leave spaces in the name for the width and decimal portion?

I know the format may not use that, but it's sort of an implicit parameter in any format if I understand correctly (which may not be right at all).

Re: Requesting Format name length - Value vs datasets(control sets) clarification please?

Tom — Fri, 10 Jul 2020 15:08:38 GMT

I think you are confusing the name of the format (which is limited to 32 characters) and an actual format specification. A format specification must include a period (so 33 characters) and can also include a width and decimal places numbers. Since the maximum length SAS allows for character strings is 32,767 the maximum number of digits needed for the width is 5. I suspect that the maximum number of digits that are allowed for decimal places is much smaller than 32,767. I have normally seen people use a length of 41 for a variable that is used to store a format specification.