Hi,   I have a field with a string of numbers separated by semicolons. I want to check if any of the numbers between the semicolons in this field is a match to what I am looking for. I know I can use "index" or "find," but it may give a false positive if it is a small number within a larger number. For example, if I have a field that contains 123;654;89 and I want to know if it contains '54', I do not want a false positive since 54 is in 654. How can I do this?   Example of what I have: Obs     StrgOfNum 1          934;54;1234 2          123;6542;89   What I want is to know if the number 54 is in any of the observations: Obs     1 <---Should return a positive output indicated it is in this observations 2 <---Should return a negative output indicating it is not in this observations     ... View more

Hi, I'm trying to convert a "RefNumber," which is a char, into an integer inside a Proc SQL statement. Is that possible? I am getting an error when I run the code below.   Proc SQL; Create Table Temp as Select a.*, cast(b.RefNumber as decimal(15,0)) as KeyRef From TableA a Left Join TableB b on a.KeyRef = b.KeyRef; quit;   Error Message: ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), ... View more

I need to run a proc freq for every code in a long list. Is there a macro that can be used to do this?  For example, I need the following proc freq to run over and over again, each time replacing FieldName1.   Need to run proc freq for 'XYZ', 'ABC', 'R2D2', ..., etc.    proc freq data=table; where FieldName1= 'XYZ'; tables FieldName1*FieldName2 / norow nocol nopercent missing; run;   proc freq data=table; where FieldName1= 'ABC'; tables FieldName1*FieldName2 / norow nocol nopercent missing; run;   proc freq data=table; where FieldName1= 'R2D2'; tables FieldName1*FieldName2 / norow nocol nopercent missing; run;   And so and forth for a long list of these codes. ... View more

Hi, what is the most efficient way to grab each unique value from FieldABC for every person listed(i.e. AB and then CD and then EF then GH, etc without duplicates). And then either do option 1 or option 2 as follows:   Option1: Set up a macro to go through each of those unique values to produce a proc freq between FieldABC and FieldXYZ to see where there are matches.   Option2: Do a proc freq displaying all the unique values from FieldABC vs FieldXYZ to see where there are matches.   The table set up looks like this: Person                  FieldABC                              FieldXYZ PersonA               AB                                          CD;EF PersonB               CD;EF;GH                             EF;GH PersonC               AB;EF                                    AB; PersonD               CD                                          EF;GH   Result would look something like this:                 AB          CD          EF           GH          AB          1              0              0              0 CD          0              0              0              0 EF           0              0              1              0 GH          0              0              0              1   Or results could be something like this: For value ‘AB’                      Field XYZ FieldABC              1   For value ‘EF’                      Field XYZ FieldABC              1   ... View more

Hi,    I'm trying to format a field. The field is called "Score" and it is a 3 digit number (and it is specified as a number with a length of 8). However, the code is not grouping them as desired. It appears to be bouncing back the same score for each observation. Can someone tell me what I am doing wrong?   proc format; value $ScoreFormat 1-599 ='<600' 600-640 ='600-640' 641-680 ='641-680' 681-720 ='681-720' 721-760 ='721-760' 761-999 ='761+ ' . ='Missing'; run;   data temp2; set temp1; Score_Band = put( Score ,$ScoreFormat.); run;   Example fields: Acct          Score 1                550 2                665 3                775   Output: Acct          Score_Band 1                550 2                665 3                775   Desired Output: Acct          Score_Band 1              <600 2                641-680 3                761+   Thank you in advance.     ... View more