Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
PROC SQL;
CREATE TABLE EXTRACT.ONE_ORDER AS
(SELECT
A.CUSTOMER
,A.MEMBER_NUM
,COUNT(A.MEMBER_NUM) AS MEMBER_COUNT
FROM EXTRACT.ORDERS as A
GROUP BY 1,2
HAVING MEMBER_COUNT < 2
);
QUIT;