|
Data have;
infile cards dlm=' /';
input U_id t_id s_code d y sales returns;
if y=08 then do; /* If you have data for different years */
if d=01 then do; Sale_Jan08=sales; Retn_Jan08=returns; end; else
if d=02 then do; Sale_Feb08=sales; Retn_Feb08=returns;end; else
if d=03 then do; Sale_Mar08=sales; Retn_Mar08=returns; end;
end;
keep u_: t_: s_: sale_: retn:;
cards;
1 1 1 01/08 100 100
1 1 1 02/08 200 200
1 1 1 03/08 300 300
2 2 2 01/08 120 123
2 2 2 02/08 160 159
3 3 3 03/08 111 111
;
Data want;
update have(obs=0) have;
by u_id t_id s_code;
Run;
Thanks!
Akshaya
On Thu, Jan 8, 2009 at 12:52 PM, sasbeginner <pattukuttani@gmail.com> wrote:
> Hi All,
>
> Basically I need to transpose it. Any thoughts on this?. I have
> intellects of this group who has helped me with renaming hte
> variables. Now the basic data set itself is different. How to do
> this?? Please help someone like me who has 0 programming knowledge?
>
> I appreciate everyone's hard work and time. Thanks and hats off to you
> guys
>
> Thanks a lot.
>
> Input data:
>
> U_id t_id s_code date sales returns
> 1 1 1 01/08 100 100
> 1 1 1 02/08 200 200
> 1 1 1 03/08 300 300
> 2 2 2 01/08 120 123
> 2 2 2 02/08 160 159
> 3 3 3 03/08 111 111
>
>
> output
>
> U_ID t_id s_code sales_mar08 sales_feb08 sales_jan08
> returns_mar08
> returns_feb08 returns_jan08
> 1 1 1 300 200 100 300 200 100
> 2 2 2 --- 160 120 --- 159 123
> 3 3 3 111 --- --- 111 --- ---
>
| 
