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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 1154 views
  • 1 like
  • 3 in conversation