Proc SQL and OUTOBS

StephenOverton — Fri, 12 Jan 2018 13:51:12 GMT

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.

Re: Proc SQL and OUTOBS

SUN59338 — Fri, 12 Jan 2018 13:50:32 GMT

if you change the 'view' to 'table', it will contains only 1 OBS.
So let's assume, the data in a view will be generated only when/during you open it. it stored the query for how it will be created, but will not keep the option for 'outobs=1', which is a Proc SQL option, but 'create view' statement.

you may also try this way:

proc sql ;
 create view test1 as
   select * from datasetname (obs=1);
quit;

topic Re: Proc SQL and OUTOBS in SAS Procedures

Proc SQL and OUTOBS

Re: Proc SQL and OUTOBS