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: 
Archibald2
‎07-19-2018
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: merging data

by Calcite | Level 5 in SAS Programming
‎07-18-2018 05:08 PM
‎07-18-2018 05:08 PM
Many thanks hashman ... View more

Re: paired data merging

by Calcite | Level 5 in SAS Programming
‎07-18-2018 05:06 PM
‎07-18-2018 05:06 PM
Many thanks Astounding! This is what I wanted to accomplish. Note- I added a keep statement for dataset1_revised since the last statement did work only for dataset2_revised.         ... View more

paired data merging

by Calcite | Level 5 in SAS Programming
‎07-18-2018 01:42 PM
‎07-18-2018 01:42 PM
  Hello,    I need to merge the DATASET 1  with DATASET 2  to get to a final dataset "DATA WANT" and I need some guidance. please note that dataset 1 is a matched pair data of students and dataset 2  contains additional variables on the matched pairs data.   DATASET 1 groupA_id groupB_id groupA_grade groupB_grade groupA_sex groupB_sex 00000-000001 00000-000200 2 2 1 1 00000-000001 00000-000201 2 2 1 1 00000-000001 00000-000202 2 2 1 1 00000-000002 00000-000203 2 2 1 1 00000-000002 00000-000204 2 2 1 1 00000-000002 00000-000205 2 2 1 1 00000-000003 00000-000206 2 2 1 1 00000-000003 00000-000207 2 2 1 1 00000-000003 00000-000208 2 2 1 1     DATASET 2   id Siblings economic status 00000-000001 Yes low 00000-000001 yes low 00000-000001 yes low 00000-000002 yes low 00000-000002 yes low 00000-000002 yes low 00000-000003 no high 00000-000003 no high 00000-000003 no high 00000-000200 yes low 00000-000201 no low 00000-000202 no high 00000-000203 no medium 00000-000204 no high 00000-000205 yes low 00000-000206 no medium 00000-000207 yes high 00000-000208 yes high   DATA WANT   id grade sex Siblings economic status 00000-000001 2 1 Yes low 00000-000002 2 1 yes low 00000-000003 2 1 no high 00000-000002 2 1 yes low 00000-000200 2 1 yes low 00000-000201 2 1 no low 00000-000202 2 1 no high 00000-000203 2 1 no medium 00000-000204 2 1 no high 00000-000205 2 1 yes low 00000-000206 2 1 no medium 00000-000207 2 1 yes high 00000-000208 2 1 yes high   Any help would be appreciated. Thanks   ... View more

merging data

by Calcite | Level 5 in SAS Programming
‎07-18-2018 12:01 PM
‎07-18-2018 12:01 PM
Hello,  I need to merge the DATASET 1  with DATASET 2  to get to a final dataset "DATA WANT" and I need some guidance. please note that dataset 1 is a matched pair data of students and dataset 2  contains additional variables on the matched pairs data.   DATASET 1 groupA_id groupB_id groupA_grade groupB_grade groupA_sex groupB_sex 00000-000001 00000-000200 2 2 1 1 00000-000001 00000-000201 2 2 1 1 00000-000001 00000-000202 2 2 1 1 00000-000002 00000-000203 2 2 1 1 00000-000002 00000-000204 2 2 1 1 00000-000002 00000-000205 2 2 1 1 00000-000003 00000-000206 2 2 1 1 00000-000003 00000-000207 2 2 1 1 00000-000003 00000-000208 2 2 1 1     DATASET 2   id Siblings economic status 00000-000001 Yes low 00000-000001 yes low 00000-000001 yes low 00000-000002 yes low 00000-000002 yes low 00000-000002 yes low 00000-000003 no high 00000-000003 no high 00000-000003 no high 00000-000200 yes low 00000-000201 no low 00000-000202 no high 00000-000203 no medium 00000-000204 no high 00000-000205 yes low 00000-000206 no medium 00000-000207 yes high 00000-000208 yes high   DATA WANT   id grade sex Siblings economic status 00000-000001 2 1 Yes low 00000-000002 2 1 yes low 00000-000003 2 1 no high 00000-000002 2 1 yes low 00000-000200 2 1 yes low 00000-000201 2 1 no low 00000-000202 2 1 no high 00000-000203 2 1 no medium 00000-000204 2 1 no high 00000-000205 2 1 yes low 00000-000206 2 1 no medium 00000-000207 2 1 yes high 00000-000208 2 1 yes high   Any help would be appreciated. Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-19-2018 06:49 PM
Quick links