Date: Tue, 20 Aug 2002 22:42:41 -0400
Reply-To: Mike Fetchel <mike.fetchel@SNET.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mike Fetchel <mike.fetchel@SNET.NET>
Subject: Importing .csv files containing missing values
I'm importing a .csv (comma separated values) file using Proc Import in the
Unix environment using SAS Ver. 8.2. One of the columns (containing
numeric data) in the .csv file has missing values in some of the records
(but not all). When I submit my Proc Import program, the variable
representing this column has all missing values in, including the records
that had values in the .csv file. When I stripped out the records that had
missing values for that numeric column from the .csv file and then re-ran
the import program, it worked fine. Does any one know why this is happening
and how to fix this properly?
Thanks in advance for any help.