<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Order of variables in Information Map in Microsoft Integration with SAS</title>
    <link>https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Order-of-variables-in-Information-Map/m-p/3034#M136</link>
    <description>I've created several Information Maps so that business users can easily import ( and refresh) the data in Excel. One Info. Map has just under 200 columns and there's a certain ordering of the columns that end users would prefer.  I've tried to order the variables as I created the Maps but this ordering is not preserved when the users pull the data into an Excel spreadsheet.&lt;BR /&gt;
&lt;BR /&gt;
I know a user can order the columns as the items from the Info. Map are selected but it would be nice if the default order is as they are in the Info. Map.&lt;BR /&gt;
&lt;BR /&gt;
So, my question:  Is it possible to preserve the order of the variables/colum when the Info. Map data is pulled into Excel ?&lt;BR /&gt;
&lt;BR /&gt;
Thanks.</description>
    <pubDate>Fri, 11 May 2007 21:46:56 GMT</pubDate>
    <dc:creator>deleted_user</dc:creator>
    <dc:date>2007-05-11T21:46:56Z</dc:date>
    <item>
      <title>Order of variables in Information Map</title>
      <link>https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Order-of-variables-in-Information-Map/m-p/3034#M136</link>
      <description>I've created several Information Maps so that business users can easily import ( and refresh) the data in Excel. One Info. Map has just under 200 columns and there's a certain ordering of the columns that end users would prefer.  I've tried to order the variables as I created the Maps but this ordering is not preserved when the users pull the data into an Excel spreadsheet.&lt;BR /&gt;
&lt;BR /&gt;
I know a user can order the columns as the items from the Info. Map are selected but it would be nice if the default order is as they are in the Info. Map.&lt;BR /&gt;
&lt;BR /&gt;
So, my question:  Is it possible to preserve the order of the variables/colum when the Info. Map data is pulled into Excel ?&lt;BR /&gt;
&lt;BR /&gt;
Thanks.</description>
      <pubDate>Fri, 11 May 2007 21:46:56 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Order-of-variables-in-Information-Map/m-p/3034#M136</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2007-05-11T21:46:56Z</dc:date>
    </item>
    <item>
      <title>Re: Order of variables in Information Map</title>
      <link>https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Order-of-variables-in-Information-Map/m-p/3035#M137</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"&gt;check this link &lt;/SPAN&gt;&lt;SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"&gt;&lt;A href="http://support.sas.com/kb/20/672.html"&gt;http://support.sas.com/kb/20/672.html&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"&gt;Hope this will resolve your issue.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 15 Oct 2012 08:52:01 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Order-of-variables-in-Information-Map/m-p/3035#M137</guid>
      <dc:creator>AkilanR</dc:creator>
      <dc:date>2012-10-15T08:52:01Z</dc:date>
    </item>
  </channel>
</rss>

