topic How to select a number of variables by variable in SAS Programming

How to select a number of variables by variable

letmmattos — Wed, 05 Apr 2017 17:20:03 GMT

hi guys,

I have a base on SAS with about 200.000 rows, and there is 10 different agents os that base

I need to select 200 rows by agent, with priorities, like:

priority ID agent

1 005431 A

2 020541 B

3 136751 C

2 057366 A

1 012658 C

3 057317 B

1 012856 B

The way i need to select them is:

first, put everything with priority 1 for agent A

if its not complete with 200 rows, put priority 2

and so on

anyone knows how can I do it?

Reeza — Wed, 05 Apr 2017 17:51:45 GMT

1. Sort by Agent, Priority

2. Count records for each by group and take the top 200 per agent

proc sort data=have;

by agent priority;

run;

data want;

set have;

by agent;

if first.agent then count=1;

else count+1;

if count <=200;

run;

lakshmi_74 — Wed, 05 Apr 2017 20:37:37 GMT

proc sql outobs=3;
create table want as
select * from have group by agent, priority;
quit;
proc print data=have;run;

lakshmi_74 — Wed, 05 Apr 2017 20:38:16 GMT

use outobs=200;

Reeza — Wed, 05 Apr 2017 21:21:40 GMT

@lakshmi_74 wrote:
proc sql outobs=3;
create table want as
select * from have group by agent, priority;
quit;
proc print data=have;run;

This would generate 200 total observations, not 200 per agent?