topic Need to read a row number from the datset. in SAS Programming

Need to read a row number from the datset.

shru — Tue, 20 Mar 2012 07:04:20 GMT

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

manojinpec — Tue, 20 Mar 2012 07:07:06 GMT

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

shru — Tue, 20 Mar 2012 07:53:09 GMT

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 — Tue, 20 Mar 2012 08:05:58 GMT

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.