topic Re: Max and Min for longitudinal data in SAS Programming

Max and Min for longitudinal data

desireatem — Thu, 30 Jan 2020 16:51:12 GMT

Hello-;

Please can you the code to create a data of max min from longitudinal data. The data is below:

Id PR

1 2

1 3

1 4

1 2

1 1

2 2

2 3

2 5

Create a Data with max PR

Id PR

1 4

2 5

Data with min PR

Id PR

1 1

2 2

Re: Max and Min for longitudinal data

ed_sas_member — Thu, 30 Jan 2020 16:54:58 GMT

Hi @desireatem

You can use PROC SQL:

data have;
	input Id PR;
	datalines;
1 2
1 3
1 4
1 2
1 1
2 2
2 3
2 3
2 5
;
run;

proc sql;
	create table have_max as
	select Id, max(PR) as PR
	from have
	group by Id;
run;


proc sql;
	create table have_min as
	select Id, min(PR) as PR
	from have
	group by Id;
run;

Re: Max and Min for longitudinal data

novinosrin — Thu, 30 Jan 2020 17:02:33 GMT

You could combine into one and have a group label if you like


data have;
input Id   PR;
cards;
1    2
1    3
1     4
1     2
1     1
2     2
2      3
2     3
2      5
;


proc sql;
create table combined as
select id,'max' as Max,max(pr) as Max_PR
from have
group by id
union all
select id,'min' as Min, min(pr) as Min_pr
from have
group by id;
quit;

One way to turn @PaigeMiller red is splitting datasets when not needed 🙂

Re: Max and Min for longitudinal data

novinosrin — Thu, 30 Jan 2020 17:06:26 GMT

You could rather use PROC SUMMARY


proc summary data=have nway;
class id;
var pr;
output out=want min= max=/autoname;
run;