Data for a question to the Communities.sas.com The same three records are written to a lib7bdat SAS dataset and an xlsx excel file. Record structure is obs = 1 cantains respondent name obs=2 contains question text (Q_text) for questions 1 and response (Answer) for question 1 obs=3 contains question text (Q_text) for questions 2 and response (Answer) for question 2
Goal is output dataset that is name Q_text1 Answer1 Q_text2 Answer2.