Hi all, I have a SAS table with survey responses. When there is a new response, a new column is added. I want to keep first 2 columns as constant and split the tables in below way. The tables needs to be split in this manner for easier import to visualization tool. Data set: Category Questions Response1 Response2 Response 3 Split table 1: Category Questions Response1 Split table 2: Category Questions Response2 Split table 3: Category Questions Response3 I have already tried below macro. This is splitting the data row wise. New table for each row. Please help.... %let TABLE=SPLIT2; %let COLUMN=Questions; proc sql noprint; select distinct cat("DATA out_",compress(&COLUMN.,,'kad'), "; set &TABLE.(where=(&COLUMN.='", &COLUMN., "')); run;") into :allsteps separated by ';' from &TABLE.; quit; %macro runSteps; &allsteps.; %mend; %runSteps;
... View more