046-2007: Turning the Data Around: PROC …

1 Paper 046-2007 Turning the data around: PROC transpose and alternative approachesErik W. Tilanus, independent consultant, Driebergen, the NetherlandsABSTRACTPROC transpose can be used to "rotate" ( transpose ) SAS data sets. the values of one given variablebecome variable names and variables in the input data set become observations in the answers to three simple questions suffice to define the specification statements of PROC paper poses these questions and demonstrates how PROC transpose can be handled using reporting it is common to have a time dimension in the horizontal direction, like the figures you see in Table 1. Foranalysis with SAS it is often more appropriate to have these figures "rotated", a variable YEAR and variables forthe various equipment types, like in Table is exactly what PROC transpose can do for this paper we will discuss the basics of PROC transpose and demonstrate a number of special techniques withit. We also look at alternatives , using a DATA group200020012002200320042005CD players230432454322865219822063719494MP3 players83451046812270138461502917404 Cassette players125931147010343931782046971 DVD players153901748919153204582172523094 DVD recorders304633823574376045015036 VHS recorders1459013695135831145998517466 Table 1: Units sold figures of some electronics storeYEARCD playersMP3 playersCassetteplayersDVD playersDVDrecordersVHSrecorders200023043 8345125931539030461459020012454310468114 701748933821369520022286512270

1 Paper 046-2007 Turning the data around: PROC TRANSPOSE and alternative approaches Erik W. Tilanus, independent consultant, Driebergen, the Netherlands

Loading..

Tags:

  Corps, Transpose, Alternatives, Approaches, Proc transpose and alternative approaches

Information

Related search queries