<?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.post7049639172194988420..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: Importing Excel Data into SAS</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/7049639172194988420/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/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>88</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3058138929389402738</id><published>2021-12-11T06:09:37.912-08:00</published><updated>2021-12-11T06:09:37.912-08:00</updated><title type='text'>Hi
How to import XLS files having missing rows in ...</title><content type='html'>Hi<br />How to import XLS files having missing rows in XLS<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3058138929389402738'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3058138929389402738'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1639231777912#c3058138929389402738' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/03176200372495093844</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-145543078"/><gd:extendedProperty name="blogger.displayTime" value="December 11, 2021 at 6:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-89197417966660241</id><published>2021-11-23T00:45:24.593-08:00</published><updated>2021-11-23T00:45:24.593-08:00</updated><title type='text'>I couldnt make use of &quot;WHERE&quot;

 ERROR 22...</title><content type='html'>I couldnt make use of &quot;WHERE&quot;<br /><br /> ERROR 22-322: Syntax error, expecting one of the following: !, !!, &amp;, *, **, +, -, /, &lt;, &lt;=, &lt;&gt;, =, &gt;, &gt;=, AND, EQ, GE, GT, LE, LT, <br /> NE, OR, ^=, |, ||, ~=. <br /> <br /> ERROR 76-322: Syntax error, statement will be ignored.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/89197417966660241'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/89197417966660241'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1637657124593#c89197417966660241' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12858327630780907246</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1400579005"/><gd:extendedProperty name="blogger.displayTime" value="November 23, 2021 at 12:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5018861936990396751</id><published>2021-02-16T14:34:54.946-08:00</published><updated>2021-02-16T14:34:54.946-08:00</updated><title type='text'>Hi,

 I&#39;m trying to import a xls file in SAS ...</title><content type='html'>Hi,<br /><br /> I&#39;m trying to import a xls file in SAS which has a very strange format. Variable name starting in cell E4 and actual data starting from E33. I can specify range of data in import by the &quot;Range&quot; but how can I get SAS to read in variable name from cell E4? Instead of manually deleting other info in the xls, is there anyway to call SAS to read in variable name and data correctly?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5018861936990396751'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5018861936990396751'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1613514894946#c5018861936990396751' title=''/><author><name>wyalmw</name><uri>https://www.blogger.com/profile/09414355674496672825</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-54343953"/><gd:extendedProperty name="blogger.displayTime" value="February 16, 2021 at 2:34 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6923318685515239700</id><published>2020-10-22T11:01:19.724-07:00</published><updated>2020-10-22T11:01:19.724-07:00</updated><title type='text'>Existing excel sheet had name age gender so I impo...</title><content type='html'>Existing excel sheet had name age gender so I import that excel sheet using proc import datafile = &quot;c:// ***&quot; out = demo dbms = csv;<br /><br />in that csv file i need to add collegename marks percenatage variable means how can i add particular variable to excel sheet any sample pgm ...<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6923318685515239700'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6923318685515239700'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1603389679724#c6923318685515239700' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3341608873472498963'/><author><name>Aravindh</name><uri>https://www.blogger.com/profile/09364006493841662230</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1406971167"/><gd:extendedProperty name="blogger.displayTime" value="October 22, 2020 at 11:01 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3341608873472498963</id><published>2020-10-22T10:58:19.549-07:00</published><updated>2020-10-22T10:58:19.549-07:00</updated><title type='text'>Hi I have a doubt in proc import 

while i read cs...</title><content type='html'>Hi I have a doubt in proc import <br /><br />while i read csv file using proc import, how to add variable in existing csv file like excel sheets<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3341608873472498963'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3341608873472498963'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1603389499549#c3341608873472498963' title=''/><author><name>Aravindh</name><uri>https://www.blogger.com/profile/09364006493841662230</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1406971167"/><gd:extendedProperty name="blogger.displayTime" value="October 22, 2020 at 10:58 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5887302192485914966</id><published>2020-08-13T06:07:59.967-07:00</published><updated>2020-08-13T06:07:59.967-07:00</updated><title type='text'>I imported a xlsx file and values in some column h...</title><content type='html'>I imported a xlsx file and values in some column have strings length greater than 6, and SAS imported only 6 letters from string. How to solve this?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5887302192485914966'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5887302192485914966'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1597324079967#c5887302192485914966' title=''/><author><name>aryalsohan0</name><uri>https://www.blogger.com/profile/14871430168188106603</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1155164893"/><gd:extendedProperty name="blogger.displayTime" value="August 13, 2020 at 6:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6029729923548781218</id><published>2020-07-23T22:28:08.787-07:00</published><updated>2020-07-23T22:28:08.787-07:00</updated><title type='text'>Great tutorial</title><content type='html'>Great tutorial</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6029729923548781218'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6029729923548781218'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1595568488787#c6029729923548781218' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/00835833487524900946</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1171507495"/><gd:extendedProperty name="blogger.displayTime" value="July 23, 2020 at 10:28 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5645403446387353643</id><published>2020-06-17T02:53:34.073-07:00</published><updated>2020-06-17T02:53:34.073-07:00</updated><title type='text'>Hi,

can we import sasb7dat file to SASUniversity ...</title><content type='html'>Hi,<br /><br />can we import sasb7dat file to SASUniversity Edition ? Could u please explain <br />thanks much</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5645403446387353643'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5645403446387353643'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1592387614073#c5645403446387353643' title=''/><author><name>*</name><uri>https://www.blogger.com/profile/10310887405234109621</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://2.bp.blogspot.com/_i2rnjbnpmaE/TFxA1_1E2_I/AAAAAAAABFg/HaoxiWR5iKk/S220/WALl.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1889685943"/><gd:extendedProperty name="blogger.displayTime" value="June 17, 2020 at 2:53 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1651393892983076513</id><published>2020-01-28T03:34:03.099-08:00</published><updated>2020-01-28T03:34:03.099-08:00</updated><title type='text'>In excel file variable having space, how i can imp...</title><content type='html'>In excel file variable having space, how i can import those variable in SAS.<br />Please help me with these.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/1651393892983076513'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/1651393892983076513'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1580211243099#c1651393892983076513' title=''/><author><name>Suraj kambale</name><uri>https://www.blogger.com/profile/10102141931464573895</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1338586605"/><gd:extendedProperty name="blogger.displayTime" value="January 28, 2020 at 3:34 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5509998351506405757</id><published>2019-10-16T06:45:47.858-07:00</published><updated>2019-10-16T06:45:47.858-07:00</updated><title type='text'>Hi deepanshu, I have an excel file in which I need...</title><content type='html'>Hi deepanshu, I have an excel file in which I need to get only the lastrow and lastcolumn values from a sheet. For example iif in the sheet I have data from A1 to R10, then I need value for R10 only. This can be changed according to data. Can you help me how can I get this donme.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5509998351506405757'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5509998351506405757'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1571233547858#c5509998351506405757' title=''/><author><name>KDS</name><uri>https://www.blogger.com/profile/06577199447265471934</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-21530542"/><gd:extendedProperty name="blogger.displayTime" value="October 16, 2019 at 6:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3014749817298760220</id><published>2019-09-13T23:37:13.239-07:00</published><updated>2019-09-13T23:37:13.239-07:00</updated><title type='text'>Proc import datafile =&quot;/folders/myfolders/Sam...</title><content type='html'><br /><br /><br />Proc import datafile =&quot;/folders/myfolders/Sampleold.xls&quot;<br />Out=practice.DB5(keep=name sal)<br />dbms=xls<br />replace;<br />sheet = &quot;sheet1&quot;;<br />getnames=yes;<br />Run;<br /><br />I am writing below code but it doesnt create DB5. it shows notes and because of this it wont work. P.N : I am using university edition.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3014749817298760220'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3014749817298760220'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1568443033239#c3014749817298760220' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/11266327953510172997</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-231333764"/><gd:extendedProperty name="blogger.displayTime" value="September 13, 2019 at 11:37 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4082903595602654358</id><published>2019-05-31T07:25:13.903-07:00</published><updated>2019-05-31T07:25:13.903-07:00</updated><title type='text'>take dbms=xls , and first you verify which version...</title><content type='html'>take dbms=xls , and first you verify which version excel is instaled in your pc..... <br /><br /> </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/4082903595602654358'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/4082903595602654358'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1559312713903#c4082903595602654358' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/8942329904010540275'/><author><name>reddy</name><uri>https://www.blogger.com/profile/16978471212775850461</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-800021506"/><gd:extendedProperty name="blogger.displayTime" value="May 31, 2019 at 7:25 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4925265711315573404</id><published>2019-05-01T08:16:11.811-07:00</published><updated>2019-05-01T08:16:11.811-07:00</updated><title type='text'>I have a data with date format dd-mmm-yy format. H...</title><content type='html'>I have a data with date format dd-mmm-yy format. How can I import the data using proc import?? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/4925265711315573404'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/4925265711315573404'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1556723771811#c4925265711315573404' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/7876241136633945979'/><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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 1, 2019 at 8:16 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5955031532956999015</id><published>2019-04-01T09:57:26.703-07:00</published><updated>2019-04-01T09:57:26.703-07:00</updated><title type='text'>i want diffrent types of csv file are not imported...</title><content type='html'>i want diffrent types of csv file are not imported successfully please help me</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5955031532956999015'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/5955031532956999015'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1554137846703#c5955031532956999015' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06212966825348582018</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2025083644"/><gd:extendedProperty name="blogger.displayTime" value="April 1, 2019 at 9:57 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2670856644159325652</id><published>2019-03-28T12:25:25.399-07:00</published><updated>2019-03-28T12:25:25.399-07:00</updated><title type='text'>where can i find the files used in the tutorials? ...</title><content type='html'>where can i find the files used in the tutorials? thanks</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/2670856644159325652'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/2670856644159325652'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1553801125399#c2670856644159325652' 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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 28, 2019 at 12:25 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8696731134873425944</id><published>2019-01-07T20:00:54.846-08:00</published><updated>2019-01-07T20:00:54.846-08:00</updated><title type='text'>Hello Sir,
 What is the difference between 
input ...</title><content type='html'>Hello Sir,<br /> What is the difference between <br />input IdNumber Name $ 6--20 Team $ 22--27 StartWeight EndWeight;<br />and<br />input IdNumber Name $ 6-20 Team $ 22-27 StartWeight EndWeight;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/8696731134873425944'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/8696731134873425944'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1546920054846#c8696731134873425944' 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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 7, 2019 at 8:00 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3888475346655207701</id><published>2018-11-02T11:12:17.261-07:00</published><updated>2018-11-02T11:12:17.261-07:00</updated><title type='text'>WHY I CANT RUN THIS CODE:
PROC IMPORT DATAFILE=&qu...</title><content type='html'>WHY I CANT RUN THIS CODE:<br />PROC IMPORT DATAFILE=&quot;/home/emmunozjob0/sasuser.v94/PRUEBA.xlsx&quot;<br />OUT=WORK.IPN<br />DBMS=XLSX<br />REPLACE;<br />SHEET=&quot;Sheet1&quot;;<br />GETNAMES=YES;<br />RANGE=&quot;INFO&quot;;<br />RUN;<br /><br />BUT I CAN RUN THIS:<br />PROC IMPORT DATAFILE=&quot;/home/emmunozjob0/sasuser.v94/PRUEBA.xlsx&quot;<br />OUT=WORK.IPN<br />DBMS=XLSX<br />REPLACE;<br />/* SHEET=&quot;Sheet1&quot;; */<br />GETNAMES=YES;<br />RANGE=&quot;INFO&quot;;<br />RUN;<br />I DONT KNOW IF THERE IS A INTERFERENCE WITH THE SHEET AND RANGE KEYWORDS.<br />I CAN RUN THE PROGRAM WHILE ONLY ONE OF THESE STATEMENTS IS ENABLED</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3888475346655207701'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3888475346655207701'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1541182337261#c3888475346655207701' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06215266993031768611</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-539815989"/><gd:extendedProperty name="blogger.displayTime" value="November 2, 2018 at 11:12 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-9203940755724722206</id><published>2018-09-05T13:22:25.469-07:00</published><updated>2018-09-05T13:22:25.469-07:00</updated><title type='text'>Please help me this
Error: physical file does not ...</title><content type='html'>Please help me this<br />Error: physical file does not exist,.......<br />I copied and pasted the path. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/9203940755724722206'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/9203940755724722206'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1536178945469#c9203940755724722206' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07292574149429048349</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1735817701"/><gd:extendedProperty name="blogger.displayTime" value="September 5, 2018 at 1:22 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1072090917825689805</id><published>2018-09-05T09:56:30.763-07:00</published><updated>2018-09-05T09:56:30.763-07:00</updated><title type='text'>Hi,
Can u provide solved example of Titanic datase...</title><content type='html'>Hi,<br />Can u provide solved example of Titanic dataset with no of passengers survived?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/1072090917825689805'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/1072090917825689805'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1536166590763#c1072090917825689805' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/1589847274254860202'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10099248222700981400</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2031605651"/><gd:extendedProperty name="blogger.displayTime" value="September 5, 2018 at 9:56 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6537052284457963144</id><published>2018-06-15T04:05:19.064-07:00</published><updated>2018-06-15T04:05:19.064-07:00</updated><title type='text'>NAMEROW only works with XLS. Typo corrected in the...</title><content type='html'>NAMEROW only works with XLS. Typo corrected in the article.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6537052284457963144'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6537052284457963144'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1529060719064#c6537052284457963144' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3583618764489712607'/><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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="June 15, 2018 at 4:05 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8305088892303590839</id><published>2018-05-15T19:47:55.224-07:00</published><updated>2018-05-15T19:47:55.224-07:00</updated><title type='text'>As per my understanding only one sheet can be open...</title><content type='html'>As per my understanding only one sheet can be open at one time in SAS. which is done by defining Sheet = &quot;Sheet Name&quot;<br /><br />Deepanshu Please correct me if I am wrong</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/8305088892303590839'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/8305088892303590839'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1526438875224#c8305088892303590839' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/7909792823863841160'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10381110923321326064</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1260134518"/><gd:extendedProperty name="blogger.displayTime" value="May 15, 2018 at 7:47 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3544608518883116495</id><published>2018-05-15T19:45:45.426-07:00</published><updated>2018-05-15T19:45:45.426-07:00</updated><title type='text'>Please try this 

Proc Import datafile=&quot;/fold...</title><content type='html'>Please try this <br /><br />Proc Import datafile=&quot;/folders/myfolders/Training/Test1.xlsx&quot; out= Class1.Exceldata dbms=xlsx replace;<br />Run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3544608518883116495'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3544608518883116495'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1526438745426#c3544608518883116495' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/6529800503169237221'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10381110923321326064</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1260134518"/><gd:extendedProperty name="blogger.displayTime" value="May 15, 2018 at 7:45 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3583618764489712607</id><published>2018-05-15T19:40:59.213-07:00</published><updated>2018-05-15T19:40:59.213-07:00</updated><title type='text'>Hello Deepanshu,
The below command is not working ...</title><content type='html'>Hello Deepanshu,<br />The below command is not working when I provided variable name in Second Row of Excel sheet.<br /><br />PROC IMPORT DATAFILE= &quot;E:\SAS Code Repository\Book1.xlsx&quot;<br /> DBMS=XLSX<br /> OUT= TEMP REPLACE;<br /> NAMEROW=2;<br /> STARTROW=3; GETNAMES=YES;<br />RUN;<br /><br />when I import excel file It still Takes variable name row as an observation and create Variable names as A,B,C...Z .<br />Please suggest.<br /><br />Regards<br />Rajat</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3583618764489712607'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/3583618764489712607'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1526438459213#c3583618764489712607' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10381110923321326064</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1260134518"/><gd:extendedProperty name="blogger.displayTime" value="May 15, 2018 at 7:40 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7909792823863841160</id><published>2018-04-24T20:09:13.337-07:00</published><updated>2018-04-24T20:09:13.337-07:00</updated><title type='text'>How i can import excel file with multiple sheets w...</title><content type='html'>How i can import excel file with multiple sheets without opening excel file </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/7909792823863841160'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/7909792823863841160'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1524625753337#c7909792823863841160' title=''/><author><name>Adit</name><uri>https://www.blogger.com/profile/06859172802408082135</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-942265644"/><gd:extendedProperty name="blogger.displayTime" value="April 24, 2018 at 8:09 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2758807786088988583</id><published>2018-04-20T04:00:49.886-07:00</published><updated>2018-04-20T04:00:49.886-07:00</updated><title type='text'>Try this
proc import 
Datafile= &quot;C:\SAS\Datas...</title><content type='html'>Try this<br />proc import <br />Datafile= &quot;C:\SAS\Dataset.xls&quot;<br />Out = work.SAS<br />DBMS = xls<br />Replace;<br />Sheet= &quot;Customer Aquisition&quot;;<br />Getnames= Yes;<br />Run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/2758807786088988583'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/2758807786088988583'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/09/importing-excel-data-into-sas.html?showComment=1524222049886#c2758807786088988583' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/7049639172194988420/comments/default/4331074630910400280'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/17702056975558964196</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/09/importing-excel-data-into-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-7049639172194988420' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/7049639172194988420' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1924255865"/><gd:extendedProperty name="blogger.displayTime" value="April 20, 2018 at 4:00 AM"/></entry></feed>