Hey community, I have some data with a total of 52 variables. Issue is that these variables when exported from the data capture database they are lumped together all in one excel cell, with different combinations of the variables. For example (made up data has been used for example purposes). Excel cell A1: site_id = '0', pt_initials = 'AA', dob = '1800-01-01', sex = '1', form_3_followup_complete = '0', study_id = '000' Excel cell B1: fup_cont_attemp = '1', fup_time = '30', fup_yesno = '0', fup_nocall = '2', fup_date = '1900-01-01 13:30', fup_comment = 'weather is nice today' How can I code in SAS so that it presents it like the below? site_id pt_initials dob sex form_3_followup_complete study_id fup_cont_attemp fup_time fup_yesno fup_nocall fup_date fup_comment 0 AA 1800-01-01 1 0 000 1 30 0 2 1900-01-01 13:30 Weather is nice today
... View more