topic Re: Format procedure in SAS Procedures

Format procedure

MinalMurkhande — Thu, 06 Mar 2014 22:39:20 GMT

Hi ,

On running the format procedure I get and Error saying : " You are trying to use the numeric format SURVIVED with the character variable Survived in data set TITANIC.TRAIN."

Here is my code :

proc format;

value survived 1='Survived'

0='Died'

;

run;

ods graphics on;

proc freq data=titanic.train;

tables survived sex Pclass

survived*sex survived*pclass/

plots(only)=freqplot(scale=percent);

format survived survived.;

run;

When I change the "Survived" column to numeric datatype it works. How do I apply the format procedure to a character datatype column.?

Re: Format procedure

Reeza — Thu, 06 Mar 2014 23:01:15 GMT

Make a character format:

proc format;

value $ survived '1'='Survived'

'0'='Died'

;

run;

Re: Format procedure

MinalMurkhande — Thu, 06 Mar 2014 23:10:15 GMT

Hi Reeza,

Thank you for your reply.

I did try this option too but it still gives the same error .

Here is the excerpt from the log :

NOTE: Format $SURVIVED is already on the library WORK.FORMATS.

NOTE: Format $SURVIVED has been output.

29 run;

NOTE: PROCEDURE FORMAT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

30 ods graphics on;

31 proc freq data=titanic.train;

32 tables survived sex Pclass

33 survived*sex survived*pclass/

34 plots(only)=freqplot(scale=percent);

35 format survived survived.;

ERROR: You are trying to use the numeric format SURVIVED with the character variable Survived in data set TITANIC.TRAIN.

36 run;

NOTE: The SAS System stopped processing this step because of errors.

Re: Format procedure

Reeza — Thu, 06 Mar 2014 23:13:00 GMT

format survived $survived.;

Re: Format procedure

MinalMurkhande — Thu, 06 Mar 2014 23:16:20 GMT

Thank you.. ! Got it