topic COPY -paste to excel in SAS Programming

COPY -paste to excel

Ronein — Mon, 14 Jun 2021 05:48:55 GMT

Hello

I am running Logistic Regression and then I am doing CNTRL C and CNTRL V to paste the output in EXCEL file.

It is very strange but some of the information is not going to EXCEL file.

In "Class Level Information" table there are 3 columns: class ,levels,values.

In column values I see only part of the information when I paste it in Excel.

( for example: for Variable X there are 3 classes and in column values I see only one class when I paste it in EXCEL)

Is there any way to solve it?

Re: COPY -paste to excel

SASKiwi — Mon, 14 Jun 2021 06:05:43 GMT

If you are using Enterprise Guide, try the "Share" option when in the Results or Data tab.

Re: COPY -paste to excel

Ronein — Mon, 14 Jun 2021 08:40:41 GMT

Thank you, The output is in "Results-SAS Report" tab.
I see the following tabs there: Refresh, Export,Send To, Create ,Publish,Properties.
In which tab should I click in order to paste the output results in Excel file?

When I click on "Export" tab I get error about SAS add-in for Microsoft office.