a good way to check validity thank you!  ... View more

Hi Shmuel,   Thank you for these input and great questions:   Check:     - can an IDx start with 'K' but have more alphabetic characters ? No it has to start with K and then have numbers if you see in ID1 one of the IDs has letter O instead of 0        - can an IDx have less then 8 digits after the 'K' ? Nope      - Is it always capital 'K' ( never 'k') ? yes it should be K although people may type it as k        - Is there any case you will prefer the first IDx instead the last valid ? yes if it is empty the ID3 I would prefere ID1 or ID2 that has this format   I hope now it is more clear. Thank you again very much! ... View more

It is a character... thank you and my apologies to all for my silly question. ... View more

It still show an error saying in both cases (with comas and not comas and with let and/or hard code in proc sql):   "Expression using IN has components that are of different data types" ... View more

Wow indeed but this is brilliant!    Thank you ... View more

Yes that is a good starting point Reeza thank you!   My struggle was really the selction part not so much the transformation but this defintely goes to the right direction   I really appreciate your prompt reply on this you are A SUPER SAS person indeed ... View more

Hi Reeza   Thank you for your questions   I am trying to select subjects for a period of two years which is 6 terms For instance for subject one, those terms are   ID TERM_Code Term_Desc Consecutive Terms 1 201520 Spring 2015 1 1 201530 Summer 2015 2 1 201610 Fall 2015 3 1 201620 Spring 2016 4 1 201630 Summer 2016 5 1 201710 Fall 2016 6     The other two twrms 201720, Spring 2017 and TErm 201730, Summer 2017 are not included because there are not included in those criteria   The other two subjects ID=2 and ID=3 have not completed the cycle of their two years.   The updated HAVE table is here: ID TERM_Code Term_Desc         1 201520 Spring 2015         1 201530 Summer 2015         1 201610 Fall 2015         1 201620 Spring 2016         1 201630 Summer 2016         1 201710 Fall 2016         1 201720 Spring 2017         1 201730 Summer 2017         1 201810 Fall 2019         2 201710 Fall 2016         2 201720 Spring 2017 *Skipped 201730, Summer 2017 2 201810 Fall 2017         2 201820 Spring 2018         2 201830 Summer 2018         3 201510 Fall 2014         3 201520 Spring 2015           The WANT table is here ID TERM_Code Term_Desc Yr1 Yr2 1 201520 Spring 2015 Yes Yes 1 201530 Summer 2015 Yes Yes 1 201610 Fall 2015 Yes Yes 1 201620 Spring 2016 Yes Yes 1 201630 Summer 2016 Yes Yes 1 201710 Fall 2016 Yes Yes 2 201710 Fall 2016 Yes No 2 201720 Spring 2017 Yes No 2 201810 Fall 2017 Yes No 2 201820 Spring 2018 Yes No 2 201830 Summer 2018 Yes No 3 201510 Fall 2014 No No 3 201520 Spring 2015 No No   Might this makes a little bit more sense? ... View more

Thank you so much for your generous help Reeza! ... View more

pgmchange is a binary variable with values yes (1) or no(0) if the subject changed program and timeschange is how many times the subjects changed program...   I am amazed with quick response.   Please forgive me for my sloppy request. Your feedback helped me clarify.    Thank  you all for your quick response.  ... View more

Thank you both for clean version and quick feedback -   The example suggest does not fit my case (at least I think...) here is an output that I was envisioning...   subject   Terms    Pgmchange   Timeschange 1             2           1                     1 2             3           1                     2 3             2           1                     1   Does this make better sense of an output? ... View more