How to move a SPACE to a numeric field

[carmendee]

I have data with an '.' in a numeric field.  I want to move a space to this field. I would like to do this in Enterprise Guide. I have tried variations of this syntax:

case when t1.AF > 0 then PUT(t1.AF) =  ''
end

Input

AF	AM	BF
.	.	9
.	.	.
.	.	2

 Output

AF	AM	BF
		9
		2

[data_null__]

options missing=' ';

[carmendee]

How does this syntax work in Enterprise Guide in build and advanced expression if my field name is AF?

[ballardw]

NO "expression" needed. The period is indicating that the value is missing. The option sets the display to show missing with a different character, a blank. The "condition" to create a character variable with a blank in a CASE statement would be

It looks like you may be missing an ELSE portion of your CASE statement: Else " " as BF. But you didn't show the entire case statement as the result variable isn't indicated.

[carmendee]

My field is numeric so my else cannot be "" for a blank.  I do not want a zero.  Ideas?

[Tom · Accepted solution]

Just change the system option to print a space instead of a period for missing numeric values.

options missing=' ';

If you do want to recode your variable to character then your CASE statement would look like this:

case
  when not missing(t1.AF) then PUT(t1.AF,best12.)
  else ' '
end

You could pick a different format to use in the PUT() function depending on how you want the values displayed.