When using the Python interface for SAS© Viya™ (the SWAT package), it is common to manipulate CASTable objects. While the global display of a table or using the fetch() method to view data is simple, the precise extraction of a single value (a specific cell defined by its row and column) requires a particular syntax.
This article shows you how to target and retrieve a specific piece of data.
You have established your connection to the CAS server and instantiated a CASTable object pointing to an existing table (for example, in the public library).
You want to retrieve the value located, for example, at row 0 of the "MSRP" column. If you use a simple print(), you get a general overview, but not the isolated value that can be used in a Python variable.
The object returned by data retrieval actions (like fetch) or column references on a CASTable object behave similarly to pandas DataFrames.
To access a specific cell, the logic is as follows:
Select the column by its name.
Use the .get() method with the index of the desired row.
Here is how to proceed to extract the value:
In this example, flag['MSRP'] isolates the data series corresponding to the column, and .get(0) retrieves the first entry (index 0). This method is effective for validating unitary data or retrieving control parameters within your automation scripts.
Los códigos y ejemplos proporcionados en WeAreCAS.eu son con fines educativos. Es imperativo no copiarlos y pegarlos ciegamente en sus entornos de producción. El mejor enfoque es comprender la lógica antes de aplicarla. Recomendamos encarecidamente probar estos scripts en un entorno de prueba (Sandbox/Dev). WeAreCAS no acepta ninguna responsabilidad por cualquier impacto o pérdida de datos en sus sistemas.