BookmarkSubscribeRSS Feed
SushilKumar
Calcite | Level 5

I Have Created a Dataset as

RF10110110001ALPHAXABCRF10110110001
RF10110110001BETAXABCRF10110110001
RF10110110001GAMMARFABRF10110110001
RF10110110002GAMMAGAGRF10110110002
RF10110110002ZUROMAMRF10110110002
RF10110110002GAAFAZGAGRF10110110002
RF10110110002XELFOMAMRF10110110002

And i Sorted the dataset as

RF10110110001GAMMARFABRF10110110001
RF10110110001ALPHAXABCRF10110110001
RF10110110001BETAXABCRF10110110001
RF10110110002GAAFAZGAGRF10110110002
RF10110110002GAMMAGAGRF10110110002
RF10110110002XELFOMAMRF10110110002
RF10110110002ZUROMAMRF10110110002

I Want the Obersvation Number of the dataset (which is not sorted) in the Output dataset in a Variable called Result

3 REPLIES 3
LinusH
Tourmaline | Level 20

Well, then you have to store the original sort order in a column. Using SQL order by, you could use the monotonic() function, or assign it to _N_ in a data step prior to sorting.

Data never sleeps
SushilKumar
Calcite | Level 5

Could You write the Code How to assgin it.

RichardinOz
Quartz | Level 8

SushilKumar


Create your 'Result' variable thus

     Data Coded ;

          Set Original ;

               Result = _N_ ;

     Run ;

Then sort it.

Richard

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 898 views
  • 1 like
  • 3 in conversation