I've got data in excel files that looks like this: _recordId QID122_TEXT QID124_TEXT Response ID Number of Responses Q122 - What is the name of this item? Q124 - In the space below, list as many creative uses as you can think of for this... Category R_3imYisBaKj1DltD 1 bar stretching 4 R_2q7PvEtAwpPZf9F 2 barre ballet 2 clothes 0 R_3QVKnlbMIE7CHZO 4 a bar to hold while squatting 1 to balance your leg 1 to steady your balance 1 to use as a prop 9 R_eRGndjYN0wEIFkR 3 barre horse tie station 10 clothes rack, 5 barricade, 8 R_2zBKJc4IOSw1bhb 2 dance bar stretching 4 dancing 2 R_1CaC6q2dVvHAtyN 4 balance bean do stretches 4 squats 4 help hold balance 1 clothes rack 5 The number of responses to the stimulus is a variable. Based on the number of responses each subject has that many rows of data. Two sheets per excel file with the same subjects responding to different stimuli. What is the easiest way to get this data from excel to SAS? SAS 9.4
... View more