topic Re: Rename Variable with functions SAS Visual Analytics in SAS Programming

Rename Variable with functions SAS Visual Analytics

Davidsas111 — Wed, 24 Mar 2021 08:56:56 GMT

Hi,

I want to know if it's possible to rename a variable with a function.

In particular I need to rename 32 variables with the days past from the today's date. Ex: var1=now(), var2=now()-2 etc.

Thanks for your help.

Re: Rename Variable with functions SAS Visual Analytics

ChrisNZ — Thu, 25 Mar 2021 22:11:53 GMT

Try:

rename (or label?) VAR1 to %sysfunc(today(),date9.)

rename (or label?) VAR2 to %sysfunc(putn(%eval(%sysfunc(today())-1),date9.))

rename (or label?) VAR3 to %sysfunc(putn(%eval(%sysfunc(today())-2),date9.))

etc

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Thu, 25 Mar 2021 23:19:51 GMT

Thanks for your help.
Where I Have to Put this code? In the list table advanced filter?

Re: Rename Variable with functions SAS Visual Analytics

SASKiwi — Fri, 26 Mar 2021 01:22:40 GMT

Why do you want to rename a large number of variables in SAS VA? If you do that you will break any VA reports that use the old variable names. Perhaps if you explain what you are trying to do there might be a better way, possibly by creating calculated items.

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Fri, 26 Mar 2021 08:40:25 GMT

Thanks for your answer.

I have to realize a report like the one attached.

I have two buttons that filter yellow columns by 2 variables for the right character variable.

I can't use a cross table because my measures are not numerical.

So I've decided to create a list table with 30 categorical variables (DATE1-DATE30, number of day that I need) that have value:

DATE1:

IF ( 'BUTTON 'p = 'VAR 1' )
RETURN 'VAR1_DATE1'n
ELSE 'VAR2_DATE1'n

DATE2:

IF ( 'BUTTON 'p = 'VAR 2' )
RETURN 'VAR1_DATE2'n
ELSE 'VAR2_DATE2'n

etc...

But now I want to show in the table the current date as label in the list table, and rename date1=now(), date2=now()-1 etc, but I don't know what code use and where use it.

thanks for your help.

Re: Rename Variable with functions SAS Visual Analytics

ChrisNZ — Fri, 26 Mar 2021 22:19:37 GMT

Why not use the labels I provided?

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Fri, 26 Mar 2021 23:47:14 GMT

Where canI insert that code in VA?

Re: Rename Variable with functions SAS Visual Analytics

ChrisNZ — Sat, 27 Mar 2021 00:43:37 GMT

In the label field

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Sat, 27 Mar 2021 01:04:04 GMT

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Sat, 27 Mar 2021 01:07:20 GMT

If I insert the %sysfunc in the label filelds of a category it dosen't solve it. It writes the %sysfunce litteraly As label

Re: Rename Variable with functions SAS Visual Analytics

ChrisNZ — Wed, 31 Mar 2021 07:53:36 GMT

Oh this is not good. I swear there was a way to do this. It's been years since I last used VA. What if you create a computed value? Does the macro language get solved?

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Mon, 29 Mar 2021 08:18:10 GMT

No, the macro language dosen't get solved in a computed value.

I don't know how to do that!

Re: Rename Variable with functions SAS Visual Analytics

SASKiwi — Tue, 30 Mar 2021 00:11:20 GMT

@Davidsas111 - It would help if you provided a few example rows of your source data. There are probably better ways of transforming your data but since we don't know what it looks like to start with we can't provide any guidance.

Also how often do you refresh the data?

Re: Rename Variable with functions SAS Visual Analytics

Davidsas111 — Tue, 30 Mar 2021 07:28:05 GMT

I have to refresh datas every day.

I have to transpose a table with "var" char variables, so I can't do it on VA because cross tables can be applied fornumeric variables.

I transpose it on DI but on VA two bottons have to filters data.

Now I have to Rename the category (calculated as I wrote up) with dates.

How can I do it?

Or how can I transpose in VA character variables in a cross table?

Thanks for your help!