Hi there,
I want to combine two formats :
Here is an example of what I want (but it does not work):
proc format;
value purchase_date_fmt . = "No purchase "
other = ddmmyy10. ;
run;
I performed a left join and want to display "No purchase" instead of the missing values and display the non missing values using ddmmyy10. format.
Is there a solution to do this ?
Thanks !
Hi,
You need to specify the ther format in square brackets [ddmmyy10.] - see the example in the SAS documentation here: https://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n147lut5kyth0yn1dr52...
Best
Steve M.
Hi,
You need to specify the ther format in square brackets [ddmmyy10.] - see the example in the SAS documentation here: https://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n147lut5kyth0yn1dr52...
Best
Steve M.
Thanks @SteveM_UK it works
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.