Date: Fri, 17 Mar 2006 08:10:26 -0500
Reply-To: Nathaniel_Wooding@DOM.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nat Wooding <Nathaniel_Wooding@DOM.COM>
Subject: Re: Modifying the entries of a column
In-Reply-To: <2533F91DF0FC3F48AE4919B3197765ED05D3912B@GUR-PR-EXA1.Ranbaxy.com>
Content-Type: text/plain; charset="US-ASCII"
Madan
I've only had one cup of coffee so far this morning and I am having a hard
time understanding your sample data. Combining what you gave we have
Original Wanted
75C 25
130F 130
83 33
121F 121
The data can be easlily read with the letters stripped off but what
conversion do you need for the first and third values? 75c is 167F and 83c
is 181F. Since the second and fourth entries retain the numeric value, I
assume that you want you final values to be in degrees F.
What we need to know is what system do you need the final data to be in
and, also, what criterion do we use for cases like the third which has no
modifying letter?
Nat Wooding
Madan Gopal Kundu
<Madan.Kundu@RANB
AXY.COM> To
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
Discussion" cc
<SAS-L@LISTSERV.U
GA.EDU> Subject
Modifying the entries of a column
03/17/2006 05:30
AM
Please respond to
Madan Gopal Kundu
<Madan.Kundu@RANB
AXY.COM>
Hi,
I have a table in Excel sheet. That table has a column named as "temp"
which contains the temperatures in Farenhyte. The entries of the values
in the column "temp" are as follows:
Temp
--------------
75C
130F
83
121F
.
:
:
So on..
No doubt the entries in this column is not easily understandable and
also not in the appropriate form for the analysis.
Now I want to have this table in SAS with a modification in the column
"temp". The entries should be like that
Temp
--------------
25
130
33
121
.
:
:
So on..
Is it possible? Then please send me the code.
Thanks in advance.
Madan Gopal Kundu
Biostatistician,
Ranbaxy R&D
(i) The information contained in this e-mail message is intended only for
the confidential use of the recipient(s) named above. This message is
privileged and confidential. If the reader of this message is not the
intended recipient or an agent responsible for delivering it to the
intended recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, distribution, or
copying of this message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and delete
the original message.
(ii) The sender confirms that Ranbaxy shall not be responsible if this
email message is used for any indecent, unsolicited or illegal purposes,
which are in violation of any existing laws and the same shall solely be
the responsibility of the sender and that Ranbaxy shall at all times be
indemnified of any civil and/ or criminal liabilities or consequences
there.
-----------------------------------------
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.
