BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

3 REPLIES 3
Reeza
Super User

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;
santosh_pat69
Quartz | Level 8

Hi Reeza,

Thank you !!!

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

 

 

santosh_pat69
Quartz | Level 8

Hi Reeza,

 

Thank you !!

I have created a dataset.

 

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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