Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NODATA

Status
Not open for further replies.

H1004

MIS
Joined
Oct 28, 2003
Messages
136
Location
US
I have a question. If I want to put n/a for no data on a define numeric field.
How can I do that??
I try to do IF field1 EQ 9 THEN AMOUNT ELSE N/A.
But I can't do that coz it is numeric and n/a is string.
And I don't think I can use set nodata = n/a coz it is within a define field.
 
SET NODATA = 'N/A'
DEFINE FILE MYFILE
NEW_FIELD/I9 MISSING ON = IF FIELD_1 EQ 9 THEN AMOUNT ELSE MISSING;
END
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top