how remove particular UNSCHEDULED subject

teja5959 — Thu, 09 Jan 2020 16:18:11 GMT

don't want UNSCHEDULED but some time sufficient res is available in UNSCHEDULED have been assigned.eg .. look at on want data set

i have data in this type

data have;
length id no res visit $200;
infile datalines dsd truncover;
input id no res visit $;
datalines;
003,1,sufficient,visit1
003,1.1,5.6,UNSCHEDULED 1.1
003,2,5.5,visit2
003,3,5.8,visit2
004,1,6.0,visit1
004,1.1,6.5,visit1
004,2,7.0,visit2
004,3,7.2,visit3
004,1,interact,visit1
004,1.1,9.3,UNSCHEDULED 1.1
004,2,8.4,visit2
004,3,7.2,visit3
005,0.1,6.9,UNSCHEDULED 0.1
005,0.1,7.4,UNSCHEDULED 0.1
005,0.1,5.9,UNSCHEDULED 0.1
;
run;

i want as data this type

data want;
length id no res visit $200;
infile datalines dsd truncover;
input id no res visit $;
datalines;
003,1.1,5.6,UNSCHEDULED 1.1
003,2,5.5,visit2
003,3,5.8,visit2
004,1,interact,visit1
004,2,7.0,visit2
004,3,7.2,visit3
;
run;

Re: how remove particular UNSCHEDULED subject

ed_sas_member — Thu, 09 Jan 2020 20:45:23 GMT

Hi @teja5959

Could you please explain the rules that should apply?

Thank you very much.

Best,

topic Re: how remove particular UNSCHEDULED subject in SAS Programming

how remove particular UNSCHEDULED subject

Re: how remove particular UNSCHEDULED subject