BookmarkSubscribeRSS Feed
0 Likes

Add identity column (surrogate key) functionality to Base and SPDE datasets, such as available in SQL Server.

 

If I have a 500M record SAS dataset, it would be great if I could efficiently retrieve the max value of the surrogate key (identity) column from the header of the table.

 

I can provide more details if needed.

11 Comments
Shmuel
Garnet | Level 18

@ScottBass, I made my best to help and I know that good willing is not enough.

I hope someone else in the forum can help or maybe you need ask the SAS technical support.