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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.