topic Re: How to find out the number of unique customers in SAS Programming

How to use count

Javierphang — Thu, 24 Nov 2016 15:04:03 GMT

Thanks

Re: How to find out the number of unique customers

RW9 — Thu, 24 Nov 2016 14:56:15 GMT

You can use the code window ({i} above your post) to put code into the post, easier than attaching things. I tend to sub-query things before doing sums and other things, makes it easier to read:

proc sql;
  create table WORK.CUSTOMER as 
  select  count(distinct CUSTOMERID) as RES
  from    (select * from ORION.CUSTOMER where customerid ="0");
quit;

Re: How to use count

RW9 — Mon, 28 Nov 2016 09:17:56 GMT

Hi,

To note for future, its not a great idea to totally remove the original question. It means anyone searching on a simliar problem will be presented with no information and unjointed posts. Also a good idea to mark any posts which help correct, so they can be seen in reference to the oroginal quesiton.