topic Re: SET statement and OUTPUT and PDV in SAS Programming

SET statement and OUTPUT and PDV

rajeshalwayswel — Fri, 03 Nov 2017 19:59:19 GMT

data a;
set sashelp.class sashelp.class;output;
set sashelp.class;output;
run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: There were 1 observations read from the data set SASHELP.CLASS.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.A has 39 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

Can someone explain why we getting 1 for observation for 2nd dataset I guess we get total of 38 observations I just confuse in it..

Re: SET statement and OUTPUT and PDV

WarrenKuhfeld — Fri, 03 Nov 2017 20:28:06 GMT

data a;
set sashelp.class(in=a) sashelp.class(in=b);aa=a; bb=b; output;
set sashelp.class(in=c); cc=c; output;
run;
proc print; run;

When you have doubts about what SAS is doing, ask SAS to explain. So I set binary flags so that you can see from where each observation originates. Near the end of processing, William is read from the first mention of the data set. Then it is read from the last. Then on the next pass, Alfred is read from the second data set, then SAS hits end of file on the last data set. So only one obs is read from the second mention.

Re: SET statement and OUTPUT and PDV

SuryaKiran — Fri, 03 Nov 2017 21:08:16 GMT

Hi,

Read this document under the heading Combining SAS Data Sets

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000173782.htm#a000224294

"If the data sets contain common variables, the values that are read in from the last data set replace the values that were read in from earlier ones. "

Re: SET statement and OUTPUT and PDV

Tom — Fri, 03 Nov 2017 21:42:22 GMT

The notes seem pretty clear. You read in 39 observations and wrote out 39 observations.

For the first 19 times through the data step loop you read and write twice and so generate 38 output records.

But on the 20th time through the loop the first SET/OUTPUT pair runs and writes the 39th output record, but the data step stops when it reads past the end of the data in the second SET statement.

Re: SET statement and OUTPUT and PDV

mkeintz — Fri, 03 Nov 2017 23:48:49 GMT

The first SET statement has an incoming stream of up to 38 obs. The second has 19. So there are 19 iterations of the data step in which both SETs read a record.

On the 20th iteration, the first SET is successful (but at that point is just starting its 2nd data set file. But the 20th iteration also exceeds the limit of the 2nd SET, thereby terminating the data step. So the first SET reads 19 +1, and the second reads 19.

Re: SET statement and OUTPUT and PDV

Ksharp — Sat, 04 Nov 2017 12:40:45 GMT

Good question.

I just want say.

NOTE: There were 19 observations read from the data set SASHELP.CLASS.

data a;
set sashelp.class sashelp.class;output;
set sashelp.class;output;
run;

NOTE: There were 1 observations read from the data set SASHELP.CLASS.

data a;
set sashelp.class sashelp.class;output;
set sashelp.class;output;
run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.

data a;
set sashelp.class sashelp.class;output;
set sashelp.class;output;
run;