Help using Base SAS procedures

Proc SQL and OUTOBS

Reply
Contributor
Posts: 50

Proc SQL and OUTOBS

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.
Contributor
Posts: 24

Re: Proc SQL and OUTOBS

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;
Ask a Question
Discussion stats
  • 1 reply
  • 3212 views
  • 0 likes
  • 2 in conversation