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
Content-Type: text/plain; charset=ISO-8859-1
I ran this...
data __pb(keep=row value);
length value $ 200 row 8 lastline 8;
infile ft44f001 dsd dlm="09"x lrecl=32767 line=line;
input value @@;
if line > lastline then row + 1;
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
> data excel;
> infile ft44f001 dlm='09'x dsd length=l;
> array c[*] ⦥
> input @;
> if l=0 then return;
> input @1 c[*];