Date: Sun, 18 Jan 2009 18:21:32 -0800
Reply-To: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject: Re: Creating pivot table using SAS enterprise guide version
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
It's a big icky, but you can calculate percentiles with SQL: http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci910244,00.html
How do you calculate percentiles with PROC FREQ?
Videtis illam spirare libertatis auram
On Jan 18, 2009, at 5:22 pm, Murphy Choy wrote:
> Hi Jack,
> I guess the percentiles cannot be created in a single step in SQL. I
> be wrong here.
> -----Original Message-----
> From: Jack Hamilton [mailto:email@example.com]
> Sent: Monday, January 19, 2009 3:53 AM
> To: Murphy Choy
> Cc: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: [SAS-L] Creating pivot table using SAS enterprise guide
> What would be an example of a pivot table that can't be produced by
> SQL but can be produced by FREQ?
> I agree that there are pivots that can be produced by tabulate but not
> by freq, but I don't think they can be produced by Excel either.
> Jack Hamilton
> Videtis illam spirare libertatis auram
> On Jan 18, 2009, at 7:39 am, Murphy Choy wrote:
>> Hi Chandra,
>> Some types of pivot tables can be generated using SQL while others
>> proc tabulate and freq.
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>> Sent: Sunday, January 18, 2009 10:32 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Creating pivot table using SAS enterprise guide version
>> Hi all,
>> Can any one suggest a method do generate "Pivot tables" (as in MS-
>> Excel) in SAS Enterprise guide Version, if such features are
>> in SAS? Pls let me know
>> Thank you,