Date:         Mon, 14 Jul 2008 14:24:36 -0400
Reply-To:     Randy Herbison <RandyHerbison@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Randy Herbison <RandyHerbison@WESTAT.COM>
Subject:      Re: SAS/AF: Copy and Paste into Table Viewer from Excel
Comments: To: "data _null_," <datanull@GMAIL.COM>
In-Reply-To:  <7367b4e20807141107x2c017c61m5347e94aca054317@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

Did you try the code?

Neither the data step nor the SCL ignore or remove blanks lines.  If
present, they are processed like any other line and are available for
pasting into the table viewer.



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
data _null_,
Sent: Monday, July 14, 2008 2:08 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SAS/AF: Copy and Paste into Table Viewer from Excel


On 7/14/08, Randy Herbison <RandyHerbison@westat.com> wrote:
> It depends on how you read the data.  This data step handles
> completely blank lines, but doesn't need MISSOVER:

I figured someone would say that.  I don't see why anyone would not use
MISSOVER unless you want to remove the completely blank lines. Now, that
does seem reasonable to me.

Here is another way using LENGTH= infile option that seems simpler to
me.

data excel;
   infile ft44f001 dlm='09'x dsd length=l;
   array c[*] &range;
   input @;
   if l=0 then return;
   input @1 c[*];
   list;
   run;