topic Re: proc format with cntlin in SAS Programming

proc format with cntlin

NedKaufman — Fri, 29 Sep 2017 18:43:17 GMT

Is it possible to create a format mapping multiple inputs to one label

e.g. value odds 1,3,5 = 'ODD'

using an input dataset and CNTLIN ?

Re: proc format with cntlin

Astounding — Fri, 29 Sep 2017 18:46:29 GMT

Yes, but you need a separate observation for each value being mapped ... along the lines of:

label='ODD';

do start=1, 3, 5; output; end;

Re: proc format with cntlin

Kurt_Bremser — Fri, 29 Sep 2017 18:52:06 GMT

data cntlin;
type = 'N';
fmtname = 'myfmt';
length label $8;
label = 'Odd';
do i = 1 to 5 by 2;
  start = put(i,8.);
  output;
end;
start = 'other';
label = 'Even';
output;
run;

Try this.

Re: proc format with cntlin

NedKaufman — Fri, 29 Sep 2017 18:53:34 GMT

Thank you!