<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post2071830557648796044..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: How to Import Multiple Excel Files into a Single SAS Dataset</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default?start-index=26&max-results=25'/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>26</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1883081702544228534</id><published>2024-03-01T07:37:07.467-08:00</published><updated>2024-03-01T07:37:07.467-08:00</updated><title type='text'>I have fixed the code. Thanks!</title><content type='html'>I have fixed the code. Thanks!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1883081702544228534'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1883081702544228534'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1709307427467#c1883081702544228534' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/5182677770857181439'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="March 1, 2024 at 7:37 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2699940625731674478</id><published>2024-03-01T07:36:36.432-08:00</published><updated>2024-03-01T07:36:36.432-08:00</updated><title type='text'>I have fixed the code. Thanks!</title><content type='html'>I have fixed the code. Thanks!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2699940625731674478'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2699940625731674478'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1709307396432#c2699940625731674478' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4139766093577863086'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="March 1, 2024 at 7:36 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7812779595350459452</id><published>2023-05-30T06:38:04.810-07:00</published><updated>2023-05-30T06:38:04.810-07:00</updated><title type='text'>By using this code, it keeps adding new lines each...</title><content type='html'>By using this code, it keeps adding new lines each time I run, instead of replacing the actual content.<br />Is there any way to replace instead of always re-adding the same info as I run? ie.: Delete all data and add the new set of data from updated files in folder.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7812779595350459452'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7812779595350459452'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1685453884810#c7812779595350459452' title=''/><author><name>Weslley</name><uri>https://www.blogger.com/profile/09879987352548430427</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1031334886"/><gd:extendedProperty name="blogger.displayTime" value="May 30, 2023 at 6:38 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4252156411776746127</id><published>2023-01-24T08:26:10.397-08:00</published><updated>2023-01-24T08:26:10.397-08:00</updated><title type='text'>Trying to import 23 Excel files but no log errors ...</title><content type='html'>Trying to import 23 Excel files but no log errors or no output </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4252156411776746127'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4252156411776746127'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1674577570397#c4252156411776746127' title=''/><author><name>Beginner</name><uri>https://www.blogger.com/profile/14664006203445559031</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1340739161"/><gd:extendedProperty name="blogger.displayTime" value="January 24, 2023 at 8:26 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4533473894120966662</id><published>2022-04-03T21:30:32.118-07:00</published><updated>2022-04-03T21:30:32.118-07:00</updated><title type='text'>Why these Errors are comming in SAS studio given b...</title><content type='html'>Why these Errors are comming in SAS studio given below:<br /><br /> ERROR: Insufficient authorization to access PIPE.<br /> ERROR: Error in the FILENAME statement.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4533473894120966662'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4533473894120966662'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1649046632118#c4533473894120966662' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/5182677770857181439'/><author><name>ANIRBAN DUTTA</name><uri>https://www.blogger.com/profile/08630369225470353619</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1244278556"/><gd:extendedProperty name="blogger.displayTime" value="April 3, 2022 at 9:30 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4139766093577863086</id><published>2022-02-25T17:20:24.316-08:00</published><updated>2022-02-25T17:20:24.316-08:00</updated><title type='text'>Hello, I followed above suggestion and get this er...</title><content type='html'>Hello, I followed above suggestion and get this error, could you please help check? Thanks.<br /><br />ERROR: Insufficient authorization to access PIPE.<br />ERROR: Error in the FILENAME statement.<br /><br />By The way, my file is saved in Linux, not in the local c drive. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4139766093577863086'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/4139766093577863086'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1645838424316#c4139766093577863086' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15756649256646570023</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-984258453"/><gd:extendedProperty name="blogger.displayTime" value="February 25, 2022 at 5:20 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8749958389703725357</id><published>2021-06-10T22:40:46.470-07:00</published><updated>2021-06-10T22:40:46.470-07:00</updated><title type='text'>OTE: The infile MYFILES is:
 Unnamed Pipe Acc...</title><content type='html'>OTE: The infile MYFILES is:<br /> Unnamed Pipe Access Device,<br /><br /> PROCESS=dir &quot;T:\D33Shr\SYSFCST\load forecasting<br /> EU\Test\Sandbox\PepcoDCAMonthlySummaryReagan\&quot; /A-D/B/ON,<br /> RECFM=V,LRECL=32767<br /><br />Stderr output:<br />The system cannot find the file specified.<br />NOTE: 0 records were read from the infile MYFILES.<br />NOTE: The data set WORK.LIST has 0 observations and 2 variables.<br />NOTE: DATA statement used (Total process time):<br /> real time 0.14 seconds<br /> cpu time 0.03 seconds<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/8749958389703725357'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/8749958389703725357'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1623390046470#c8749958389703725357' title=''/><author><name>Jose</name><uri>https://www.blogger.com/profile/09212734425637836778</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-677233379"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2021 at 10:40 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7890858127132483476</id><published>2021-06-10T22:31:57.290-07:00</published><updated>2021-06-10T22:31:57.290-07:00</updated><title type='text'>OTE: The infile MYFILES is:
 Unnamed Pipe Acc...</title><content type='html'>OTE: The infile MYFILES is:<br /> Unnamed Pipe Access Device,<br /><br /> PROCESS=dir &quot;T:\D33Shr\SYSFCST\load forecasting<br /> EU\Test\Sandbox\PepcoDCAMonthlySummaryReagan\&quot; /A-D/B/ON,<br /> RECFM=V,LRECL=32767<br /><br />Stderr output:<br />The system cannot find the file specified.<br />NOTE: 0 records were read from the infile MYFILES.<br />NOTE: The data set WORK.LIST has 0 observations and 2 variables.<br />NOTE: DATA statement used (Total process time):<br /> real time 0.14 seconds<br /> cpu time 0.03 seconds<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7890858127132483476'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7890858127132483476'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1623389517290#c7890858127132483476' title=''/><author><name>Jose</name><uri>https://www.blogger.com/profile/09212734425637836778</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-677233379"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2021 at 10:31 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1223211839999363868</id><published>2021-01-18T15:01:13.784-08:00</published><updated>2021-01-18T15:01:13.784-08:00</updated><title type='text'>How could this be done with 14 text delimited file...</title><content type='html'>How could this be done with 14 text delimited files instead of Excel files?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1223211839999363868'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1223211839999363868'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1611010873784#c1223211839999363868' title=''/><author><name>PHILJ</name><uri>https://www.blogger.com/profile/16554904565838646097</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-152090093"/><gd:extendedProperty name="blogger.displayTime" value="January 18, 2021 at 3:01 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-517376845317738216</id><published>2020-02-17T11:24:59.652-08:00</published><updated>2020-02-17T11:24:59.652-08:00</updated><title type='text'>The code successfully imports all 13 Excel files b...</title><content type='html'>The code successfully imports all 13 Excel files but doesn&#39;t generate a data set of the all the observations. The output file reflects only the observations in the last imported file. Please advise.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/517376845317738216'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/517376845317738216'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1581967499652#c517376845317738216' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="February 17, 2020 at 11:24 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5217446479268893176</id><published>2019-09-27T22:49:32.953-07:00</published><updated>2019-09-27T22:49:32.953-07:00</updated><title type='text'>In one of the interview, i was faced the below que...</title><content type='html'>In one of the interview, i was faced the below question, plz help and give me the code:<br />example :in daily reports-<br /> if we have three excel files,<br /> in each excel - today data is available in two sheets , tomorrow data may available in three sheets .<br />so write a code to append three excels into one excel file , in each excel- data available in sheets may vary day by day but columns/variable names structure is same. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/5217446479268893176'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/5217446479268893176'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1569649772953#c5217446479268893176' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="September 27, 2019 at 10:49 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3188165865916352561</id><published>2019-06-11T01:03:05.253-07:00</published><updated>2019-06-11T01:03:05.253-07:00</updated><title type='text'>Great! </title><content type='html'>Great! </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/3188165865916352561'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/3188165865916352561'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1560240185253#c3188165865916352561' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2419170413026203336'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="June 11, 2019 at 1:03 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2419170413026203336</id><published>2019-06-11T00:43:10.708-07:00</published><updated>2019-06-11T00:43:10.708-07:00</updated><title type='text'>now its working sir</title><content type='html'>now its working sir</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2419170413026203336'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2419170413026203336'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1560238990708#c2419170413026203336' title=''/><author><name>qani</name><uri>https://www.blogger.com/profile/06795360088796980175</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2024660349"/><gd:extendedProperty name="blogger.displayTime" value="June 11, 2019 at 12:43 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-99320365631673400</id><published>2019-06-10T06:54:58.885-07:00</published><updated>2019-06-10T06:54:58.885-07:00</updated><title type='text'>What error you are getting?</title><content type='html'>What error you are getting?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/99320365631673400'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/99320365631673400'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1560174898885#c99320365631673400' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/6324551367209543724'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2019 at 6:54 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6324551367209543724</id><published>2019-06-10T06:12:49.496-07:00</published><updated>2019-06-10T06:12:49.496-07:00</updated><title type='text'>error coming
</title><content type='html'>error coming<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/6324551367209543724'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/6324551367209543724'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1560172369496#c6324551367209543724' title=''/><author><name>qani</name><uri>https://www.blogger.com/profile/06795360088796980175</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2024660349"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2019 at 6:12 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2812078803053032162</id><published>2019-06-10T06:12:33.406-07:00</published><updated>2019-06-10T06:12:33.406-07:00</updated><title type='text'>its not working sir</title><content type='html'>its not working sir</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2812078803053032162'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2812078803053032162'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1560172353406#c2812078803053032162' title=''/><author><name>qani</name><uri>https://www.blogger.com/profile/06795360088796980175</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2024660349"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2019 at 6:12 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1486437728039178943</id><published>2017-10-12T01:22:20.224-07:00</published><updated>2017-10-12T01:22:20.224-07:00</updated><title type='text'>dbms=xlsx should be dbms=excel in my case. </title><content type='html'>dbms=xlsx should be dbms=excel in my case. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1486437728039178943'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1486437728039178943'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1507796540224#c1486437728039178943' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2017 at 1:22 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3750792025822563785</id><published>2017-09-06T01:10:11.566-07:00</published><updated>2017-09-06T01:10:11.566-07:00</updated><title type='text'>Very Nice! Awesome!</title><content type='html'>Very Nice! Awesome!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/3750792025822563785'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/3750792025822563785'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1504685411566#c3750792025822563785' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/09882260547347730694</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1979270860"/><gd:extendedProperty name="blogger.displayTime" value="September 6, 2017 at 1:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1815610900157104521</id><published>2017-01-09T12:11:54.501-08:00</published><updated>2017-01-09T12:11:54.501-08:00</updated><title type='text'>Awesome!!!!</title><content type='html'>Awesome!!!!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1815610900157104521'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1815610900157104521'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1483992714501#c1815610900157104521' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/01379742747456544081</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1200059127"/><gd:extendedProperty name="blogger.displayTime" value="January 9, 2017 at 12:11 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2784489774787114724</id><published>2016-04-29T07:06:16.519-07:00</published><updated>2016-04-29T07:06:16.519-07:00</updated><title type='text'>Can you update the code to only include the first ...</title><content type='html'>Can you update the code to only include the first 5 observations (first 5 files) in the folder and start with the second line of the excel files?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2784489774787114724'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/2784489774787114724'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1461938776519#c2784489774787114724' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10628718275026224790</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-917402229"/><gd:extendedProperty name="blogger.displayTime" value="April 29, 2016 at 7:06 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1959189324718929888</id><published>2016-02-01T14:04:48.930-08:00</published><updated>2016-02-01T14:04:48.930-08:00</updated><title type='text'>How can we use the code when some variables may be...</title><content type='html'>How can we use the code when some variables may be different (or some files have some variables that others don&#39;t have).<br />Thanks</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1959189324718929888'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1959189324718929888'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1454364288930#c1959189324718929888' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/16181283427184967748</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2058770888"/><gd:extendedProperty name="blogger.displayTime" value="February 1, 2016 at 2:04 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7723502341823449104</id><published>2015-11-20T08:06:54.989-08:00</published><updated>2015-11-20T08:06:54.989-08:00</updated><title type='text'>Please start with introduction to macros.</title><content type='html'>Please start with introduction to macros.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7723502341823449104'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/7723502341823449104'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1448035614989#c7723502341823449104' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/14455518312933507057</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1508232592"/><gd:extendedProperty name="blogger.displayTime" value="November 20, 2015 at 8:06 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-874222098633371056</id><published>2015-08-26T01:00:15.580-07:00</published><updated>2015-08-26T01:00:15.580-07:00</updated><title type='text'>Hi, Can you update a article on basic introduction...</title><content type='html'>Hi, Can you update a article on basic introduction to sas macros?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/874222098633371056'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/874222098633371056'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1440576015580#c874222098633371056' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="August 26, 2015 at 1:00 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1006596390624604612</id><published>2015-05-28T05:40:08.768-07:00</published><updated>2015-05-28T05:40:08.768-07:00</updated><title type='text'>Great Work!!</title><content type='html'>Great Work!!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1006596390624604612'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/1006596390624604612'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1432816808768#c1006596390624604612' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 28, 2015 at 5:40 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8423332002460447715</id><published>2015-01-03T07:50:36.594-08:00</published><updated>2015-01-03T07:50:36.594-08:00</updated><title type='text'>Thank you for letting me know the issue. I have fi...</title><content type='html'>Thank you for letting me know the issue. I have fixed the code. It is working fine now!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/8423332002460447715'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/8423332002460447715'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html?showComment=1420300236594#c8423332002460447715' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2071830557648796044/comments/default/5182677770857181439'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-importing-multiple-excel-files-in.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2071830557648796044' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2071830557648796044' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="January 3, 2015 at 7:50 AM"/></entry></feed>