Hello, I know the title isn't very clear and I apologize for that and here is some info to help make what I'm asking about make more sense:   I am a first-semester student in a social science/human ecology PhD program, so I am looking at behaviors and outcomes and pretty new to this. I am using a secondary dataset and I am trying to create a scale variable (that has been created and used this way in other research- though was concerned with a different outcome/relationships. Including using the same secondary data I am using- though from a different wave of the data). I am not concerned with the degree to which a certain behavior or circumstance is present, just whether or not it is present and the effect of that on a particular outcome.   Right now I have created 10 binary dummy variables that are either 0 or 1 (0=behavior/circumstance is not present, 1=behavior/circumstance is present). I want to now create a new variable that will add up the dummy variables to have a value of 0-10, so that in the end the variable will represent a score from 0-10. I just am not sure how to do that from here.   Thank you for any help/direction. ... View more

Hello, I am very new to SAS (just started learning it earlier this semester) and also relatively new to quantitative research (first year PhD student).   I am trying to run a regression analysis from a very large secondary dataset that is part of multiple waves (but I am only using one of the waves), that has replaced missing values with various negative numbers (-9 for not in wave, -3 for missing answer, -1 for refuse to answer, etc...). I am trying to create a binary variable from a multiple choice survey variable (because I'm not concerned with the degrees to which the behavior is present, only whether it is present or whether it is not present- so if it's present at al it will be 1, and if it's not present at all it will be 0), but I don't know how to handle the negative numbers so that the analysis just ignores them and doesn't include them for that variable.   I apologize if I'm not describing what I'm trying to do properly and if this is something that should be obvious on how to handle it. I appreciate any help figuring out the syntax. ... View more