"samplingunit"  and " cluster" are synonyms, see the documentation. ... View more

Or equivalently,   proc surveyselect data=have out=temp seed=123 sampsize=3 noprint; samplingunit dept_no; proc surveyselect data=temp out=want seed=123 sampsize=1 noprint; strata dept_no; Note: May be a bit faster if you have more distinct depts than emp by dept. Note: Sorting is implied in the first selection step. ... View more

Si j'ai bien compris le problème, il faudrait remplacer les jointures internes par des jointures externes.   select pop.pop_id, pop.date, ... , pop.geo_id, coalesce(jur.var1, geo.var1) as var1, coalesce(jur.var2, geo.var2) as var2, ... from pop left join jur on pop.pop_id=jur.id and pop.date=jur.date and ... left join geo on pop.geo_id=geo.id and pop.date=geo.date and ...; quit; ... View more

The Lines graph must represent the class levels ordered by Estimate values. Otherwise, how would it show, for example, in your graph, the link between levels N15 and N200 if they weren't adjacent? ... View more

Just for fun. If you really insist on using SQL :   data have; input ID $ users_2016 users_2017 users_2018 users_2019 users_2020; datalines; jjones 1 1 0 0 0 asmith 0 1 1 1 0 ; proc sql; create table want (year num, nbUsers num); insert into want select 2016, count (distinct ID) from have where users_2016; insert into want select 2017, count (distinct ID) from have where users_2017; insert into want select 2018, count (distinct ID) from have where users_2018; insert into want select 2019, count (distinct ID) from have where users_2019; insert into want select 2020, count (distinct ID) from have where users_2020; select * from want; quit; 😁   ... View more

Impressive reverse engineering @FreelanceReinh ! Kudos! ... View more

It has been replaced by proc hpsplit. ... View more

A decent technical description of the SQL join operations (including the effect of missing (null) values) is given here. ... View more

The variable _STATUS_ in the OUTEST= dataset tells you which estimates are final (properly converged) or not. ... View more

These network (graph) statistics are now available from PROC OPTGRAPH, for which you need the SAS Network Algorithms license.   From the procedure documentation, you only need a links (i.e. from-to pairs) dataset to get it going.   The centrality statistics are requested with the CENTRALITY statement. ... View more

This page references 7 different measures of node centrality.   Which centrality measure do you want to calculate? And do you want to do the calculation with SAS or simply provide a well formatted file to other software? ... View more