topic Re: (Proc Format) custom formats that change with length in SAS Programming

(Proc Format) custom formats that change with length

PhilC — Wed, 12 Feb 2020 15:07:34 GMT

Is there a way to create a custom format that changes depending on the length specified when the format is applied? For example, how WORDDATE changes format depending on the length given (3, 9, 12, and 20).

WORDDATE Format

Writes date values as the name of the month, the day, and the year in the form month-name dd, yyyy.

The example table uses the input value of 19158, which is the SAS date value that corresponds to June 14, 2012.

SAS Statement	Result
put term worddate3.;	Jun
put term worddate9.;	June
put term worddate12.;	Jun 14, 2012
put term worddate20.;	June 14, 2012

Re: (Proc Format) custom formats that change with length

PeterClemmensen — Wed, 12 Feb 2020 15:06:52 GMT

Yes. What logic do you want in the format?

Re: (Proc Format) custom formats that change with length

PhilC — Wed, 12 Feb 2020 18:05:04 GMT

@PeterClemmensen :

For a hypothetical example take fiscal year FMTNAME="FY". Define a format such that the format would help produce these results:

SAS Statement	Result
put today Fy6.;	FY1920
put today Fy7.;	FY19-20
put today Fy9.;	FY2019-20
put today Fy11.;	FY2019-2020

Re: (Proc Format) custom formats that change with length

ballardw — Wed, 12 Feb 2020 15:39:21 GMT

You really need to be specific about how you expect to use it.

That is already built into custom formats with the options DEFAULT and MAX . Default sets the default display length, calculated from values if not supplied. You can specify any n up to the default. If you specify a value for MAX in the format then you can specify the display length n up to that value. Appearance in output will be highly dependent on procedure used as most will left justify output by default.

With custom formats to insert leading spaces you will likely need to use a Put option -R.

proc format library=work;
value mynum ( max=30)
1 ='one';
run;


data junk;;
   term=1;

put term mynum. -r; 
put term mynum3.-r;
put term mynum9.-r;
put term mynum20.-r; 
run;

Other than report procedures you may not get leading space appearance without modifying table templates for ODS objects.

In report procedures such as Report or Tabulate you would need to use the Style override ASIS to get leading spaces.

Re: (Proc Format) custom formats that change with length

yabwon — Wed, 12 Feb 2020 15:51:14 GMT

Hi @PhilC ,

I know it is not the answer to your question but may FCMP will be sufficient?

options cmplib = _null_;
proc fcmp outlib = work.f.p;
  function FY(x,l) $ 11;
    length val $ 11;
    select;
      when (1<= l <= 6) do; val = cats("FY",mod(year(x)-1,100),mod(year(x),100)); end; 
      when (    l  < 9) do; val = cats("FY",mod(year(x)-1,100),"-",mod(year(x),100)); end;
      when (    l  < 11) do; val = cats("FY",year(x)-1,"-",mod(year(x),100)); end;
      when (    l  = 11) do; val = cats("FY",year(x)-1,"-",year(x)); end;
      otherwise val="**";
    end;
    return (val);
  endsub;
run;

options cmplib = work.f;

data test;
  array a[12] $ 11;
  do i=1 to 12;
    a[i]=FY(today(),i);
  end;
run;

All the best

Bart

Re: (Proc Format) custom formats that change with length

PhilC — Wed, 12 Feb 2020 17:19:45 GMT

@ballardw , thanks, but that example is just way too trivial and not at all helpful.

But the PUT -r option is something that I find that I could use, in another context, and that I didn't previously know about.

Re: (Proc Format) custom formats that change with length

ballardw — Wed, 12 Feb 2020 19:09:44 GMT

@PhilC wrote:

@ballardw , thanks, but that example is just way too trivial and not at all helpful.

But the PUT -r option is something that I find that I could use, in another context, and that I didn't previously know about.

Well, since you didn't specify how you want an example to work and picked on Date values, which SAS does some very interesting things not shown to us (such as not displaying years past 9999 in any way shape or form even though the date manipulation functions don't have issues until around year 20,000) couldn't come with anything other than trivial.

Examples of actual values and the changing appearance desired would be needed to get a more realistic example.

Re: (Proc Format) custom formats that change with length

PhilC — Sun, 16 Feb 2020 15:45:58 GMT

@ballardw , you're right, I need to re-word my question