Date:         Thu, 4 Mar 2010 11:22:24 -0800
Reply-To:     titan titan <titaan08@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         titan titan <titaan08@GMAIL.COM>
Subject:      Re: Format Help
Comments: To: SAS_learner <proccontents@gmail.com>
In-Reply-To:  <c2192a611003041115s4c5b567coff85003c366e4373@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Thank you very much. I got it. It is working now. Only problem now I am
facing is: I am getting-

Numeric values have been converted to character values at the places given
by: (Line):(Column).
Otherwise every thing is cool now. Thank you very much again.

On Thu, Mar 4, 2010 at 11:15 AM, SAS_learner <proccontents@gmail.com> wrote:

> Opps
>
> Do not change your Original Proc Means code, But the take the Output
> dataset in your case Mean1  and try to change there it will work I do not
> think you can use Input and Put statements inside any procedures with
> exception to Proc SQL
>
> On Thu, Mar 4, 2010 at 11:04 AM, titan titan <titaan08@gmail.com> wrote:
>
>> I am using this code but errors are coming. Please suggest me.
>> *
>>
>> proc* *means* data=change1 noprint;
>>
>> by trt visit;
>>
>> var chbl;
>>
>> output out=mean1 n=_n mean= put(mean,*6.2*) median=put(median,*6.2*) min
>> =put(min,*6.1*) max=put(max,*6.1*) std=put(std,*6.3*);
>> *
>>
>> run*;
>> *
>>
>> proc* *sort* data=mean1; by visit trt; *run*;
>> *
>>
>> proc* *transpose* data=mean1(drop=_TYPE_ _FREQ_) out=trans;
>>
>> by visit;
>>
>> id trt;
>> *
>>
>> run*;
>>
>>
>> On Thu, Mar 4, 2010 at 10:40 AM, Nathaniel Wooding <
>> nathaniel.wooding@dom.com> wrote:
>>
>> > Your problem is that a format applies to a variable so when you do the
>> > transpose, you are creating new variables with default formats. Sas
>> Learner
>> > just posted a solution using put statements which is what I was going to
>> > suggest. This will create character variables that will appear as the
>> > formats specified. You would then transpose the new character variables.
>> >
>> > Nat Wooding
>> >
>> > -----Original Message-----
>> > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>> > Titaan Titaan
>> > Sent: Thursday, March 04, 2010 1:21 PM
>> > To: SAS-L@LISTSERV.UGA.EDU
>> > Subject: Format Help
>> >
>> > Hello all,
>> > I created n, mean, std, min, max using proc means. Later I defined
>> formats
>> > for all of them(Ex: format mean median 6.2, std 6.3, min max 6.1). But
>> when
>> > I am transposing them(id- treatment), I am getting default
>> format(best12.).
>> > So again I am getting the old formats which i got from proc means. Is
>> there
>> > any way to get the desired formats even after transposing?
>> > 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.
>> >
>>
>
>