Displaying 1 result from an estimated 1 matches for "acct_num".
Did you mean:
acct_name
2010 Dec 20
1
transposing panel data
I am currently trying to transpose some large panel data set ie transposing multiple rows in into a single column. instead the transpose functionality transposes all rows into columns. my sample data set looks like below:
ACCT_NUM
ACCOUNT_NAME
TRAN_AMT
DATE
EMPLOYER
101913
GK
7489
30-Apr-10
PENSION
101913
GK
7489
30-May-10
PENSION
101913
GK
7489
30-Jun-10
PENSION
101913
GK
7489
31-Jul-10
PENSION
101913
GK
7489
31-Jan-10
PENSION
101913
GK...