Hi I am having trouble selecting blank values as a space. We have a requirement where we need to provide a file to the business. Blank values must = ' ' (a space). I am attempting to use the below case statement (which works on MS sql and oracle - I am new to SAS). case when INTERRUPTION_TYPE = '' then ' ' else INTERRUPTION_TYPE end as INTERRUPTION_TYPE The results return the blank values as a blank - no space. When I use the below, it will return an x so I know that my query is picking up the correct values but not returning a space when i want it to. case when INTERRUPTION_TYPE = '' then 'x' else INTERRUPTION_TYPE end as INTERRUPTION_TYPE Please help! Thanks in advance!
... View more