DATA Step, Macro, Functions and more

How to use count

Reply
Regular Learner
Posts: 1

How to use count

[ Edited ]

 

 Thanks

Super User
Super User
Posts: 7,942

Re: How to find out the number of unique customers

Posted in reply to Javierphang

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;
Super User
Super User
Posts: 7,942

Re: How to use count

Posted in reply to Javierphang

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.

Ask a Question
Discussion stats
  • 2 replies
  • 174 views
  • 0 likes
  • 2 in conversation