About abmitch95

abmitch95 · ‎03-20-2017

Working with a wide dataset of 500+ variables, need to make sure all values in each row fall within their respective domains. Right now I am using a brute force approach of typing an if then statement that prints the study id, variable name, and value if the value falls outside of the domain: data _null_; set tmp2.bq_module_3; file print; if TQ301 not in (1:5,88,99) then put STUDYID 'TQ301 ' TQ301; if TQ302 not in (1:10) then put STUDYID 'TQ302 ' TQ302; if TQ303 not in (1:1000) then put STUDYID 'TQ303 ' TQ303; run; What I'd like is a program that will only require me to enter the domain for each variable, something like: TQ301 DOMAIN = (1:5, 88, 99, .) TQ302 DOMAIN = (1:10) TQ303 DOMAIN = (1:1000) For TQ301-TQ303 do; if [value] not in [domain] then print STUDYID 'variable name' [value]; Output would look like this: STUDYNO TQ301 6 STUDYNO TQ302 11 STUDYNO TQ303 1001

abmitch95 · ‎02-09-2017

Have: - 4 variables for CD4 count (CD4_1, CD4_2, CD4_3 CD4_4) - 4 variables for the date when the CD4 count was measured (CD4_date1, CD4_date2, CD4_date3, CD4_date4) - 1 variable specifying the start date of the study period (start_sp) - 1 variable specifying the end date of the study period (end_sp) Want to create 3 new dichotomous variables: - CD4_1000, indicates if the individual had a CD4 count less than 1000, with the date of the test falling between the start and end of the study period (start_sp and end_sp) - CD4_500, indicates if the individual had a CD4 count less than 500, with the date of the test falling between the start and end of the study period (start_sp and end_sp) - CD4_350, indicates if the individual had a CD4 count less than 350, with the date of the test falling between the start and end of the study period (start_sp and end_sp) My question is how to create these 3 variables without a paragraph of if then's. This creates the 3 variables, but only incorporates the counts of the tests, not the dates: array CD4 [*] CD4Count; CD4_350 = 0; CD4_500 = 0; CD4_1000 = 0; do i = 1 to dim(CD4); if CD4[i] < 350 then CD4_350 = 1; if CD4[i] < 500 then CD4_500 = 1; if CD4[i] < 1000 CD4_1000 = 1; end; How can I modify this to include the requirement that the date of the test had to occur within the study period?

abmitch95 · ‎01-13-2017

Ah, did not realize including the numeric on the end was necessary. I'll rename the variables and use your second suggestion. Thanks!

abmitch95 · ‎01-13-2017

I am prepping a dataset for analysis that contains descriptive variables for each study participant, as well as the participant's last 5 partners. My goal is to create a variable that summarizes the degree of similarity between each participant and the last 5 partners for select characteristics (age, income, education, etc.). Here is the code I am currently working with, using age as an example: data master2; set master; age_diff1 = partner1_age - age; age_diff2 = partner2_age - age; age_diff3 = partner3_age - age; age_diff4 = partner4_age - age; age_diff5 = partner5_age - age; age_diff_agg = sum(age_diff1, age_diff2, age_diff3, age_diff4, age_diff5); run; Age difference is calculated for each of the last 5 partners, and then summed to create age_diff_agg (age difference aggregated). Is there a way to do this without having to write out the formula 5 times for each characteristic? The code above is giving me the result I need but it is tedious to repeat the process for 20+ variables. Thanks.

Online Status	Offline
Date Last Visited	‎08-31-2017 01:58 PM

Automated Data Cleaning

Processing multiple variables in array/ do loop

Re: Creating aggregated variable with arrays

Creating aggregated variable with arrays

Re: Automated Data Cleaning

Automated Data Cleaning

Processing multiple variables in array/ do loop

Re: Creating aggregated variable with arrays

Creating aggregated variable with arrays