topic Re: If first.memberiD then output? in SAS Programming

If first.memberiD then output?

GN0001 — Thu, 23 Sep 2021 22:21:59 GMT

Hello team,

if I have data as

 data mystestdata;
set fromthissorted
by memberID;
if first.memberID then output;
Run;

if first.memberID means from the grouped data, only read the first memberID from the group?

Please advise me.

Respectfully,

blueblue

Re: If first.memberiD then output?

ballardw — Thu, 23 Sep 2021 22:24:07 GMT

@GN0001 wrote:

Hello team,

if I have data as
 data mystestdata;
set fromthissorted
by memberID;
if first.memberID then output;
Run;
if first.memberID means from the grouped data, only read the first memberID?

Please advise me.

Respectfully,

blueblue

After you correct the code so that the Set statement has a terminating semicolon ...

Not read, when encountered. This will "read" all the records in the data set(s) on the Set statement.

If the data is sorted by the By variable then only the records that are the first for each value of the by variable will be written to the output data set. If not sorted an error will be thrown.

Re: If first.memberiD then output?

Astounding — Fri, 24 Sep 2021 03:08:08 GMT

You would do well to teach yourself. Besides reading the documentation, try running a test program. Here is an example:

data mystestdata;
set fromthissorted;
by memberID;
first = first.memberID;
last = last.memberID;
Run;
proc print;
var memberID first last;
run;

Re: If first.memberiD then output?

Kurt_Bremser — Fri, 24 Sep 2021 05:30:04 GMT

READ

THE

DOCUMENTATION

the link to which (this particular documentation!) I already gave you.

And apply Maxim 4. Try It.

Re: If first.memberiD then output?

GN0001 — Mon, 27 Sep 2021 01:40:31 GMT

Hello ballardw,

When you say: " that are the first for each value of the by variable will be written to the output data set"

Do you mean the first for each group?

Please let me know.

Thanks,

blueblue

Re: If first.memberiD then output?

Kurt_Bremser — Mon, 27 Sep 2021 05:23:20 GMT

@GN0001 wrote:

Hello ballardw,

When you say: " that are the first for each value of the by variable will be written to the output data set"

Do you mean the first for each group?

Please let me know.

Thanks,

blueblue

Each distinct value of a BY variable constitutes a group.

Re: If first.memberiD then output?

GN0001 — Sun, 17 Oct 2021 22:20:39 GMT

Hello,
How do you know I have not read the documentation? I have read it a several time and I watched video tutorials. Please kindly bear with me. If we could understand each topic with reading, then what is the point of going to school?
Respecctfully,
Blueblue