BookmarkSubscribeRSS Feed
shru
Calcite | Level 5

Hi,

I have a dataset imported from excel.Now i need to read a row number say for ex:67 and assign it to macro variable.

How can i do this?

help me in this

Thanks 

3 REPLIES 3
manojinpec
Obsidian | Level 7

Do you want to assign the content of some variable in row number 67 or the row number itself. Please be more clear.

shru
Calcite | Level 5

Hi,

I need to read the row number eg:67 and assign it to  another macro variable.

So when i run the daily,it should get updated every day.

I need to assign row number only.

Thanks

Ksharp
Super User

How do you identify this row 67, Is there some criterion ?

If not, you can directly use %let n=67; to save it into a macro variable.

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
  • 1094 views
  • 0 likes
  • 3 in conversation