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?
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
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.