Thanks
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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.