☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-19-2022 10:56 AM
(859 views)
Hello,
In SAS EG, is there a way to use the statement count(distinct flob) over (partition by police) as N, like the example for test3 (see code below) and if so, how ?
data test;
input police $ flob $ Other_info $;
datalines;
1 A X1
1 B X1
1 C X1
1 D X1
1 E X1
2 A TR
2 C TR
;
RUN;
PROC SQL;
create table test1 as
select *,
count(distinct flob) as N
from test
group by police;
QUIT;
PROC SQL;
create table test2 as
select *,
count(distinct flob) over (partition by police) as N
from test;
QUIT;
Regards,
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
No.
But you don't need it in SAS.
Just use your first example with the normal GROUP BY and SAS will remerge the count onto the appropriate values of A.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
No.
But you don't need it in SAS.
Just use your first example with the normal GROUP BY and SAS will remerge the count onto the appropriate values of A.