Date: Fri, 25 Sep 1998 12:42:22 -0400
Reply-To: Victor Kamensky <kamensky@AECOM.YU.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Victor Kamensky <kamensky@AECOM.YU.EDU>
Subject: Re: Proc DBF
Content-Type: text/plain; charset="us-ascii"
IMHO it is impossible if you use PROC DBF.
But there is another solution-PROC DBLOAD.
It is part of SAS ACCESS to PC file formats,
and you are licenced to use it (otherwise you
cannot use PROC DBF which is also part of SAS ACCESS).
The first thing you have to is put the following option
in CONFIG.SAS file:
-SET DBFMISCH NULLS
/* BLANKS, NULLS or any single character.*/
By default it is 9(for PROC ACCESS and PROC DBLOAD).
This change does not affect PROC DBF-it is always 9-s.
TThe syntax is the following:
PROC DBLOAD DBMS=DBF data=YOUR DATA SET;
PATH="YOUR DBF FILE";
Unlike PROC DBF, PROC DBLOAD cannot work if DBF
file already exist under the same name.
To delete it you can use the following(before running PROC DBLOAD):
filename delfile "YOUR DBF FILE";
put rc= sysmsg=;
I use 6.12 for WIN95.
Hope it helps.
Albert Einstein College of Medicine
At 10:52 AM 9/25/98 -0500, you wrote:
>Hello, SAS users!
>I remember seeing this question here before.
>I'm producing a dBase file from a SAS dataset (proc dbf). Some of the
>numeric fields contain missing values, which get assigned a series of 9s
>for the dBase file. Does anyone know how I could assign the numeric
>fields containing missing values blanks instead of 9s?
>Thanks in advance.
>Missouri Dept. of Conservation