Forecasting using SAS Forecast Server, SAS/ETS, and more

sas forecast studio export for desktop forecast values table in excel

Reply
Contributor
Posts: 51

sas forecast studio export for desktop forecast values table in excel

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?

SAS Employee
Posts: 416

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

Hello -

Under Forecasting View - hit "Copy Table" icon.

FST1.JPG

This will bring up a this dialog:

FST2.JPG

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

FST3.JPG

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

Contributor
Posts: 51

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

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

SAS Employee
Posts: 416

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

[ Edited ]

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

step0.JPG

Step 2: Paste the data

step1.JPG

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

step2.JPG

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

step3.JPG

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

step4.JPG

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

step5.JPG

 

Hope this helps.

Regards,

Udo

Ask a Question
Discussion stats
  • 3 replies
  • 442 views
  • 0 likes
  • 2 in conversation