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.?
format survived $survived.;
Make a character format:
proc format;
value $ survived '1'='Survived'
'0'='Died'
;
run;
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.
format survived $survived.;
Thank you.. ! Got it
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.