@Reeza   <Reverse the string and then take the substring. Reversing a string of 1 is 1.>   I understand the approach, but: 1) The strings are not 1 character in length (e.g. 13000M, x13260M); and 2) When the string is reversed, the syntax is still taking the character in the first position in the orginal, not reversed, string.   In other words, 13000M is new_var=1, both with, and without, the reverse function. Should new_var=M, given that the string was reversed? That's what I'm after...   When I use the functions separately the reverse function converts 13000M to M13000. When I then use the substring function, only a subset of the observations have the correct value. It's only the observations w/ the longest length (i.e. 7 characters). Any observation w/ less characters than that contains a missing value (See attached image). ... View more

@Reeza   The result for Reverse(substr(string,1,1)) is the same as the result for (substr(string,1,1)). It seems like it's not picking up the "reverse".   What am I doing wrong here?    Thanks! ... View more

@Reeza   <You need to add variables to your filter.>   I'm not clear on what you mean by "filter". Do you mean add additional variables to the BY statement?   <If the rows are not exact duplicates which variables differentiate them?>   The rows are exact duplicates. In the attached image, the last 3 rows are identical. I only want one of them in the final dataset.   Thanks for your help! ... View more

@Tom   Thanks for your clear and detailed explanation here. Unfortunately, I am still struggling to solve this problem.   In some situations, the short stack is dataset two, in other situations, the short stack is dataset one (I should have made this clear in the original post).   Dataset one will never have MORE than 5 observations per BY group variable, but it could have LESS (Some participants dropped out).   Dataset two may have more, or less, than 5 observations.    I want as many observations per BY group as their are in dataset two. For example, if there are 3 observations in dataset two, then I want the variables from dataset one repeated for each of the 3 observations in dataset two. If there are 15 observations in dataset two, then I want the variables from dataset one repeated for each of the 15 observations.    Does this make sense?    I want dataset two to determine the final number of observations in the joined dataset.   Thanks again for your assistance. ... View more

@Reeza @Reeza @PGStats   Thanks for all your help. I think the limitation is my understading of SAS!    I'm just going to output to different datasets.... ... View more

@Astounding    <It's not at all clear what you mean by "separately".> Sorry. I see your confusion. I mean "independently".    "And then independently, I want all the values of score2 included if they are between the same parameters for score2, etc.."   <Do you want multiple output data sets?>   No, I want one dataset.   <What should happen to an observation when SCORE1 is in range and SCORE2 is out of range?>   If score1 is in range, it should be output to the dataset. If score2 is out of range it should not. The final dataset should only include those values that meet the BETWEEN...AND...criteria. ... View more

@Astounding Yes, I did get them mixed up. Sorry about that.   I guess I'm confused about how to subset w/o narrowing the dataset to meet the conditions in all the prior WHERE statements.   I want a dataset that contains the values for each variable between the parameters outlined in the BETWEEN...AND statement. And I want the WHERE statements to be indepencent of each other.   In other words, I want all the values of score1 included if they are between 1.5*Q3 and Q1/1.5. And then separately, I want all the values of score2 included if they are between the same parameters for score2, etc..    Any suggestions?   Thanks for your help. ... View more

@PGStats Thanks. The point is made clearly w/ that code. Only the last WHERE statement is output, although in that example the WHERE statement applies to the same variable, where in mine, there variables are different. Regardless, the outcome is the same when the change to code: data test; set sashelp.class; where sex="M"; where age lt 15; run; proc print; run;   Adding the WHERE-SAME-AND statement eliminates the problem, but this is not what I'm after.  data test; set sashelp.class; where sex="M"; where same and age lt 15; run; Is there a different way to use multiple WHERE statements when subsetting? Should I chose an entirely different approach?     ... View more