topic Re: How to move a SPACE to a numeric field in SAS Enterprise Guide

How to move a SPACE to a numeric field

carmendee — Tue, 20 Dec 2016 14:07:49 GMT

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

Re: How to move a SPACE to a numeric field

data_null__ — Tue, 20 Dec 2016 14:24:49 GMT

options missing=' ';

Re: How to move a SPACE to a numeric field

carmendee — Tue, 20 Dec 2016 14:40:39 GMT

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

Re: How to move a SPACE to a numeric field

ballardw — Tue, 20 Dec 2016 15:39:57 GMT

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.

Re: How to move a SPACE to a numeric field

carmendee — Wed, 04 Jan 2017 14:16:34 GMT

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

Re: How to move a SPACE to a numeric field

Tom — Wed, 04 Jan 2017 14:35:15 GMT

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.