topic Re: Can any one help me below issue either macro or datastep should be fine in SAS Programming

Can any one help me below issue either macro or datastep should be fine

Bhargavi221 — Sat, 14 Apr 2018 06:27:26 GMT

Table ATable BTable c

I have Table A and Table B , I want desired output should be like Table C

Either Macro or datastep should be fine

thanks in advance

Re: Can any one help me below issue either macro or datastep should be fine

ErikLund_Jensen — Sat, 14 Apr 2018 08:34:38 GMT

It can be solved, but I have a couple of questions.

I do not understand why the COUNT field in data set C is changes from 3 to 2 in the first two rows with ID 650.
As there is no Unique ID, we must presume that the data sets A and B are in the same order. Otherwise is is not possible to pair dates and quantities within the same ID group, eg. the quantity 50 to the date 31may2018.
Do you really want the numbered quantity/date pairs in C to respect the input data order, so 20mar2018 goes in pair 3, after the dates in May?

Re: Can any one help me below issue either macro or datastep should be fine

Bhargavi221 — Sat, 14 Apr 2018 09:06:20 GMT

1.actuvally the count is 3 only by mistake it's edited to 2

2.please consider dataset a and b are same order

3.yes i want the numbered quantity/date pairs go to the respective to input dataset order

Re: Can any one help me below issue either macro or datastep should be fine

Ksharp — Sat, 14 Apr 2018 11:59:00 GMT

Post the sas code, NOT picture, nobody would like to type it for you if want help from others.

data a;
input id count dty;
cards;
1022 2 200
1022 2 600
6500  3  3
6500  3 50
6500  3 12
;
data b;
input id dt : date9.;
format dt date9.;
cards;
1022 25apr2018
1022 11jul2018
6500  08may2018
6500  31may2018
6500  20mar2018
;
data have;
 merge a b;
 by id;
run;
proc sql noprint;
select max(count) into : n
 from (select count(*) as count from have group by id);
quit;
data want;
 set have;
 by id;
 array dty_{&n};
 array dt_{&n};
 if first.id then n=0;
 n+1;dty_{n}=dty;dt_{n}=dt;
drop dt n;
format dt_: date9.;
run;