tag:blogger.com,1999:blog-3889219616765973387.post998885070542826976..comments2023-05-24T05:38:50.418-07:00Comments on <i>corinna</i>: Reading Excel and Access files on SAS 64-bitCorinna Lohttp://www.blogger.com/profile/00900594161102942245noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3889219616765973387.post-41844611978726170812014-09-05T14:45:34.753-07:002014-09-05T14:45:34.753-07:00There's a easy way doing that:
Hi, you can sol...There's a easy way doing that:<br />Hi, you can solve your problem ease.<br />Try use this routine and have fun:<br /><br />PROC IMPORT OUT= WORK.name_your_DB<br /> DATAFILE= "C:\your_file.xls" <br /> DBMS=EXCELCS REPLACE;<br /> RANGE="name_of_the_worksheet_tab"; <br /> SCANTEXT=YES;<br /> USEDATE=YES;<br /> SCANTIME=YES;<br />RUN;jalleshttps://www.blogger.com/profile/18044329321428571405noreply@blogger.comtag:blogger.com,1999:blog-3889219616765973387.post-46227291248189157672012-11-30T16:26:42.083-08:002012-11-30T16:26:42.083-08:00I added the macro because I often need to share my...I added the macro because I often need to share my SAS program with my colleagues. Some of them were still using 32-bit machines at the time. Therefore, I added the macro so SAS will detect if the machine is running 64-bit operating system. If yes, then use this pc server approach to open the Excel file. Otherwise, use the old OLEDB approach.<br /><br />BTW, starting with SAS 9.3, I notice Corinna Lohttps://www.blogger.com/profile/00900594161102942245noreply@blogger.comtag:blogger.com,1999:blog-3889219616765973387.post-42536049399600171542012-11-30T07:33:09.820-08:002012-11-30T07:33:09.820-08:00hi Corninna,
i am to see this macro used to conne...hi Corninna, <br />i am to see this macro used to connect the excel file but i am new bee and little knowledge to use macro , <br />As i try to find other solution without using the macro .<br />the simple way is using this syntax <br /><br /><br />libname test pcfiles path=' path excel file '; <br /><br />it is also connect the respective sheets same as normal when saw the error mention Anonymoushttps://www.blogger.com/profile/01942480704004973538noreply@blogger.comtag:blogger.com,1999:blog-3889219616765973387.post-7399481557536230262012-11-14T07:34:19.763-08:002012-11-14T07:34:19.763-08:00Thank you for posting this information. I needed t...Thank you for posting this information. I needed to know how to create a libname statement to connect to an Access 2010 database. This completely answered by question!Shannon & Justinhttps://www.blogger.com/profile/00960788979304429085noreply@blogger.comtag:blogger.com,1999:blog-3889219616765973387.post-91692247696974999292011-10-14T14:47:52.227-07:002011-10-14T14:47:52.227-07:00Thanks for posting this! This has been a headache...Thanks for posting this! This has been a headache all day until I found this.Robhttps://www.blogger.com/profile/09734357378165980871noreply@blogger.comtag:blogger.com,1999:blog-3889219616765973387.post-23341875502986506212011-09-04T14:29:26.383-07:002011-09-04T14:29:26.383-07:00I added this code to check if the machine is 64-bi...I added this code to check if the machine is 64-bit or not first, and then load the data:<br /><br />* --- determine if this program is running on Vista x64 or Windows 7 x64 ---;<br />%macro detect_64bit_platform();<br />%global sas64;<br />%if &sysscpl=X64_VSPRO %then %let sas64=1;<br /> %else %let sas64=0;<br />%mend detect_64bit_platform;<br />%detect_64bit_platform;<Corinna Lohttps://www.blogger.com/profile/00900594161102942245noreply@blogger.com