Date: Wed, 16 Apr 2008 18:49:33 -0400
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: VERY EASY EXCEL question
As I mentioned, the code should work unless the original field was text.
I lied, but not on purpose. You wanted '123', and the statement I
suggested would actually produce '123,'
Obviously easy to fix but, if your initial field is actually character,
try the following:
PROC IMPORT OUT= WORK.have
PROC EXPORT DATA= WORK.want
The left side quote won't appear, but should be there.
On Wed, 16 Apr 2008 16:21:08 -0500, Tom White <tw2@MAIL.COM> wrote:
>Thank you for this code.
>However, it dosn't seem to do what I need.
>The output for column B looks like
>when it should look like, say,
>or like, say, '123',
>which was my original question.
>----- Original Message -----
>From: "Arthur Tabachneck"
>To: SAS-L@LISTSERV.UGA.EDU, "Tom White"
>Subject: Re: VERY EASY EXCEL question
>Date: Wed, 16 Apr 2008 16:54:09 -0400
>Since you posted this on SAS-L, here is a SAS-based solution:
>PROC IMPORT OUT= WORK.have
>PROC EXPORT DATA= WORK.want
>On Wed, 16 Apr 2008 14:41:37 -0500, Tom White wrote:
>> I have an Excell sheet with one numeric column like:
>> I would like to populate the next field over with
>> If you can do the above, can you also do:
>> I try to do:
>> =" 'A2' "
>> but doesn't work.
>> Want an e-mail address like mine?
>> Get a free e-mail account today at www.mail.com!
>Want an e-mail address like mine?
>Get a free e-mail account today at www.mail.com!