Anybody have any idea why this code is NOT returning just one observation?
proc sql outobs = 1;
create view test1 as
select
orig.unit_pk,
orig.service_cat_desc,
orig.so_pk,
min(orig.sub_prod_pckg_pk) as pk
from
conx.subscriber_services as orig
where
orig.so_pk is not null and
orig.unit_pk = 54 and
orig.service_cat_desc = 'Video'
group by
orig.unit_pk,
orig.service_cat_desc,
orig.so_pk
;
quit;
I'm pretty sure I've got the outobs option set properly.
... View more
