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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.