About yoyong

yoyong · ‎09-25-2018

Hi everyone. I need help with data cleaning. I have attached a sample data set with the following variables: OBS LN_LOC_P1_1 LN_LOC_P1_2 LN_LOC_P1_3 LN_LOC_P1_4 LN_TREAT_P1_1 LN_TREAT_P1_2 LN_TREAT_P1_3 LN_TREAT_P1_4 LN_LENGTH_P1_1 LN_LENGTH_P1_2 LN_LENGTH_P1_3 LN_LENGTH_P1_4 LN_LOC variables have 6 choices (1 - 6). LN_TREAT variables have 4 choices (1 - 4). LN_LENGTH variables represent dimensions. From this data set, I just need the LENGTHS of OBSERVATIONS with LN_LOC = 6 AND LN_TREAT = 4. Thank you for your help.

yoyong · ‎09-02-2018

Hi everyone. I need help with recording. I have two sets of variables. First set contains the following: LOC_P1__1, LOC_P1__2,.. LOC_P1__N, LOC_P2__1, LOC_P2__2, LOC_P2__N,... Second set contains the following: TYPE_P1__1, TYPE_P1__2,..TYPE_P1__N, TYPE_P2__1,TYPE_P2__2, TYPE_P2__N,... The options for 1st set are: a,b,c,d. The options for 2nd set are: 1,2,3,4. For each pair of variables (e.g. LOC_P1__1 and TYPE_P1__1, LOC_P1__N and TYPE_P1__N), I would like to recode where LOC_P1__1 = a and TYPE_P1__1 = 2; otherwise other possible combinations should be equal to missing. How do I recode it without doing it multiple times? Thank you.

yoyong · ‎08-15-2018

Hi everyone. I have twenty questions: Q1 - Q20. The responses are in the form of Likert scale. 1 – “strongly agree” 2 – “somewhat agree” 3 – “neither agree no disagree’ 4 – “somewhat disagree’ 5 – “ strongly disagree” How do I do reverse coding for all questions at one time? Thanks for your help.

yoyong · ‎08-15-2018

How do I convert them all at one time?

yoyong · ‎08-15-2018

Hi everyone. I need help. Thank you in advance! I have 100 columns/variables (var1-var 100). Var1 Var 2 Var 3...... Var100 1 3 1 2 8 2 3 7 8 I need to stack all the columns into one variable (let us call it, newcol). It should look like this. newcol 1 2 3 3 8 2 7 . . . 1 8 How do stack them at the same time making sure all the missing data are not included? Also, I noticed some of the variables are characters, others are numeric. How do I make all of them numeric using a single code? Thank you very much for your help!

yoyong · ‎07-31-2018

Hi. I have the following variables from a subset data: Obs A1 A2 A3 B1 B2 B3 C1 C2 C3 .... 1 2 3 4 5 How do I merge all A variables to become one column, similarly for B and C? Some rows maybe totally empty e.g. (Row 3) . How do I exclude such rows in the code? The output will look like: Obs A B C .... 1 2 4 5 1 2 4 5 1 2 4 5 Thank you.

yoyong · ‎07-26-2018

Hi. I need help with proc freq and recoding. I have two sets of variables: Group_A1 Group_A2 Group_A3 Group_A4 Group_B1 Group_B2 Group_B3 Group_C1 Group_C2 where the responses are 1=Yes, 0 = No Treat_A1 Treat_A2 Treat_A3 Treat_A4 Treat_B1 Treat_B2 Treat_B3 Treat_C1 Treat_C2 where the responses are 1 = Agree 2 = Neutral 3 = Disagree a. First, I need to do a PROC FREQ for each pair of variables (Group_A1 and Treat_A1, Group_A2 and Treat_A2, Group_A3 and Treat_A3....., Group_C2 and Treat_C2). b. Then, using each pair of variables, I need to recode where the rule is: if Group = Yes and Treat = Agree, = 1, else = 0. My new variables would have to be A1, A2, A3,...C2. How do I code it without doing proc freq and recoding multiple times? Thanks for your help!

yoyong · ‎07-26-2018

Thank you @novinosrin @hashman @Astounding!

yoyong · ‎07-25-2018

Hi. How do I merge two columns like these two: Obs Height1 Height2 1 150 2 160 3 170 170 4 180 190 5 NA NA The result should look like Obs Height1 Height2 HeightA HeightB 1 150 150 150 2 160 160 160 3 170 170 170 170 4 180 190 180 190 5 NA NA NA NA Thanks.

yoyong · ‎07-23-2018

Hi @Reeza, Not sure what you meant by "Set the second number to be an variable and then do a cross between A and B". As for the output, I would want something like this: PAIR CATEGORIES YES NO A1_1 , B1_1 Good Better Best Thanks.

yoyong · ‎07-22-2018

Hi everyone. I have the following two sets of variables: A1_1 A1_2 A1_3..........A1_10 A2_1 A2_2 A2_3..........A2_10 . . . . . . . . . . . . A10_1 A10_2 A10_3 A10_10 where the possible categories are 1 = good, 2 = better, and 3 = best B1_1 B1_2 B1_3..........B1_10 B2_1 B2_2 B2_3..........B2_10 . . . . . . . . . . . . B10_1 B10_2 B10_3 B10_10 where the possible categories are 1 = yes and 2 = no I need to pair up two variables and do a PROC FREQ: A1_1 and B1_1 A1_2 and B1_2 A1_3 and B1_3 ..... A10_10 and B10_10 where I just need to get 3 = best and 1 = yes. How do I code this in such a way I don't have to do multiple PROC FREQ and SORT commands? Thank you very much.

yoyong · ‎07-22-2018

Thank you for the solutions!

yoyong · ‎07-19-2018

@mkeintz I would like the result to look like this. Thanks.

yoyong · ‎07-19-2018

@Reeza Some variables may be found on both data sets (Respondent and Entry_date). But there are variables unique to each data set (Level and Decision for data set 1 and Degree and Awareness for data set 2). Similarly, some respondents (cases) can be found on both data sets (Respondents 1 and 4). But there are respondents who are unique to each data set (e.g. Respondents 3 and 5 are only in Data set 1 while Respondents 6 and 7 are in Data set 2) .

yoyong · ‎07-19-2018

Hi everyone. I am having some problems with merging two data sets - variables and cases are different. The data sets look like these: Sample Data set 1 contains the following variables: Respondent Entry_date Level (1,2,3,4,5) Decision (1,2) 1 01-Mar-2015 1 1 1 31-Jul-2016 2 2 2 05-Jan-2018 1 1 3 10-Aug-2015 4 1 4 02-Feb-2015 1 2 4 26-May-2017 1 2 4 21-Dec-2017 3 1 5 25-Dec-2016 5 2 A respondent can have multiple records. If respondent answers Level = 1, then respondent is also found in Data set 2 and answers variable DEGREE. Sample data set 2: Respondent Entry_date Degree (1,2,3,4) Awareness (1,2,3,4) 1 01-Mar-2015 2 4 2 05-Jan-2018 3 1 4 02-Feb-2015 1 2 4 26-May-2017 3 3 6 12-Aug-2015 4 1 6 04-Sep-2017 2 4 7 25-Dec-2016 1 2 In data set 2, respondents 6 and 7 do not belong to data set 1. Thank you very much for your help.

Online Status	Offline
Date Last Visited	‎09-25-2018 11:14 PM

Data Cleaning

Recoding variables

Reverse Coding

Re: Stacking columns and convert char to numeric

Stacking columns and convert char to numeric

Merging columns

Proc Freq and Recoding variables

Re: merging two columns

merging two columns

Re: Multiple PROC FREQ

Re: Reverse Coding

Re: Reverse Coding

Re: Reverse Coding

Re: merging two columns

Re: Multiple PROC FREQ

Re: Merging two data sets with different variables and different cases

Data Cleaning

Recoding variables

Reverse Coding

Re: Stacking columns and convert char to numeric

Stacking columns and convert char to numeric

Merging columns

Proc Freq and Recoding variables

Re: merging two columns

merging two columns

Re: Multiple PROC FREQ

Multiple PROC FREQ

Re: Merging two data sets with different variables and different cases

Re: Merging two data sets with different variables and different cases

Re: Merging two data sets with different variables and different cases

Merging two data sets with different variables and different cases