topic Re: how to show two formats in SAS Programming

how to show two formats

thanikondharish — Wed, 24 Oct 2018 07:12:11 GMT

proc format ;
value $ gender 'F'='female' 'M'='male' ;
invalue sex 'F'=1 'M'=2 ;
run;

proc format fmtlib ;
select $gender sex;
run;

it i run above program it show only $ gender format.

how to show two formats at a time

Re: how to show two formats

Kurt_Bremser — Wed, 24 Oct 2018 07:19:30 GMT

Read the documentation for the select statement in proc format.

Re: how to show two formats

RW9 — Wed, 24 Oct 2018 07:51:43 GMT

Does not make any sense? A column has one format, one informat, one label, and one name. In the below you are creating a format, fine, that can be assigned to the variable, and an informat, which is not used? A correct select statement if you want one as format and one as informat would be:

select sex format=$gender. informat=sex.

I expect you will now be going through all your old posts and marking them as correct/responding to users posting there?

Re: how to show two formats

ballardw — Wed, 24 Oct 2018 14:35:34 GMT

From the documentation

entry(s)

specifies one or more catalog entries for processing. Catalog entry names are the same as the name of the informat or format that they store. Because informats and formats can have the same name, and because character and numeric informats or formats can have the same name, you must use certain prefixes when specifying informats and formats in the SELECT statement. Follow these rules when specifying entries in the SELECT statement:

Precede names of entries that contain character formats with a dollar sign ($).

Precede names of entries that contain character informats with an at sign and a dollar sign (for example, @$entry-name).

Precede names of entries that contain numeric informats with an at sign (@).

Specify names of entries that contain numeric formats without