I am using SAS Enterprise Guide to join datasets. There are >100K observations in each dataset. Prior to joining the datasets, I need to determine the unique IDs that are in each respective dataset. For example, hypothetically, dataset One: ID Var1 Var2 Var3 111-111-1111 0 1 0 222-222-2222 0 1 1 333-333-3333 1 1 1 444-444-4444 0 1 0 555-555-5555 1 1 0 141-547-7810 1 1 0   and Dataset Two: ID Var1 Var2 Var3 111-111-1111 0 1 0 666-666-6666 0 1 1 333-333-3333 0 1 1 444-444-4444 0 1 0 555-555-5555 0 1 0 777-777-8888 0 0 0   How do I get a list of the IDs that are duplicates & a list that are unique?   I've tried using 'join tables' under Query Builder to look for a 'not equal' operator; I tried to use the 'Sort and Filter' task -> copying & pasting IDs from one dataset to another using 'in a list' operator, but the number of IDs in each dataset are greater than the list allows for. I've tried the above with the hyphens & without the hyphens in the ID variable.    Is there an 'easy' way to do this on SAS EG or do I need to use code? If the later, is the    Thanks ahead for any help!     ... View more

I am attempting to run the CCS Code to assess for ICD-9 diagnoses, running on SAS EG. However, I am getting an error code that I cannot seem to correct. I've tried to change the syntax of the '%LET CORE=' code to remove the double quotations, remove the ~, remove each '/', remove both '//', added the 'sas7bdat' extension, but I keep getting the syntax message.    I attempted to simplify the path names. Does this code & log snip help? Any responses are appreciated as I've been trying to fix this for over a week.  CODE USED IN SAS ENTERPRISE GUIDE TO LOAD CCS DIAGNOSTIC TOOL: FILENAME INRAW1 "~//…/CCS/ICD_9/ccs_multi_dx_tool_2015.csv" RECL=300; FILENAME INRAW2 "~//…/CCS/ICD_9/ccs_multi_pr_tool_2015.csv" LRECL=300; LIBNAME IN1 "~//…/Example_Analysis/"; * Location of input discharge data; LIBNAME OUT1 "~//…OUT_Analysis"; * Location of output data; TITLE1 'CREATE CCS MULTI-LEVEL TOOL CATEGORIES'; TITLE2 'USE WITH DISCHARGE ADMINISTRATIVE DATA THAT HAS DIAGNOSIS OR PROCECDURE CODES'; /******************************************************************/ /* Macro Variables that must be set to define the characteristics*/ /* of your SAS discharge data. Change these values to match the */ /* number of diagnoses and procedures on your dataset. Change */ /* CORE to match the name of your dataset. */ /******************************************************************/ * Maximum number of DXs on any record; %LET DXS=6; * Maximum number of PRs on any record; %LET PRS=6; * Input SAS file member name; %LET CORE="~//…/EXAM_long"; LOG WITH ERROR: NOTE: Line generated by the macro variable "CORE". 223 IN1."~//…EXAM_long” ____ 22 201 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. ERROR 201-322: The option is not recognized and will be ignored.    ... View more