When I run a PROC SQL to create a table and in the table I'm retying the user IDs but counting the amount of jobs they have done it returns a C00xx numbers instead of the actual user ID, below is the code I'm using, it's pretty straight forward but it doesn't return the user ID at all with the count. If I remove the count it returns the user ID   PROC SQL ; CREATE TABLE TEST_2 AS SELECT USER_ID , COUNT(JOBS_COMP) AS JOBS_LOW FROM MAIN_INFO WHERE JOBS_COMP <= 30 GROUP BY USER_ID ; QUIT;  MAIN_INFO USER_ID JOB_DATE JOBS_COMP AB123 020522 1 BA123 040722 1 AB123 030922 1 BA123 061522 1 AC123 010622 1 CA123 051322 1 AC123 071822 1   Current Output USER_ID JOBs_LOW C0001 2 C0002 2 C0003 2 C0004 2 Desired Output USER_ID JOBS_LOW AB123 2 BA123 2 AC123 2 CA123 2 ... View more