Increasing a Batch Routine Number by Timestamp in SAS

Question

I have a routine in SAS that runs intraday, periodically updating data in table A. I would like to identify the batch of data by the timestamp column and increment it with each data update throughout the day.
Example: First routine of the day - entry data:
data

id	column_a	timestamp
1	Orange Bank	07Apr2025 00:05:15
2	Market Bank	07Apr2025 00:05:15
3	Orange Coins	07Apr2025 00:05:15

Recording output in table A:

id	column_a	timestamp	batch
1	Orange Bank	07Apr2025 00:05:15	1
2	Market Bank	07Apr2025 00:05:15	1
3	Orange Coins	07Apr2025 00:05:15	1

Second routine of the day:
data

id	column_a	timestamp
4	Black Bank	07Apr2025 00:25:48
5	Joseph House	07Apr2025 00:25:48
6	Blank Mall	07Apr2025 00:25:48

Doing append in table A increasing 1 in batch column by timestamp:

id	column_a	timestamp	batch
4	Black Bank	07Apr2025 00:25:48	2
5	Joseph House	07Apr2025 00:25:48	2
6	Blank Mall	07Apr2025 00:25:48	2

Consolidated table A:

id	column_a	timestamp	batch
1	Orange Bank	07Apr2025 00:05:15	1
2	Market Bank	07Apr2025 00:05:15	1
3	Orange Coins	07Apr2025 00:05:15	1
4	Black Bank	07Apr2025 00:25:48	2
5	Joseph House	07Apr2025 00:25:48	2
6	Blank Mall	07Apr2025 00:25:48	2

And so the routine continues throughout the day, increasing the batch number with each new batch of data... What is the best way to do this?

Richard · Accepted Answer · 2025-04-08 21:43:31Z

0

You can compute the batch number apriori and apply it to the batch data.

select sum(max(batch),1) into :next_batch_number trimmed from <target> where datepart(timestamp) = today() ;

data batch ;
  set <mydata> ;
  batch = &next_batch_number ;
  timestamp = datetime() ;
run ;

proc append base=<target> data=batch ;
run ;

answered Apr 8 at 21:43

Richard

27.6k4 gold badges28 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Increasing a Batch Routine Number by Timestamp in SAS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related