topic How to select the immediate next record to baseline record, in sas in SAS Programming

How to select the immediate next record to baseline record, in sas

Deepthi999 — Wed, 14 Jun 2023 11:48:18 GMT

How to select the immediate next record to baseline record, in sas

Re: How to select the immediate next record to baseline record, in sas

PaigeMiller — Wed, 14 Jun 2023 12:06:32 GMT

Can you provide a small example of a data set that you are working with?

Re: How to select the immediate next record to baseline record, in sas

AMSAS — Wed, 14 Jun 2023 12:13:37 GMT

Also please, describe in detail what you want to do

Re: How to select the immediate next record to baseline record, in sas

ballardw — Wed, 14 Jun 2023 15:07:38 GMT

@wowspremiumshop wrote:

Sure, here's an example of a small data set that I'm working with:

Name, Age, Gender
John, 25, Male
Emily, 32, Female
Michael, 45, Male
Sarah, 28, Female

This is a simple data set with four individuals, including their names, ages, and genders. It can be used for various purposes, such as analyzing demographic trends or conducting statistical analysis.

~~Your question says "How to select the immediate next record to baseline record". So which of the above is the BASELINE and which the "immediate next record"?~~ Redacted as I thought this data was posted by the person asking the question.

The example you show has no "next record" so is not representative of baseline/following data. So doesn't help in the discussion (yet).

Re: How to select the immediate next record to baseline record, in sas

PaigeMiller — Wed, 14 Jun 2023 15:05:19 GMT

@ballardw wrote:

@wowspremiumshop wrote:

Sure, here's an example of a small data set that I'm working with:

Name, Age, Gender
John, 25, Male
Emily, 32, Female
Michael, 45, Male
Sarah, 28, Female

This is a simple data set with four individuals, including their names, ages, and genders. It can be used for various purposes, such as analyzing demographic trends or conducting statistical analysis.

Your question says "How to select the immediate next record to baseline record". So which of the above is the BASELINE and which the "immediate next record"?

My normal understanding says the example you just showed has no "next record" so is not representative of baseline/following data.

This is confusing. The example data set provided was not from the OP, who has not yet responded. Instead, @ballardw is responding to someone else, @wowspremiumshop , who has jumped into this thread and has not provided anything useful in this discussion (yet), and who I suspect is a spammer (especially if you look at his profile).

Re: How to select the immediate next record to baseline record, in sas

ballardw — Wed, 14 Jun 2023 15:04:52 GMT

@PaigeMiller wrote:

This is confusing. The example data set provided was not from the OP, who has not yet responded. Instead, @ballardw is responding to someone else, @wowspremiumshop , who has jumped into this thread and has not provided anything useful in this discussion (yet).

Good catch. I'm modifying my post.

Re: How to select the immediate next record to baseline record, in sas

Tom — Wed, 14 Jun 2023 19:02:25 GMT

@Deepthi999 wrote:
How to select the immediate next record to baseline record, in sas

Perhaps if you numbered the observations then it would be easier to find the NEXT record.

For example you might number with the "baseline" record as one and every other record increasing from there.

Perhaps have any records that come before the baseline be numbered as zero (or missing).

data want;
  set have ;
  by subject ;
  if first.subject then record=.;
  if visit='BASELINE' then record=1;
  else if record then record+1;
run;

Now you can select the NEXT record by taking those with RECORD=2.