Hi Guys I have a dataset structured in the following manner.  data have; input id date yymmdd6. code $ x $ price; datalines; 1 121201 BC Grey 2 1 121202 BC Blue . 1 121203 BC Blue . 1 121204 BC Blue . 2 121101 CC Black 3 2 121102 CC Black 4 3 121101 DD Green 15 3 121102 DD Green . 3 121103 DD Green . 3 121104 DD Green . 3 121105 DD Green 16 3 121107 DD Green . 4 121110 KK Purple 100 4 121111 KK Purple 102 4 121111 KK Purple . 5 121110 MM Red . 5 121111 MM Red . 5 121112 MM Red . 5 121113 MM Red 30 ; run; I would like to remove the group variable (ID ) if there are 3(arbitrary- could be any number) consecutive missing prices  for that ID (forward-looking) and backward-looking . Ideally the output would look like the following  (removing all ID group that has 3 consecutive forward or backward missing prices.  data want; input id date yymmdd6. code $ x $ price; datalines; 2 121101 CC Black 3 2 121102 CC Black 4 4 121110 KK Purple 100 4 121111 KK Purple 102 4 121111 KK Purple . ; run;  Not sure how complicated it is. Any help is greatly appreciated. Thanks.    ... View more

Hi Guys  I have got a dataset that looks like the following -  data have; input ric $ price; datalines; "BCDCA" 10 "BCDCZ" 12 "ABX" 4 "ABCBA" 50 "ABCBZ" 60 run; I want to iterate over the ric (which is a character variable) and flag it if the substring after 3 characters = "CA - CZ", "BA-BZ". Here, CA - CZ includes everything in between (i.e., CA, CB, CC, CD etc. ) and same with BA-BZ. For example, if the substring of the ric is  like the if substrn(ric,4,2)="CA-CZ" then flag=1; else flag=0 I know I can't put the condition like this but want to know if there is any way of doing sth like this. Rather than typing it individually (my dataset is huge and has a lot of ric codes) if there is a sas way of doing that, that would save me a huge amount time. Thank you very much.  ... View more

Hi, The following is an example of my dataset.  data have; input ric $ price n; datalines; abc 5 . abc 6 . bcd 100 10 efg 30 20 cba 40 10 hba 10 10 hba 12 . cab 6 20 cab 7 20 run; I would like to remove the ric group when all the n for the ric is missing. For example, abc should be removed but not hba (not all n is missing).  The output would look like the following-  data want; input ric $ price n; datalines; bcd 100 10 efg 30 20 cba 40 10 hba 10 10 hba 12 . cab 6 20 cab 7 20 run; This is my first post. Any help is appreciated. Thanks.  ... View more