topic Re: Combining two formats in SAS Procedures

Combining two formats

majdi_ka — Wed, 25 Nov 2015 16:44:15 GMT

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 !

SteveM_UK — Wed, 25 Nov 2015 16:57:21 GMT

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#n147lut5kyth0yn1dr524kwyx27b.htm

Best

Steve M.

majdi_ka — Wed, 25 Nov 2015 17:03:26 GMT

Thanks @SteveM_UK it works