Hi wonderful SAS community, I have four surveys (Survey1, Survey2, Survey3, Survey4) I need to pull together to create a longitudinal data set. The survey questions in each file have different names. I created a crosswalk of the survey questions in Excel that I need and imported it as xwalk: QuestionID Survey1 Survey2 Survey3 Survey4 q1 q05 s35 _18 _how_sat q2 q25 s38 _25 _how_man q3 q32 s42 _30 _how_few q4 q02 s50 _how_long q5 q11 s62 _20 _which_ones q6 q23 s63 _5 q7 q52 s95 _how The questions I need from Survey1 are q05, q25, q32, etc which are the column names in the file Survey1. Survey2 questions I need are s35, s38, s42. Survey3 column names are _18, _25, _30, etc, and Survey4 columns are _how_sat, _how_man, _how_few, etc. Not all surveys contain all the questions. Each survey file also has an ID field and demographic data (not shown) that I will keep as well. QuestionID above in xwalk is a column I created to link all the surveys together on a common variable name. And rather than saying I am interested in the best way, I am also interested in the different ways that this can be done to expand my coding repertoire using SAS 9.4. Thank you all in advance for assistance.
... View more