topic Re: Subject wise display while setting 2 datasets in SAS Programming

Subject wise display while setting 2 datasets

ambadi007 — Wed, 17 Mar 2021 04:59:25 GMT

Hi Team,

I have 2 datasets First dataset name is Part1 and other is Part2..

in Part1 have some subjects and information and PArt2 has some other Subjects information

Now i need to set these 2 datasets using subject, and the condition is if Part1 and Part2 have same subjects then I need to display only the information from Part1 dataset while setting or merging

Could you please help me on these

Re: Subject wise display while setting 2 datasets

PeterClemmensen — Wed, 17 Mar 2021 05:47:54 GMT

Can you provode some sample data?

Re: Subject wise display while setting 2 datasets

japelin — Wed, 17 Mar 2021 05:53:29 GMT

Is it set or merge that needs to be done?

Re: Subject wise display while setting 2 datasets

ambadi007 — Wed, 17 Mar 2021 05:55:15 GMT

it would be good if we can set the datasets

Re: Subject wise display while setting 2 datasets

ambadi007 — Wed, 17 Mar 2021 05:58:06 GMT

parta; prtb
101 102
102 101
103 103

here the parta is the main dataset.. if i have parta and part b same subject (eg-103) i need to display only parta subjects information since this the initial data that is collected

Re: Subject wise display while setting 2 datasets

japelin — Wed, 17 Mar 2021 06:03:18 GMT

Like this?
I'm hoping you can provide some data.

data part1;
  input subjid info1 $;
datalines;
1 abc
2 def
4 ghi
5 jkl
8 mno
;
run;

data part2;
  input subjid info2 $;
datalines;
2 pqr
4 stu
6 vwx
7 yz_
;
run;

data want;
  set part1 part2;
  by subjid;
  if first.subjid;
run;

Re: Subject wise display while setting 2 datasets

ambadi007 — Wed, 17 Mar 2021 06:30:36 GMT

thanks it worked for me