topic user-defined format from a function in SAS Programming

user-defined format from a function

ANLYNG — Fri, 01 Sep 2017 13:10:31 GMT

Hi,

Is there a simple way to make a format thar simply concatinate two char variables?

Data could be like this:

Organisation, status

GGGG, N

YYYY, N

I wish to use a format to the organisaton variable som I get this output:

Organisaton, status

N GGGG,N

N YYYY,N

Alternative set a constant value as a pre-fix on the organisation based on content in another variable.

Like this :

CASE WHEN town=HH

THEN 'N'!!Organisation

END

I can construct the code in different ways - but i prefer to output the logic as a format so the original data not is changed and i do not need an extra column.

Any ideas??

Thanks in advance.

Re: user-defined format from a function

ballardw — Fri, 01 Sep 2017 14:32:48 GMT

Formats are associated with single variables, not multiple.

I think that you may want to provide a little more detail or variability in your "example" as you have n in 4 different places so it isn't exactly clear which 'n' goes where.

If you want to display 'GGGG' as a specific string that does not change then you could build a data set from your example values useing string concatenation functions so you have values like:

Start label

GGGG abc GGGG

YYYY pd YYYY

and build a format from that data set. There are some other bits. But a format only assings one label text to any given value.

You cannot have format assign abc GGGG one time and pd GGGG another time. That will require creating an actual additional variable with concatenation.

Re: user-defined format from a function

ANLYNG — Fri, 01 Sep 2017 14:56:30 GMT

The organisation coloums has huge amount af different content. so I need to put a constant string or combine with another coloumn dynamiccaly. I was thinlking about a function and create a format from that - but is not sure how to do it...

Re: user-defined format from a function

ballardw — Fri, 01 Sep 2017 15:25:31 GMT

A format will only associate with a single variable. And only assign one output value for a given input (barring use of multilabel formats in the very small number of procedures that recognize them). Even though you can use a user function in a format it may only use one variable.

In effect you are asking to do something like this:

Proc format library=work;
value $junk
'GGGG' = 'abc GGGG'
'GGGG' = 'pd GGGG'
;
run;

which will result in a repeated range error.

19   Proc format library=work;
20   value $junk
21   'GGGG' = 'abc GGGG'
22   'GGGG' = 'pd GGGG'
ERROR: This range is repeated, or values overlap: GGGG-GGGG.
23   ;
NOTE: The previous statement has been deleted.
24   run;