sas set statement

sfffdg — Thu, 28 May 2020 03:35:21 GMT

Hi ,

Help me achieving the below result from the query attached.

name age gender colr skindis
sa 33 F brown
Sb 39 M fair More
AY 11 M fair More
SA 8 F brown

Current output for the query attached is:

name age gender colr skindis
sa 33 F brown
Sb 39 M fair More
AY 11 M fair More
SA 8 F brown More

Re: sas set statement

ballardw — Thu, 28 May 2020 03:57:48 GMT

Why the RSUBMIT /ENDRSUBMIT?

Please provide the rules involved. Examples without the rules are often not sufficient to get a get a general solution.

Unless your code is really long, say more than a couple of hundred lines it is better to post the code into a code box so every one can see the code involved. Copy from the editor and paste into a box on the forum opened with either the </> or "running man" icon that appears above the main message box such as:

rsubmit;
data a;
input name $ age gender $;
cards;
sa 33 F
Sb 39 M
AY 11 M
SA 8 F
Ny Fair
;
run;
endrsubmit;

rsubmit;
data b(index=(name));
input name $ colr $ ;
cards;
sa brown
sa fair
Sb fair
AY fair
SA brown
Sy Fair
;
run;
endrsubmit;

rsubmit;
data c(index=(colr));
input colr $ skindis $ SD $;
cards;
Brown Medium MD
fair More MR
Black less LS
;
run;
endrsubmit;

rsubmit;
data cb;

set a;
set b (keep= name colr) key=name /unique;
if _error_ = 1 then do;
_error_ = 0;

end;
set c (keep= colr skindis) key=colr /unique;
if _error_ = 1 then do;
_error_ = 0;

end;
run;
endrsubmit;

topic Re: sas set statement in SAS Programming

sas set statement

Re: sas set statement