Date:         Tue, 27 Jan 2009 11:44:27 -0500
Reply-To:     Paul St Louis <pstloui@DOT.STATE.TX.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul St Louis <pstloui@DOT.STATE.TX.US>
Subject:      Re: Proc Transpose

Thank you Nat and Mary. Both are excellent solutions. Elegant, in fact.
Meanwhile, we are also able to connect to the Oracle database through
Excel's Microsoft query and our resident Excel expert offered another
solution (keep in mind that SQL is utilized, but the coding looks different
because it is ported through Microsoft). His solution:

SELECT CONT_ID ,MAX(DECODE(PRSNL_T,'SKILLED',CNT)) as SKILLED,MAX(DECODE
(PRSNL_T,'UNSKILLED',CNT)) as UNSKILLED,MAX(DECODE
(PRSNL_T,'SUPERVISOR',CNT)) as SUPERVISOR,MAX(DECODE(PRSNL_T,'SURVEY -
CHIEF',CNT)) as SURVEY_CHIEF,MAX(DECODE(PRSNL_T,'SURVEY SKILLED',CNT)) as
SURVEY_SKILLED,MAX(DECODE(PRSNL_T,'SURVEY UNSKILLED',CNT)) as
SURVEY_UNSKILLED  FROM  (select CONT_ID,PRSNL_T,SUM(NBR_PRSN)CNT from
SMGR.T_DWR_CONTR_VARLBR WHERE DWR_DT = 20080717 GROUP BY CONT_ID,PRSNL_T)
GROUP BY CONT_ID  ORDER BY 1

I have so very much learn to catch up with y'all. Maybe another decade
would do it.