topic Re: SAS query in SAS Programming

How to add information from one data set to another data set?

scb — Tue, 03 Nov 2020 17:33:02 GMT

Is there any chance to get the CAPTAIN name for the TEAM dataset? Anyone can help, thanks?

DATA TEAM;
INPUT TEAM $ SUBTEAM $ CATEGORY $;
DATALINES;
200 001 .
300 . A1
400 002 .
500 . A2
;
run;

DATA CAPTAIN;
INPUT SUBTEAM $ CATEGORY $ CAPTAIN $;
DATALINES;
001 . GIGGS
. A1 JOHN
002 . MELISSA
. A2 CINDY
;
run;

Desired result:

TEAM SUBTEAM CATEGORY CAPTAIN
200 001 GIGGS
300 A1 JOHN
400 002 MELISSA
500 A2 CINDY

Re: SAS query

novinosrin — Tue, 03 Nov 2020 15:47:47 GMT

DATA TEAM; 
INPUT TEAM $ SUBTEAM $ CATEGORY $; 
DATALINES; 
200 001 .
300 . A1 
400 002 .
500 . A2 
;
run;

DATA CAPTAIN; 
INPUT SUBTEAM $ CATEGORY $ CAPTAIN $; 
DATALINES; 
001 . GIGGS
. A1 JOHN
002 . MELISSA
. A2 CINDY
;
run;

proc sort data=team;
 by subteam;
run;

proc sort data=captain;
 by subteam;
run;

data want;
 merge team captain;
 by subteam;
run;

proc sort data=want;
 by team;
run;

proc print noobs;run;

TEAM	SUBTEAM	CATEGORY	CAPTAIN
200	001		GIGGS
300		A1	JOHN
400	002		MELISSA
500		A2	CINDY

Re: SAS query

Tom — Tue, 03 Nov 2020 18:26:07 GMT

Shouldn't that be

proc sort data=team;
 by subteam category;
run;

proc sort data=captain;
 by subteam category;
run;

data want;
 merge team captain;
 by subteam category;
run;

Re: SAS query

novinosrin — Tue, 03 Nov 2020 18:33:14 GMT

Sir @Tom Spot on. Great catch. Awesome.I was waiting to do a blunder. Hmm we should swap our "age" coz you are young and very wise and I am the one who is old. Just one request -, I would also seek your retirement pension so I can safely retire today. 🙂

Damn the "missing" values made me blind!!!!