Date: Mon, 19 Jun 2006 12:06:44 -0400
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: How to read a text file with comma as the demiliter?
The problem is resolved. I have just an incidental comment, below.
On Mon, 19 Jun 2006 09:16:15 -0400, Xu Libin <Libin.Xu@IRS.GOV> wrote:
> I am having some trouble trying to read a text file with comma
>as the delimiter. The syntax is as follows:
> Infile old dsd missover;
> Input caseN $7. Order $1. CIC $3.;
>It reads the data into SAS fine,
Obviously not true, given what is described below.
The DATA step presumably generated no ERROR messages in the log. That does
*not* mean that it read the data "fine". It's important to look at the log,
but it's also important to look at the output data set.
>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.