topic Proc format to be used in UPCASE in SAS Programming

Proc format to be used in UPCASE

sahoositaram555 — Wed, 18 Mar 2020 11:08:45 GMT

Hi everyone,

I have a stored format.

proc format library=RECEIVE.DSTERM_DSDECOD ;
value DSTERM 1='Adverse Event'
2='Protocol Nonompliance'
3='Lost to followup'
4='Investigator decision'
5='patient Withdrawn consent'
6='Death'
7='Ineligible'
8='Other';

run;

i would like to assign the character parts of this format to a new variable name DSDECOD but with UPPERCASE.

I was thinking bout using upcase(), but don't know how to assign the character values to the DSDECOD variable.

Is there any other efficient way out. Kindly help.

Re: Porc format to be used in UPCASE

Shmuel — Wed, 18 Mar 2020 06:21:16 GMT

Try DSDECOD = upcase(put(var, DSTERM.);

Re: Proc format to be used in UPCASE

ballardw — Wed, 18 Mar 2020 15:17:10 GMT

If you are going to do this frequently you might consider building another format and use the one you need depending on the specific situation:

proc format library=RECEIVE.DSTERM_DSDECOD ;
value DSTERMUP 1='ADVERSE EVENT'
2='PROTOCOL NONOMPLIANCE'
3='LOST TO FOLLOWUP'
4='INVESTIGATOR DECISION'
5='PATIENT WITHDRAWN CONSENT'
6='DEATH'
7='INELIGIBLE'
8='OTHER';

run;

Notice the name of the format ends in UP to differentiate the values.

Some of my variables I have multiple formats for different uses. Such as having acronym, short and long text versions.

BTW is "Nonompliance" supposed to be "Noncompliance"?