sas forecast studio export for desktop forecast values table in excel

[mmyrto]

I am trying to copy paste the forecast values table as spreadsheet not image in excel and it doesnt paste. It only pastes "obs" for some reason. what am i missing here?

[udo_sas]

Hello -

Under Forecasting View - hit "Copy Table" icon.

This will bring up a this dialog:

In MS Excel you will be able to paste the table into a spreadsheet:

Works fine with Forecasting for Desktop 13.2 (at least for me). If you experience a different behavior you may want to contact Technical Support.

Thanks,

Udo

[mmyrto]

this works fine on my end what i meant is if you are in the modeling view-> tables->forecast values you can highlight and then right click copy, but then try to paste in excel it doesnt work.

thanks for all your responses

[udo_sas]

Hello -

This seems to be a defect indeed - thanks for bringing it to our attention.

Here a one way to work around it:

Step 1: copy the data

Step 2: Paste the data

Step 3: click on (Crtl) pull down in Excel

Step 4: select "Use Text Import Wizard..."

Step 5: make sure to use "Tab" as delimiter

Step 6: you will need to clean up the label manually

Hope this helps.

Regards,

Udo