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: 
ara1
‎03-25-2019
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to create dummy variables

by Calcite | Level 5 in SAS Studio
‎03-23-2019 02:30 AM
‎03-23-2019 02:30 AM
Expected output should look like this   Patient Group Code Second_code Third_code Policy 1 0 96.6 . . . 2 0 96.6 96.6 . . 3 0 96.6 96.6 96.6 . 4 0 96.6 78.7 . 0 5 0 96.6 96.6 78.7 0 6 1 78.7 . . 1 7 1 78.7 78.7 56.5 1 8 1 56.5 . . 1 9 2 96.6 . . . 10 2 56.5 . . .   Thank you beforehand, A ... View more

Re: How to create dummy variables

by Calcite | Level 5 in SAS Studio
‎03-23-2019 02:21 AM
‎03-23-2019 02:21 AM
I want the patients with new_group=1 to be in policy=1, patients in new_group=0 to be in policy=0 and for both groups, patients who have only 96.6 for columns code, second_code, and third_code cannot be included hence why I would want patients 1,2, and 3 to be omitted as well as patient 9 and 10 when creating my new "policy"group. I want patient 4 and 5 to be in policy=0 and patient 6,7,8 in policy=1. This 96.6 is an actual string/value, not sum. Thus, I am not sure why I might need to use the sum SAS code. Would you mind clarifying? ... View more

If/Then Multiple Conditions

by Calcite | Level 5 in SAS Studio
‎03-22-2019 10:45 PM
‎03-22-2019 10:45 PM
My dataset looks something like this: Patient new_group code second_code third_code 1 0 96.6 . . 2 0 96.6 96.6 . 3 0 96.6 96.6 96.6 4 0 96.6 78.7 . 5 0 96.6 96.6 78.7 6 1 78.7 . . 7 1 78.7 78.7 56.5 8 1 56.5 . . 9 2 96.6 . . 10 2 56.5 . .   I want to create a new dummy group called "policy" which contains only patients from group 0 or 1 and does not have the code 96.6 in any of the columns, for example, I want to omit patients 1-3 because they only contain the code 96.6. However, if a patient has the code 96.6 AND another code like 78.7, 56.5, or any other code that is not 96.6, I want to include it in my "policy" group. This is the code I wrote:   data Final2; set Final1; if new_group=0 and code ne "96.6" and second_code ne "." and third_code ne "." then policy=0; if new_group=0 and code ne "96.6" and second_code ne "96.6" and third_code ne "." then policy=0; if new_group=0 and code ne "96.6" and second_code ne "96.6" and third_code ne "96.6" then policy=0; if new_group=1 and code ne "96.6" and second_code ne "." and third_code ne "." then policy=1; if new_group=1 and code ne "96.6" and second_code ne "96.6" and third_code ne "." then policy=1; if new_group=1 and code ne "96.6" and second_code ne "96.6" and third_code ne "96.6" then policy=1; run;   Is this an appropriate code in order to create groups for the dummy variable policy 0 or 1?     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-25-2019 07:26 AM
Quick links