topic Re: how to derive extra record in SAS Programming

how to derive extra record

thanikondharish — Mon, 14 Jan 2019 06:56:52 GMT

Sex	Age
F	13
F	13
F	14
F	12
F	15
F	11
F	14
F	12
F	15
M	14
M	14
M	12
M	13
M	12
M	16
M	12
M	15
M	11
M	15

i have above dataset how derive extra record for maximum age like see below dataset

Sex	Age	status
F	11
F	12
F	12
F	13
F	13
F	14
F	14
F	15
F	15
F	15	maximum
M	11
M	12
M	12
M	12
M	13
M	14
M	14
M	15
M	15
M	16
M	16	maximum

Re: how to derive extra record

singhsahab — Mon, 14 Jan 2019 07:17:12 GMT

Hello,

data have;
input Sex $ Age;
datalines;
F 13
F 13
F 14
F 12
F 15
F 11
F 14
F 12
F 15
M 14
M 14
M 12
M 13
M 12
M 16
M 12
M 15
M 11
M 15
;
run;

proc sort ; by sex age;
run;

data want;
set have;
by sex age;
if last.sex then status='maximum';
run;

Thanks,

Re: how to derive extra record

thanikondharish — Mon, 14 Jan 2019 07:20:02 GMT

i wrote program like this but i want to write code use (do until) within
datastep block

Re: how to derive extra record

singhsahab — Mon, 14 Jan 2019 07:39:51 GMT

Hello,

If a simple salutation is available ,Why you want to make it complex by using loops . if you use explicit loop , it'll take so more time then implicit loop.

Meanwhile you can use Array to fulfill yr request .

Thanks...

Re: how to derive extra record

Kurt_Bremser — Mon, 14 Jan 2019 13:20:20 GMT

As soon as you mark one of my previous answers to your posts as a solution, I might be tempted to provide such code.

Re: how to derive extra record

PeterClemmensen — Mon, 14 Jan 2019 14:55:54 GMT

Why on Earth Do you want to arramge your data like this?

If there is a reporting purpose behind, then perhaps PROC REPORT is a better approach