Date:         Tue, 30 Jan 2007 19:30:31 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: numbers "that look like" characters in Excel to SAS
Comments: To: bobmcconn@YAHOO.COM
In-Reply-To:  <978746.56503.qm@web57215.mail.re3.yahoo.com>
Content-Type: text/plain; format=flowed

Bob ,

If it was me I would simply have Excel shoot the data out into a tabed or
comma delimited file then send that on to your guys to read into SAS.  And
if it was me I would build a program that would do it for me in something
like C# or Perl.



Toby Dunn

To sensible men, every day is a day of reckoning. ~John W. Gardner

The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois

Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter






From: bob mcconnaughey <bobmcconn@YAHOO.COM>
Reply-To: bob mcconnaughey <bobmcconn@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: numbers "that look like" characters in Excel to SAS
Date: Tue, 30 Jan 2007 11:28:06 -0800

right..works great if you don't mind that reading in
data now takes about 3-4 times as long as it did when
data was simply double keyed entered raw data files.
Not to mention the innumerable ways in which project
managers, lab techs, and PIs can totally hose a
"dataset" that's in excel and have NO idea of what
they've done.

I suspect the quantity of data has increased
exponentially and the quality decreased by an equal
amount via excel.
--- Alan Churchill <SASL001@SAVIAN.NET> wrote:

 > Excel works fine. It is the interface between Excel
 > and everything else that
 > causes a problem.
 >


Bob McConnaughey
Westat/NIEHS | Pittsboro, NC

"There is a great homeland of intelligence and love from which no one can be
expelled"
Carlos Fuentes



____________________________________________________________________________________
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
http://tools.search.yahoo.com/toolbar/features/mail/

_________________________________________________________________
Invite your Hotmail contacts to join your friends list with Windows Live
Spaces
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us