topic Re: CNTLIN FORMATS in SAS Procedures

CNTLIN FORMATS

robertrao — Tue, 10 Jun 2014 20:18:43 GMT

Hi ,

I am using CNTLIN formats

I have a couple of questions regarding.

can you explain why the provider=label???

if I have several other variables X, Y, Z in the KEEP which variable of those will get the "=label"????? is there a preference ?

secondly what does that =label do????

Thanks

data test1(rename=(providerkey=start provider=label));

set dim_provider(keep=providerkey provider /*X Y Z*/);

fmtname='attprovkey';

run;

proc format cntlin=test1;run;

data both;

set hsp_acct_2;

attending_provider=put(providerattendingkey, attprovkey.);

run;

Re: CNTLIN FORMATS

ballardw — Tue, 10 Jun 2014 20:28:21 GMT

PROC Format requires a variable named LABEL to describe the display associated with the values in the Start and End. Variables that are not expected by Proc Format are ignored.

A better way to understand what is required may be to make a short custom format and use the CNTLOUT option to create a data set that describes the format. Then you will see a bit more clearly what the variables associated with a CNTLIN data set do.

Re: CNTLIN FORMATS

robertrao — Tue, 10 Jun 2014 21:26:53 GMT

Hi,

I was thinking I could use label on any of the variables on the Keep statement!!!!

Please correct?

Thanks

Re: CNTLIN FORMATS

ballardw — Tue, 10 Jun 2014 23:20:39 GMT

I'm not sure what you are attempting in the long run.

There may be a case of mistaken identity. For CNTLIN data sets Label is an expected Variable. In many other places Label is the Text associated with a variable name. Yes any variable can have a label associeated. But the Variable named Label, which is a character variable, is what holds the text associeated with the values.

Did you create the CNTLout data set and look at it?

Re: CNTLIN FORMATS

SASKiwi — Wed, 11 Jun 2014 02:06:18 GMT

Looking at an example in the SAS documentation should help. Also try running the example program and examining the CNTLIN dataset.

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1e19y6lrektafn1kj6nbvhus59w.htm