topic General Query in SAS Programming

General Query

Aamirkhan — Tue, 12 Mar 2019 10:50:53 GMT

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

PeterClemmensen — Tue, 12 Mar 2019 10:52:50 GMT

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

Kurt_Bremser — Tue, 12 Mar 2019 11:01:48 GMT

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

Aamirkhan — Tue, 12 Mar 2019 20:46:29 GMT

From sas to excel

Aamirkhan — Tue, 12 Mar 2019 20:47:35 GMT

But how to do.

Kurt_Bremser — Tue, 12 Mar 2019 20:55:58 GMT

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

Aamirkhan — Tue, 12 Mar 2019 21:10:40 GMT

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

Kurt_Bremser — Wed, 13 Mar 2019 06:24:18 GMT

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.