topic Re: Create a second ID in New SAS User

Create a sequence of numbers from a specific number

dapenDaniel — Tue, 10 Sep 2019 23:47:46 GMT

Hello,

I have a dataset as below.

ID V1 V2

1 aa bb

1 aa bc

1 aa bd

I want to add a second ID as a separate variable which begins from 751. Both ID and ID2 are numeric variables. The dataset I want is below.

ID V1 V2 ID2

1 aa bb 751

1 aa bc 751

1 aa bd 751

2 bb cc 752

3 ae dg 753

what code do I need to use? Thanks!

Re: Create a second ID

ballardw — Tue, 10 Sep 2019 22:10:31 GMT

@dapenDaniel wrote:

Hello,

I have a dataset as below.

ID V1 V2

1 aa bb

1 aa bc

1 aa bd

I want to add a second ID which begins from 751. The dataset I want is below.

what code do I need to use? Thanks!

Do you want to prefix your current ID variable with 75 or create a new sequence that starts at 751? The difference would be

ID   V1      V2    ID2
1     aa       bb   751
1     aa       bc   751
1     aa       bd   751
2     bb       cc   752
3     ae       dg   753
5     cc       dd   755 (prefix) or 754 (sequence)

Also is your ID character or numeric? And do you want the ID2 to be character or numeric?

Re: Create a second ID

dapenDaniel — Tue, 10 Sep 2019 23:44:06 GMT

Hi Ballardw,

I would like to create a new sequence that starts at 751.

Both ID and ID2 are numeric variables. Thanks.

Re: Create a sequence of numbers from a specific number

Reeza — Wed, 11 Sep 2019 00:30:24 GMT

Assuming you only want to increment based on ID1, you can use RETAIN and BY group processing.

data want;
set have;

by ID1;  

retain ID2 750;

if first.ID1 then ID2 + 1;

run;

BY group processing is covered here:

https://documentation.sas.com/?docsetId=lrcon&docsetTarget=p0xu93fy5eemkyn1p6mj5elses7j.htm&docsetVersion=9.4&locale=en

@dapenDaniel wrote:

Hello,

I have a dataset as below.

ID V1 V2

1 aa bb

1 aa bc

1 aa bd

I want to add a second ID as a separate variable which begins from 751. Both ID and ID2 are numeric variables. The dataset I want is below.

ID V1 V2 ID2

1 aa bb 751

1 aa bc 751

1 aa bd 751

2 bb cc 752

3 ae dg 753

what code do I need to use? Thanks!