topic Re: Show only repeating observations with a proc freq in SAS Programming

Show only repeating observations with a proc freq

camryndastrup — Tue, 07 Dec 2021 02:52:10 GMT

title Repeat Trips;
proc freq data = divvytrips;
	tables from_station_id*to_station_id / list out=want;
run;

Hi, using the above code, how can I edit this to show only the recurring observations, and eliminate the observations that only occur once?

Re: Show only repeating observations with a proc freq

Reeza — Tue, 07 Dec 2021 02:59:09 GMT

Answered in your previous question.

Re: Show only repeating observations with a proc freq

tan_peng_bigXIA — Tue, 07 Dec 2021 07:28:07 GMT

i want to see it, thanks a lot

Re: Show only repeating observations with a proc freq

camryndastrup — Wed, 08 Dec 2021 01:10:34 GMT

title Repeat Trips;
proc freq data = divvytrips noprint;
	tables from_station_id*to_station_id / list out=want (where=(count>1));
run;

proc print data=want;
run;