BookmarkSubscribeRSS Feed
Javierphang
Calcite | Level 5

 

 Thanks

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 783 views
  • 0 likes
  • 2 in conversation