topic Re: How to specifically access the row and column of table data in CAS server using python in SAS Viya

How to specifically access the row and column of table data in CAS server using python

Zhteh — Tue, 20 Mar 2018 15:30:00 GMT

Hi,

I have successfully set up the connection to the cas server, fetch the data and also display the data using python script. I use the code as follows:

flag = conn.CASTable ('lalala' ,caslib = 'public')

flag = flag.table.fetch()
print(flag)

and it gives me the output as follows:

However, I can't access the specific row and column of the table data (eg. row=0,col=1, value = 36945.0).

Can anyone tell me how to do it?

Thanks

alexal — Tue, 20 Mar 2018 16:58:56 GMT

However, I can't access the specific row and column of the table data (eg. row=0,col=1, value = 36945.0).

You can:

flag = conn.CASTable ('lalala' ,caslib = 'public')
print(flag['MSRP'].get(0))

Zhteh — Thu, 22 Mar 2018 03:25:44 GMT

thanks. It works