https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/394664#M2120 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/144199">@tomrvincent</a>&nbsp; The latest version (7.14) of the SAS Add-in for MS Office has a "Program" button on the SAS ribbon that allows you to submit SAS code directly from Excel. See this blog post: <A href="http://blogs.sas.com/content/sasdummy/2017/05/30/sas-programs-amo/" target="_blank">http://blogs.sas.com/content/sasdummy/2017/05/30/sas-programs-amo/</A></P> <P>&nbsp;</P> <P>If you need this functionality, we highly recommend that you upgrade to 7.14. (Note: SAS Admins can deny this capability in metadata.)</P> Mon, 11 Sep 2017 13:20:52 GMT fifthand57th 2017-09-11T13:20:52Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/392632#M2117 <P>Anyone know if it is possible to open a SAS view in Excel?&nbsp; I know the view has a libname in it and there doesn't seem to be a way to issue a libname statement in the Excel add-in.&nbsp; Just curious.</P> Fri, 01 Sep 2017 18:38:58 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/392632#M2117 tomrvincent 2017-09-01T18:38:58Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/392949#M2118 <P>Jupp, it works, I have a pre-assigned library, it's defined in the autoexec.</P> Mon, 04 Sep 2017 08:34:08 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/392949#M2118 FredrikE 2017-09-04T08:34:08Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/393267#M2119 <P>I'm guessing you have SAS installed on your PC and am running Windows.</P> Tue, 05 Sep 2017 15:33:49 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/393267#M2119 tomrvincent 2017-09-05T15:33:49Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/394664#M2120 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/144199">@tomrvincent</a>&nbsp; The latest version (7.14) of the SAS Add-in for MS Office has a "Program" button on the SAS ribbon that allows you to submit SAS code directly from Excel. See this blog post: <A href="http://blogs.sas.com/content/sasdummy/2017/05/30/sas-programs-amo/" target="_blank">http://blogs.sas.com/content/sasdummy/2017/05/30/sas-programs-amo/</A></P> <P>&nbsp;</P> <P>If you need this functionality, we highly recommend that you upgrade to 7.14. (Note: SAS Admins can deny this capability in metadata.)</P> Mon, 11 Sep 2017 13:20:52 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/open-sas-view-in-excel/m-p/394664#M2120 fifthand57th 2017-09-11T13:20:52Z