DATA Step, Macro, Functions and more

Need to read a row number from the datset.

Reply
Contributor
Posts: 32

Need to read a row number from the datset.

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 

Frequent Contributor
Posts: 139

Need to read a row number from the datset.

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

Contributor
Posts: 32

Need to read a row number from the datset.

Posted in reply to manojinpec

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

Super User
Posts: 10,023

Need to read a row number from the datset.

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.

Ask a Question
Discussion stats
  • 3 replies
  • 186 views
  • 0 likes
  • 3 in conversation