topic Re: How to make one record out of 2 in SAS Programming

How to make one record out of 2

asabou01 — Fri, 10 Jul 2020 13:31:26 GMT

I have 2 records for one member :

data test;
infile datalines;
input flag $ mem_num $ model $;
datalines;
In_Mbr 2001000000000000 HMO
In_clms 2001000000000000 HMO
;

Can I get some help make it to one record :

/*
In_both 2001000000000000 HMO
*/

Re: How to make one record out of 2

Jagadishkatam — Fri, 10 Jul 2020 13:40:10 GMT

You can try the below code

data test;
infile datalines;
input flag $ mem_num $ model $;
datalines;
In_Mbr       2001000000000000      HMO
In_clms      2001000000000000      HMO
;

proc sql;
create table want as select count(*) as cnt, mem_num, model, 'In_both' as flag from test group by mem_num, model;
quit;

Re: How to make one record out of 2

PeterClemmensen — Fri, 10 Jul 2020 14:01:25 GMT

I don't see the logic here?

Re: How to make one record out of 2

ballardw — Fri, 10 Jul 2020 15:23:21 GMT

@asabou01 wrote:

I have 2 records for one member :

data test;
infile datalines;
input flag $ mem_num $ model $;
datalines;
In_Mbr 2001000000000000 HMO
In_clms 2001000000000000 HMO
;

Can I get some help make it to one record :

/*
In_both 2001000000000000 HMO
*/

You would have to supply every single possible value of Flag variable and then what you want to show for each possible combination of them.

Are there any other variables in the data set? If so which values are kept?

And what can you do with this data that could not be done with the original?

Re: How to make one record out of 2

asabou01 — Fri, 10 Jul 2020 18:13:39 GMT

Thank you everyone. I am all set. There were only 3 values for flag.

Thanks again.