topic Re: Transpose sas data integration studio in SAS Programming

Transpose sas data integration studio

Davidsas111 — Thu, 18 Mar 2021 08:48:07 GMT

Goodmorning,

I'm new in this forum, nice to meet you.

I have a dataset with three observation, market, date and total_amount.

I have to transpose this information with data integration, but when I do this procedure the name of the columns are the number of the dates and not the name that I choose with the format, how can I change it?

Every day this job has to run with new data and new dates, how can I create a table on data integration with no fixed columns (In this way I can load a new table every day with different variables)?

Thank you so much!

Re: Transpose sas data integration studio

LinusH — Thu, 18 Mar 2021 12:01:25 GMT

If you have a scenario where your data model changes frequently, it's not a good fit for data integration.

What is the use for this output? If it's to be consumed directly by end users or exported to a file, it can be managed.

But it will be used as input to other transformations/jobs and stored permanently I think you need to redesign.

Re: Transpose sas data integration studio

Davidsas111 — Thu, 18 Mar 2021 13:10:10 GMT

Hi, thanks for your answer.

I need to develop a table for a report in visual analytics.

The output table must have as variable the market id and the days of the month that are not fixed but every day are reloaded with the last 32 days from todays date.

How can I create a table in DI that can change variable? In sas is easier to develop this solution than DI, but I need to use DI.

What do you think?

Re: Transpose sas data integration studio

LinusH — Fri, 19 Mar 2021 08:23:58 GMT

My undertanding is that VA is quite a flexible tool.

My belief is that data should be sroed in aflexible way so that you can create a variaty of reports.

Having columns fixed by date isn't flexible.

So, without knowing the exact report lay-out, I suggest that you'll have a date columns instead, and have the report do the transposing/pivoting.

Re: Transpose sas data integration studio

Davidsas111 — Fri, 19 Mar 2021 09:05:14 GMT

Thank you so much!

I can import the table with my datas and then transpose on VA.

How can I make a transposition on sas VA?

Re: Transpose sas data integration studio

LinusH — Fri, 19 Mar 2021 09:20:08 GMT

Cross tabulation etc is standard lay outs in reporting.

Don't you have a VA reporting person to help you here?

Otherwise check documentation, guides, potentially attend to training opportunities.

https://www.youtube.com/results?search_query=sas+visual+analytics+tutorial+

https://support.sas.com/edu/elearning.html?productType=library&ctry=se#