preparing longditual data

[omerzeybek]

Hİ i have a problem with the data i am dealing with

i have counts of active products for different stores which are identifiedwith storeID and unfortunately my database updates quarterly figures cross sectionally

Store ID	Date	ACTIVE Products
4501582	2Q12	5
4501582	1Q12	6
3262611	1Q11	7
3262611	2Q10	2
2165156	2Q12	8

However i just need to report them as

Store ID	2Q12_ACTIVE Products	1Q12_Active Products	1Q11_Active Products	2Q10 Active Products
4501582	5
3262611		6	7	2
2165156	8

could please offer me a quick way to do it...

[AncaTilea]

Hi.

How about this?

data have;

input

  Store_ID Date $ ACTIVE_Products;

  cards;

4501582 2Q12 5

4501582 1Q12 6

3262611 1Q11 7

3262611 2Q10 2

2165156 2Q12 8

;

proc sort data = have;by store_id;

proc transpose data = have out = want(drop = _NAME_) suffix = Active_Products;

  id date;

  var active_products;

  by store_id;

run;

Good luck,

Anca.