Date:         Mon, 19 Jun 2006 08:33:19 -0700
Reply-To:     steve.silver@SUNTRUST.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steve Silver <steve.silver@SUNTRUST.COM>
Organization: http://groups.google.com
Subject:      Re: How to read a text file with comma as the demiliter?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Try this.

Data new;
infile old dsd delimiter=',' truncover;
/*COMMA DELIMITER*/
   input caseN :$char7.
           order :$char1.
           cic :$char3.
  ;
run;

Good luck,

Steve



Xu Libin wrote:
> Dear Listers,
>
>         I am having some trouble trying to read a text file with comma
> as the delimiter. The syntax is as follows:
>
> Data new;
>   Infile old dsd missover;
>   Input caseN $7. Order $1. CIC $3.;
> Run;
>
> It reads the data into SAS fine, but when I proc freq the variable
> Order, I found the comma is treated as the variable value. Can you tell
> me why that happens? Thanks for your expertise.
>
> Libin