set and merge

Zhenmin — Fri, 09 Aug 2019 13:54:18 GMT

Two tales with 100 unique observations, how much observations after set? How much observation after merge?

Re: set and merge

VDD — Fri, 09 Aug 2019 14:02:45 GMT

well you don't tell very much.

a set statement should give you 100.

a merge statement will give you the number of obs that meet the by statement in you data merge.

Re: set and merge

ballardw — Fri, 09 Aug 2019 15:39:46 GMT

@Zhenmin wrote:

Two tales with 100 unique observations, how much observations after set? How much observation after merge?

Actually there is insufficient information to answer this question without 1) the exact code used and 2) the data involved for the merge.

Consider the following code:

data junk;
  x=5;
run;

data example;
   set junk junk junk;
run;

The data set Example has 3 records because the data set name Junk is duplicated on the set the statement even though the set Junk only has one record.

data example;
   set junk ;
   do i= 1 to 5;
      output;
   end;
run;

Has 5 records because the OUTPUT statement executes 5 times for each record in Junk.

Additionally other code in a data step could add or remove records.

Merge without a BY would have 100 records. But if there is a BY statement you could have anywhere from 100 to 200 depending on the content of the data assuming there are no record filters or anything to create additional records.

Re: set and merge

Zhenmin — Fri, 09 Aug 2019 21:44:25 GMT

Thank you all and have a nice weekend!

topic Re: set and merge in SAS Programming

set and merge

Re: set and merge

Re: set and merge

Re: set and merge