It would be better to provide small example data sets and what you would expect for output from those examples.   Here's one very small example that uses two difference size data sets with different variables and combines them with the SET statements in the same manner. data one; input x; datalines; 1 2 3 ; data two; input y; datalines; 99 88 77 66 ; data example; set one; set two; run; The result matches the records in order but stops when the set with fewer records is exhausted. If you change the order of the SET statements you will get the same number of records with the same values but the order of the variables in the data set will change. With this construct every record comes from both data sets. So the concept of "if from one set then output to a specific output data set" is pretty useless. If you need that output of different records then both data sets would be on the same SET statement. data fromone fromtwo; set one (in= in1) two (in= in2); ; if in1 then output fromone; if in2 then output fromtwo; run; Which has the effect of adding the variables from the other data set with all missing values.   So, provide an example of what you have for two actual data sets and what you expect for the result. ... View more

data original; input country$14. val1$ val2$ val3 val4$11. val5$ val6$ val7$ val8$ val9$ val10$; infile datalines missover dsd dlm=""; cards; Bahamas 60 9 Bahamas (the) BS BHS 2.9 367168 Bahamas, The BHS 29930 High Income ; run; data temp; set original; id=scan(country,1,,'ka'); run; data want; update temp(obs=0) temp; by id; run; ... View more

data have; input loanno deb cred id $; cards; 1234 27199 0 R 1234 27199 0 R 1234 0 27199 P 1234 0 27199 P 567 2000 0 R 567 2000 0 R 567 0 2000 P ; data temp; set have; by loanno id notsorted; if first.id then n=0; n+1; run; proc sort data=temp; by loanno n; run; data want; set temp; by loanno n; if first.n and last.n then flag='unequal'; else flag='equal '; run; ... View more

There is no RETURN() function, but you may have confused the RETURN Statement with the RETAIN Statement. Please supply some example data (best in usable form, which means a data step with datalines), and what you expect to get out of it. Also post the code you tried, so we can see what went wrong. Use the "little running man" button for posting code. ... View more