BookmarkSubscribeRSS Feed
acordes
Rhodochrosite | Level 12

Dear SAS community, business users who are not analytically literate could refrain from using a beautiful, sas powered Visual Analytics report because they miss data-entry functionalities they have in excel. 

I found some excellent topics regarding how data-entry in VA could look like, @Renato_sas, @XavierBizoux and Stu Sztukowski have made fantastic contributions in this regard.

 

It comes close to what I want to achieve.

The user can pass his input through controls to parameters. With a list or a cross table he selects which rows of the table he wants to update (here with the 2% adjustment).

 

The DDC calls the html file which updates the cas table.

And the user input gets recorded.

This would be the excel killer.

 

Is this possible experts?

 

clip_image002.gif

 

{
    "version": "1",
    "resultName": "dd696",
    "rowCount": 2,
    "availableRowCount": 2,
    "data": [
        [
            "A5065",
            "GOLF",
            24
        ],
        [
            "A5066",
            "GOLF",
            24
        ]
    ],
    "columns": [
        {
            "name": "bi694",
            "label": "obs",
            "type": "string"
        },
        {
            "name": "bi697",
            "label": "MODELO",
            "type": "string"
        },
        {
            "name": "bi698",
            "label": "APLAZ",
            "type": "number",
            "usage": "categorical",
            "format": {
                "name": "COMMA",
                "width": 12,
                "precision": 2,
                "formatString": "COMMA12.2"
            }
        }
    ],
    "parameters": [
        {
            "name": "pr52",
            "label": "target_column_name",
            "dataType": "string",
            "value": "adjustment"
        },
        {
            "name": "pr663",
            "label": "adjustment",
            "dataType": "number",
            "value": 0.02,
            "format": {
                "name": "PERCENT",
                "width": 12,
                "precision": 0,
                "formatString": "PERCENT12."
            }
        }
    ]
}


 

1 REPLY 1
XavierBizoux
SAS Super FREQ

Hi, 

 

I think that based on your description. It can be achieved using the DDC object. 

What I would do based on your description is add a calculated measure to the table in VA. The calculated measure would evaluate the existing measure multiplied by the adjustment factor. The measure doesn't have to be displayed in the report but it can then be passed to the DDC object. This will then allow the DDC object to generate the correct call to a SAS Viya job that will update the source table in CAS or in a database. I think this should clearly meet your expectations. 

 

You might find some ideas on how it can be implemented in https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4138-2020.pdf.

Let me know if you have questions.

Regards, 

Xavier

 

Xavier BIZOUX
Advisory Technical Architect ● Global Enablement and Learning
Technology Transfer and Governance, R&D

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 793 views
  • 0 likes
  • 2 in conversation