Date:         Mon, 14 Jul 2008 13:34:57 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: SAS/AF: Copy and Paste into Table Viewer from Excel
Comments: To: Randy Herbison <RandyHerbison@westat.com>
In-Reply-To:  <668936B243AC5F4DB61EAE1878E9302708D40B5A@mailbe1.westat.com>
Content-Type: text/plain; charset=ISO-8859-1

I ran this...

data  __pb(keep=row value);
length value $ 200 row 8 lastline 8;
retain lastline;
infile ft44f001 dsd dlm="09"x lrecl=32767 line=line;
input value @@;
     if line > lastline then row + 1;
     lastline=line;
run;

So how is that better or different from using MISSOVER.

On 7/14/08, Randy Herbison <RandyHerbison@westat.com> wrote:
> 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;
>
>