topic Re: preparing longditual data in SAS Procedures

preparing longditual data

omerzeybek — Thu, 25 Jul 2013 15:35:47 GMT

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...

Re: preparing longditual data

AncaTilea — Thu, 25 Jul 2013 16:08:12 GMT

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.