Date:         Fri, 6 Jul 2007 17:32:27 -0400
Reply-To:     SUBSCRIBE SAS-L Anonymous <randistan69@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Anonymous <randistan69@HOTMAIL.COM>
Subject:      Re: Importing CSV file format into Sas
Comments: To: Nat Wooding <Nathaniel.Wooding@DOM.COM>

Here is what I am using

PROC IMPORT OUT= WORK.Test
            DATAFILE= "C:\Documents and
Settings\Desktop\In_01062006_01.csv"
            DBMS=CSV REPLACE;
     GETNAMES=YES;
     DATAROW=2;
     GUESSINGROWS=20;
RUN;

This file contains entries for A and B.  If the structure is the following:
A,200606016672059,1,ABC,IQ,S,97671,97671,1,
which is followed by
B,01-JUN-2006,97073,97671,IQ,ABC,189.85,150,01-JUN-2006 09:55:26,
When these A and B appear in succession SAS Notes for the line beginning
with "B"
NOTE: Invalid data for for _00606010004548 and
Invalid data for Var 9 which is 01-JUN-2006 09:55:26

Will it be necessary to separate the lines beginning with A and B and
import them separately?  If so how do I do it?
Or is there a way to import both A and B into SAS in one file?  How can I
do this?
    Thanks.