In Visual Analytics I have some calculated items like "my aggregation" which can be applied into other tables. Any way I could drag or copy those calculated items to other tables.
The devil is in the details.
The answer is probably "Yes".
But we need to see both tables, or examples thereof, and what you expect the result to be.
Adding columns usually implies that there are one or more row identifiers to "match" on. Is that the case here?
For example I have the old table:
and the aggregation is sum, mean, median, .... all values
and now the table with new column
also just take sum, mean, median, .... all values
I mean I can open editor and copies the formula but it won't be efficient when I have 100 aggregation calculation.
Any method drag drop calculated items from old table to the new table
If you have two data sets sorted by the ID variable you show with only one observation per id then you can merge them with code like this:
data merged; merge dataold datanew; by id; run;
Placing the new data set second means that any variables with the same name in new and old, other than the variable(s) on the BY statement, will have the values of the variables in the new data.
If you have more than one value of ID in each set then you may have to share more information, as in actual data, as the desired behavior may be trickier.
I don't understand any of your comments about means, median, sum or what have you. That doesn't have anytihing to do with "from one data to another".
I just edited my question.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.