obs store product date buysell units price 1 1 100001 19/02/2013 b 1000 $1,000.29 2 1 100001 20/03/2013 s 1000 $2,500.20 3 1 100002 17/03/2014 b 1000 $2,000.20 4 1 100003 18/05/2014 b 2000 $3,000.20 5 2 100004 14/05/2013 b 1000 $3,000.29 6 2 100004 20/06/2013 s 1000 $3,500.20 7 2 100005 17/03/2014 b 1000 $2,000.20 8 2 100006 18/05/2014 b 2000 $3,000.20 9 2 100007 20/09/2013 s 1000 $3,500.20 how can I split this data set into different number of datasets according to the store and name that datasets as work_i where i is the number of store? This is my coding %macro prod(dsn); proc sql; select distinct max(store) into:x from &dsn; quit; %do i=1 %to &x; data mypro.work&i; set &dsn; %where store='i'; run; %end; %mend prod;
... View more