Hi all,
I have a dataset as below(sample provided).
data abc; variable="COVAL1";page=3;output; variable="COVAL1";page=4;output; variable="COVAL1";page=5;output; variable="COVAL1";page=6;output; variable="COVAL2";page=13;output; variable="COVAL2";page=14;output; variable="COVAL2";page=15;output; variable="COVAL2";page=16;output; run;
I want to generate a new dataset where the result should appear as below.
coval1 3,4,5,6
coval2 13,14 ,15,16
The goal is to filter observations from the abc dataset where for similar observations in multiple rows should be filtered and then convert the structure in to a way such as for 1 row per variable name must be created with page numbers must appear in 1 row with all the pages.
Please guide us how to proceed for a solution for the same.
... View more