Hi,
I am trying to create One to Many relation ship, i have a dataset which has similar to a school table as shown below
I ned to list out the distinct Class along with other values
Input DataSet
Name | Class | Subject | Address |
xxxx | 11 | PCMB | dsdsdf,ewhejwe |
xxxxsder | 11 | PCMB | ASDERTG,Fretr |
Asdertrtg | 10 | ABCDER | 123456789 |
DFERTRYO | 8 | PCMB | Oierl saujs |
rtieutrttrt | 9 | PCMB | Olkirta |
Ikitherr | 9 | ABCDER | IKIJHSS |
Wfdfdere | 8 | PCMB | OIUREERR |
WERTGGFDD | 11 | PCMB | OLKIERRE |
Output Expected:
Class | Name | Subject | Address |
11 | xxxx | PCMB | dsdsdf,ewhejwe |
xxxxsder | PCMB | ASDERTG,Fretr | |
WERTGGFDD | PCMB | OLKIERRE | |
10 | Asdertrtg | ABCDER | 123456789 |
9 | rtieutrttrt | PCMB | Olkirta |
Ikitherr | ABCDER | IKIJHSS | |
8 | DFERTRYO | PCMB | Oierl saujs |
Wfdfdere | PCMB | OIUREERR |
I tried using the Group by, Retain and other Stat procedures like Proc Summary, Freq was not able to acheive the result.
Kindly Suggest me on this.
Thanks
Do you need a dataset or a report? This looks like a report.
I think it may be as straight forward as follows:
proc sort data=have;
by descending class;
run;
proc report data=have nowd;
column class name subject address;
define class/group;
define name;
define subject;
define address;
run;
Do you need a dataset or a report? This looks like a report.
I think it may be as straight forward as follows:
proc sort data=have;
by descending class;
run;
proc report data=have nowd;
column class name subject address;
define class/group;
define name;
define subject;
define address;
run;
Hi Reeza,
Thank you !!!
i need it ina dataset, i have tried outputting the Report created but not getting the desired report.
Hi Reeza,
Thank you !!
I have created a dataset.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.