topic Re: need to create a One to many relationship in SAS Programming

need to create a One to many relationship

santosh_pat69 — Wed, 25 May 2016 21:24:41 GMT

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

Re: need to create a One to many relationship

Reeza — Wed, 25 May 2016 21:51:11 GMT

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;

Re: need to create a One to many relationship

santosh_pat69 — Wed, 25 May 2016 22:13:39 GMT

Hi Reeza,

Thank you !!!

i need it ina dataset, i have tried outputting the Report created but not getting the desired report.

Re: need to create a One to many relationship

santosh_pat69 — Wed, 25 May 2016 22:23:42 GMT

Hi Reeza,

Thank you !!

I have created a dataset.