Help using Base SAS procedures

Combining two formats

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

Combining two formats

[ Edited ]

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 !

 

 

 


Accepted Solutions
Solution
‎11-25-2015 12:00 PM
Occasional Contributor
Posts: 11

Re: Combining two formats

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.

 

 

View solution in original post


All Replies
Solution
‎11-25-2015 12:00 PM
Occasional Contributor
Posts: 11

Re: Combining two formats

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.

 

 

Contributor
Posts: 41

Re: Combining two formats

Posted in reply to SteveM_UK

Thanks @SteveM_UK it works Man Very Happy

 

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 304 views
  • 1 like
  • 2 in conversation