Date:         Mon, 5 Jan 2009 10:40:05 -0800
Reply-To:     Tiffany <tiffany.vidal@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tiffany <tiffany.vidal@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: importing lots of text from Excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jan 5, 12:52 pm, ajayo...@yahoo.com (ajay ohri) wrote:
> copy and paste..use dde if need to automate
>
> --- On Mon, 1/5/09, Tiffany <tiffany.vi...@GMAIL.COM> wrote:
>
> > From: Tiffany <tiffany.vi...@GMAIL.COM>
> > Subject: importing lots of text from Excel
> > To: SA...@LISTSERV.UGA.EDU
> > Date: Monday, January 5, 2009, 11:09 PM
> > Hi everyone,
>
> > I am trying to import an Excel file with two fields that
> > have
> > comments.  These can be null up to a paragraph or so.  I
> > have tried a
> > straight proc import as well as an infile statement
> > assigning these
> > fields a format of $200.  Neither seems to work.  I get
> > maybe the
> > first 10 characters in the field.  Does anyone have a
> > suggestion on
> > how to do this properly?
>
> > thank you for your help!!
>
> > Tiffany/

************************************************************************
Using DDE:
I tried the following statement.  The data were imported, but the
comment fields were still truncated.  The comments are in columns A, B
and C.

OPTIONS NOXSYNC NOXWAIT;
X '"C:/interviews/interview_24NOV08.csv"';
filename goods DDE 'Excel|W:/interviews/[interview_24NOV08.csv]
interview_24NOV08!R1C1:R28C6';
data inter;
INFILE goods NOTAB DLM='09'x DSD MISSOVER lrecl=50000;
   informat FIELD_NAME $20.;
   informat FIELDS $30.;
   informat EXAMPLE $20.;
   informat A $200.;
   informat B $200.;
   informat C $200.;

input FIELD_NAME $ FIELDS $ EXAMPLE $ A $ B $ C $;
        run;