cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
marylin5828
‎03-30-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: yes/no columns

by Calcite | Level 5 in New SAS User
‎03-30-2020 03:01 PM
‎03-30-2020 03:01 PM
Hello,  I am stuck on the part where I convert it to numeric. They are already numeric but I combined the answers 2-9 as 0. this is the code I used to filter the numeric variables.   data WORK.DATA01; array vars(6) $ varB2AX--varB3CX; array vars_n(6) var_nB2AX--var_nB3CX; do i=1 to 6; if vars (i)= "1" then vars_n(i) =1; else if vars (i)= "2-9" then vars_n(i)=0; end;   the error messages I am getting are ERROR: Variable varB2AX cannot be found on the list of previously defined variables. ERROR: Too few variables defined for the dimension(s) specified for the array vars. ERROR: Variable var_nB2AX cannot be found on the list of previously defined variables. ERROR: Too few variables defined for the dimension(s) specified for the array vars_n.   Not sure why it is saying it cannot be found if that is the name of the variable.   thanks! ... View more

yes/no columns

by Calcite | Level 5 in New SAS User
‎03-30-2020 01:19 PM
‎03-30-2020 01:19 PM
Hello, I am using a dataset on a large set of individuals. There are 6 questions regarding english proficiency ( each has their own column). I need to separate individuals by the categories speaks some English and no English. My issues is that there are 6 different columns containing yes or no, I need to have Sas combine those who answered yes to 3 or more questions as speaks some english and I need to have those who answered yes to 2 or less of the questions to be categorized as does not speak english.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-30-2020 05:04 PM
Quick links