Re: General Query

Aamirkhan · Posted 03-12-2019 06:50 AM

Hi Experts, I want to know how to extract a file from SAS in Excel sheet. Thanks

PeterClemmensen · Posted 03-12-2019 06:52 AM

Do you want to transfer data from SAS to Excel or from Excel to SAS?

Aamirkhan · Posted 03-12-2019 04:46 PM

From sas to excel

Kurt_Bremser · Posted 03-12-2019 07:01 AM

To connect to SAS data from Excel, use the SAS Add-In for Microsoft Office.

Aamirkhan · Posted 03-12-2019 04:47 PM

But how to do.

Kurt_Bremser · Posted 03-12-2019 04:55 PM

A google search for "sas add in for microsoft office" gets you all the relevant resources.

Aamirkhan · Posted 03-12-2019 05:10 PM

I didn't find sas add-in in excel 2016.

Kurt_Bremser · Posted 03-13-2019 02:24 AM

The add-in is part of your SAS Software Order (from which your SAS admin created the SAS Depot that was used to install SAS).

If you have the necessary products licensed, you can find it in the SAS Depot and use the SAS Software Deployment Wizard to install it.

You need to have Administrator privileges/permissions on your desktop, as it is a software install, so you might need your IT people to do it.

The 2025 SAS Hackathon has begun!