Hi, I apologize if this is a basic question, I am just a little stuck on discovering the best method of doing this.  Is it possible to pull information from a column in one dataset to generate variable names in a second dataset? For example Have: Dataset1: ID          Make 1           Ford 2           GM 3           Mercedes 4           Toyota 5           Honda Dataset2: Store     var1          var2          var3          var4          var5 100         10             4               0              0              0 101          0              0               5              0              0 102          1              0               4              5              2 Want: Store      Ford         GM          Mercedes   Toyota     Honda 100         10             4               0              0              0 101          0              0               5              0              0 102          1              0               4              5              2 Thank you in advance for your time and consideration. ... View more

Hi and thank you in advance for any assistance you can provide. I'm a bit of a SAS newbie and in running into a little bit of a difficulty.  What I would like to do is have a program that will allow me to either produce output that shows the instances of interest or flag the items of interest.  An example of the type of data I am looking at is: ID               Visit               Date 101               1                  1-Jan-13 101               2                  3-Feb-13 101               3                  1-Apr-13 102               1                  2-Apr-13 102               2                  1-Jan-13 103               1                 10-Jan-13 103               2                  3-Mar-13 103               3                  2-Feb-13 What I would like to do is identify visits within subjects in which the dates are out of order.  For example I would like to either flag the items or produce output that would identify cases that fit the criteria. For example: ID 102 Visit 2 appears to have occurred before Visit 1 ID 103 Visit 3 appears to have occurred before Visit 2 Thank you again for your time and assistance. ... View more

I'm sorry if this may be a little basic for this forum.  I'm trying to write a program to identify when a particular subject has missed a testing session.  My objective is to identify the session(s) missed and the session is only considered to be missed if a later test has occurred.  I was able to write a program that works using a series of 'IF' statements, however it seems to me that there must be a more efficient way.  Any advice would be greatly appreciated. An example of the basic data is as follows: SUBJECT               Test1          Test2          Test3          Test4 1001                         74               68               82              80 1002                         65                                  99              54 1003                         77                                                   22 I would want to identify 1002 - missing Test2 1003 - missing Test2 and Test3 Thank you again for your time and consideration. -Brian ... View more

Hi and thank you in advance for any assistance.  I was hoping to get some information on what may be a useful/best method using SAS to compare a reference data file that contains a specific set of values and labels to a production data file that utilizes the codes.  For example: Reference data: CARMODEL               CARTYPE Camaro                         sport Landcruiser                    suv Explorer                         suv Ranger                          truck Production data file: DRIVER                    CARMODEL          CARTYPE Toonces                    Camero                   sport Danny                       Explorer                   suv Henry                        Camero                    sport Winston                    Landcruiser               truck I would like to be able to compare the production file against the reference data file to check for programming/entry errors--for example 'Camero' instead of 'Camaro' and Landcruiser incorrectly associated with truck instead of suv.  I had been exploring using PROC COMPARE, but this does not seem to be the appropriate method for performing this type of one to many comparison.  I would really appreciate and guidance, suggestions, or approaches anyone is willing to share.  Thank you again for your time and assistance. ... View more