Date:         Tue, 11 May 2010 11:58:54 -0500
Reply-To:     "Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: Import when only first comma is delimiter
Comments: To: Sterling Paramore <gnilrets@gmail.com>
In-Reply-To:  <AANLkTin3WsNS1cnQvITen9UIq1pglUXh5SvBPZXjbGey@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

I think you can fix it with INFILE statement option TRUNCOVER

On 5/11/10, Sterling Paramore <gnilrets@gmail.com> wrote:
> Dear SAS-L,
>
> I'm trying to import a file where only the first column in a row is a
> delimiter, but can't quite seem to get the import working correctly.  Here's
> an example of some rows that are causing problems:
>
> 314,Other circulatory system diagnoses w MCC
> 315,Other circulatory system diagnoses w CC
> 316,Other circulatory system diagnoses w/o CC/MCC
> 326,Stomach, esophageal & duodenal proc w MCC
> 327,Stomach, esophageal & duodenal proc w CC
> 328,Stomach, esophageal & duodenal proc w/o CC/MCC
>
> I tried:
>
> data MSDRG3_v26;
>    infile "/sas/DataStore/SAS_ETL/Supplemental_Xwalks/RawFiles/msdrg3.v26"
> lrecl=2000;
>
>    input START $ 1-3
>        @5 LABEL $80.;
>    ;
> run;
>
> but since there's a carriage return after each line, I get output that looks
> like this:
>
> 314    315,Other circulatory system diagnoses w CC
> 316    326,Stomach, esophageal & duodenal proc w MCC
> 327    328,Stomach, esophageal & duodenal proc w/o CC/MCC
>
>
> Any ideas?
>
> Thanks,
> Sterling
>