topic Re: sas forecast studio export for desktop forecast values table in excel in SAS Forecasting and Econometrics

sas forecast studio export for desktop forecast values table in excel

mmyrto — Tue, 03 Nov 2015 14:54:58 GMT

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?

Re: sas forecast studio export for desktop forecast values table in excel

udo_sas — Tue, 03 Nov 2015 16:44:02 GMT

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

Re: sas forecast studio export for desktop forecast values table in excel

mmyrto — Fri, 06 Nov 2015 15:37:26 GMT

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

Re: sas forecast studio export for desktop forecast values table in excel

udo_sas — Fri, 06 Nov 2015 20:23:05 GMT

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