@ballardw, thank you for the information! I had never heard of this tool before -- certainly worth exploring. ... View more

@jimbarbour, THANK YOU SO MUCH!! This is perfect! Exactly what I needed. ... View more

Thank you, both, for your replies, but I think I need something a little bit different.    So I have data like:    ID Student_first Student_last 100 Mary Smith  101 Mary Smit  102 Peter Gray 103 Marie Smith  104 Pete Grey   With the matching code, I am able to identify that cases 100, 101, and 103 belong to one person, and cases 102 and 104 belong to another person.    The matching table looks something like:  ID Student_first Student_last ID_c Student_first_c Student_last_c 100 Mary Smith 101 Mary Smit 100 Mary Smith 103 Marie Smith  101 Mary Smit 103 Marie Smith  102 Peter Gray 104 Pete Grey  104 Pete Grey 102 Peter Gray     I want to be able to include unique person IDs, something like:  ID Student_first Student_last ID_c Student_first_c Student_last_c Person_ID 100 Mary Smith 101 Mary Smit 1 100 Mary Smith 103 Marie Smith 1  101 Mary Smit 103 Marie Smith 1 102 Peter Gray 104 Pete Grey 2 104 Pete Grey 102 Peter Gray 2   The end goal is to find cases from the same people in the original dataset and assign person-specific IDs. Like:  ID Student_first Student_last Person_ID 100 Mary Smith 1 101 Mary Smit 1 102 Peter Gray 2 103 Marie Smith 1 104 Pete Grey 2   When names are exactly the same from the same person across entries, I just used the following code:  proc sort data = dataset; by student_first student_last; run; data dataset; set dataset; by student_first student_last; if first.student_last then Person_ID + 1; run; But with this dataset, the complexity is that the names of the same people were not entered in exactly the same way.    Thanks again for your help!  ... View more

Thank you! ... View more

It works! Thank you so much!! ... View more

That was it! Thank you so much!! ... View more

Just wanted to ask about one more thing -- as I was examining the log, there is a notice "NOTE: Module MAIN is undefined in IML; cannot be RUN." Is this a problem? Why did this notice occur? I do get results even with this notice.  ... View more

Thank you so much! The problem was in the I variable. I renamed it, and the macro worked! Thanks again! ... View more

Thank you for your replies! I followed FreelanceReinhard's recommendation and added dsd missover to the datafile line. My raw file is comma-delimited, periods for missing data, no variable names. The number of error messages decreased but no all... I am including the log below. The program gets the # of observations right. However, the # of variables is 175, not 349...    NOTE: A byte-order mark in the file "C:\Users\Desktop\Data_READY_3.dat" (for fileref "#LN00147") indicates that the data is encoded in "utf-8". This encoding will be used to process the file. NOTE: The infile "C:\Users\Desktop\Data_READY_3.dat" is: Filename=C:\Users\Desktop\Data_READY_3.dat, RECFM=V,LRECL=131068,File Size (bytes)=466817, Last Modified=31Mar2020:00:48:29, Create Time=31Mar2020:00:48:29 NOTE: 1274 records were read from the infile "C:\Users\Desktop\Data_READY_3.dat". The minimum record length was 355. The maximum record length was 383. NOTE: The data set WORK.ONE has 1274 observations and 349 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 1274 observations read from the data set WORK.ONE. NOTE: The data set WORK.ONE has 1274 observations and 349 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ERROR: Variable I not found. NOTE: PROCEDURE MI used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. NOTE: IML Ready ERROR: I is not in the scope of variables for the data set. statement : READ at line 3482 column 1 ERROR: File WORK.EMCOV.DATA does not exist. statement : USE at line 3482 column 1 ERROR: I is not in the scope of variables for the data set. statement : READ at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 3482 column 1 operands : em, *LIT1004, em 0 row 0 col (numeric) *LIT1004 1 row 1 col (numeric) 1 statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 3482 column 1 operands : em, *LIT1005, _TEM1001, em 0 row 0 col (numeric) *LIT1005 1 row 1 col (numeric) 2 _TEM1001 1 row 1 col (numeric) 0 statement : ASSIGN at line 3482 column 1 ERROR: (execution) Invalid operand to operation. operation : J at line 3482 column 1 operands : _TEM1001, *LIT1006, *LIT1007 _TEM1001 1 row 1 col (numeric) 0 *LIT1006 1 row 1 col (numeric) 1 *LIT1007 1 row 1 col (numeric) 1 statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : MAX at line 3482 column 1 operands : jcol jcol 0 row 0 col (type ?, size 0) statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : J at line 3482 column 1 operands : j, *LIT1015, *LIT1016 j 0 row 0 col (type ?, size 0) *LIT1015 1 row 1 col (numeric) 1 *LIT1016 1 row 1 col (numeric) 0 statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : J at line 3482 column 1 operands : j, _TEM1001, *LIT1017 j 0 row 0 col (type ?, size 0) _TEM1001 1 row 1 col (numeric) 175 *LIT1017 1 row 1 col (numeric) 0 statement : ASSIGN at line 3482 column 1 ERROR: DO expression not given value. statement : DO at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : J at line 3482 column 1 operands : j, *LIT1023, *LIT1024 j 0 row 0 col (type ?, size 0) *LIT1023 1 row 1 col (numeric) 1 *LIT1024 1 row 1 col (numeric) 0 statement : ASSIGN at line 3482 column 1 ERROR: DO expression not given value. statement : DO at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 3482 column 1 operands : d2j, $SUB0001, d2j 0 row 0 col (type ?, size 0) statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 3482 column 1 operands : rj, $SUB0001, $SUB0001 rj 0 row 0 col (type ?, size 0) statement : ASSIGN at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : PROBCHI at line 3482 column 1 operands : d2, df D2 0 row 0 col (numeric) df 0 row 0 col (type ?, size 0) statement : ASSIGN at line 3482 column 1 ERROR: Operand j does not have a value. statement : PUT at line 3482 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 3482 column 1 operands : rj, $SUB0001, $SUB0001 rj 0 row 0 col (type ?, size 0) statement : PUT at line 3482 column 1 ERROR: Operand D2 does not have a value. statement : PUT at line 3482 column 1 ERROR: Operand df does not have a value. statement : PUT at line 3482 column 1 ERROR: Operand p does not have a value. statement : PUT at line 3482 column 1 3483 3484 run; NOTE: Module MAIN is undefined in IML; cannot be RUN. 3485 3486 quit; NOTE: Exiting IML. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IML used (Total process time): real time 0.14 seconds cpu time 0.07 seconds   ... View more