[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Nulls not allowed
From:       Gerhard Hellriegel <ghellrieg () T-ONLINE ! DE>
Date:       2003-01-31 16:47:49
[Download RAW message or body]

On Fri, 31 Jan 2003 10:38:30 -0500, J Breckel|
<Jim.Breckel@MAIL.STATE.KY.US> wrote:

>What is the best way to handle NULLS not allowed on a SAS/ACCESS Relational
>DB (DB2 on OS/390)?
>
>I have a SAS dataset with nulls in it and I want to Append/Update the data
>on the DB2 table, but the SAS dataset has null values.  Is there any way to
>say for this column (when null) use this specified value????
>
>Thanks!

In SAS that is easy:

...
  if var=. then var=99e9;  (or whatever you want to assign in that case).

[prev in list] [next in list] [prev in thread] [next in thread]