topic Share SAS data set to non-SAS users in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Share-SAS-data-set-to-non-SAS-users/m-p/50535#M739 <HTML><HEAD></HEAD><BODY><P> Sounds like a typical job for SAS/Add-in for MS Office (AMO).</P><P>If your business users a familiar with pivot tables, using OLAP could work well (if the data is suite for multi dimensional analysis).</P><P>A part from that, AMO has pretty much the same task (wizards) as EG, an let's the user browse, filter and query data.</P><P></P><P>But when you say large, how large?</P><P>It could be performance issues with users that are not database aware, query very large tables. You may want to create smaller specialized data/information marts for some users.</P><P>You also may want to combine this with the use of information maps, which can cover database logic (such as star schema joins, row level security and caclulated columns.</P><P></P><P>You can search support.sas.com to find lot of documentation and papers on this topic.</P><P></P><P>/Linus</P></BODY></HTML> Mon, 21 Nov 2011 09:41:17 GMT LinusH 2011-11-21T09:41:17Z Share SAS data set to non-SAS users https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Share-SAS-data-set-to-non-SAS-users/m-p/50534#M738 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a large SAS data set stored on SAS EG server. How can I let business users without any SAS knowledge to access my data from EXCEL or ACCESS database through linked data source, no programming skill is required?</P><P></P><P>Please discuss scenario with or without OLAP service on the EG server. Any link or document recommendations?</P><P></P><P>Thanks</P><P>Julia</P></BODY></HTML> Fri, 18 Nov 2011 19:23:26 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Share-SAS-data-set-to-non-SAS-users/m-p/50534#M738 julie2 2011-11-18T19:23:26Z Share SAS data set to non-SAS users https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Share-SAS-data-set-to-non-SAS-users/m-p/50535#M739 <HTML><HEAD></HEAD><BODY><P> Sounds like a typical job for SAS/Add-in for MS Office (AMO).</P><P>If your business users a familiar with pivot tables, using OLAP could work well (if the data is suite for multi dimensional analysis).</P><P>A part from that, AMO has pretty much the same task (wizards) as EG, an let's the user browse, filter and query data.</P><P></P><P>But when you say large, how large?</P><P>It could be performance issues with users that are not database aware, query very large tables. You may want to create smaller specialized data/information marts for some users.</P><P>You also may want to combine this with the use of information maps, which can cover database logic (such as star schema joins, row level security and caclulated columns.</P><P></P><P>You can search support.sas.com to find lot of documentation and papers on this topic.</P><P></P><P>/Linus</P></BODY></HTML> Mon, 21 Nov 2011 09:41:17 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Share-SAS-data-set-to-non-SAS-users/m-p/50535#M739 LinusH 2011-11-21T09:41:17Z