Help using Base SAS procedures

Proc SQL and OUTOBS

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Proc SQL and OUTOBS

[ Edited ]

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.


Accepted Solutions
Solution
‎01-12-2018 08:51 AM
Contributor
Posts: 24

Re: Proc SQL and OUTOBS

[ Edited ]
Posted in reply to StephenOverton

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;

View solution in original post


All Replies
Solution
‎01-12-2018 08:51 AM
Contributor
Posts: 24

Re: Proc SQL and OUTOBS

[ Edited ]
Posted in reply to StephenOverton

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;
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 11430 views
  • 0 likes
  • 2 in conversation