DATA Step, Macro, Functions and more

need to create a One to many relationship

Accepted Solution Solved
Reply
Contributor
Posts: 66
Accepted Solution

need to create a One to many relationship

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

NameClassSubjectAddress
xxxx11PCMBdsdsdf,ewhejwe
xxxxsder11PCMBASDERTG,Fretr
Asdertrtg10ABCDER123456789
DFERTRYO8PCMBOierl saujs
rtieutrttrt9PCMBOlkirta
Ikitherr9ABCDERIKIJHSS
Wfdfdere8PCMBOIUREERR
WERTGGFDD11PCMBOLKIERRE

 

 

Output Expected:

ClassNameSubjectAddress
11xxxxPCMBdsdsdf,ewhejwe
 xxxxsderPCMBASDERTG,Fretr
 WERTGGFDDPCMBOLKIERRE
10AsdertrtgABCDER123456789
9rtieutrttrtPCMBOlkirta
 IkitherrABCDERIKIJHSS
8DFERTRYOPCMBOierl saujs
 WfdfderePCMBOIUREERR

 

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

 


Accepted Solutions
Solution
‎05-25-2016 06:23 PM
Super User
Posts: 17,750

Re: need to create a One to many relationship

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;

View solution in original post


All Replies
Solution
‎05-25-2016 06:23 PM
Super User
Posts: 17,750

Re: need to create a One to many relationship

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;
Contributor
Posts: 66

Re: need to create a One to many relationship

Hi Reeza,

Thank you !!!

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

 

 

Contributor
Posts: 66

Re: need to create a One to many relationship

Hi Reeza,

 

Thank you !!

I have created a dataset.

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 218 views
  • 0 likes
  • 2 in conversation