tag:blogger.com,1999:blog-7958828565254404797.post2071830557648796044..comments2024-03-28T07:44:59.527-07:00Comments on ListenData: How to Import Multiple Excel Files into a Single SAS DatasetDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-7958828565254404797.post-18830817025442285342024-03-01T07:37:07.467-08:002024-03-01T07:37:07.467-08:00I have fixed the code. Thanks!I have fixed the code. Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-26999406257316744782024-03-01T07:36:36.432-08:002024-03-01T07:36:36.432-08:00I have fixed the code. Thanks!I have fixed the code. Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-78127795953504594522023-05-30T06:38:04.810-07:002023-05-30T06:38:04.810-07:00By using this code, it keeps adding new lines each...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.Weslleyhttps://www.blogger.com/profile/09879987352548430427noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-42521564117767461272023-01-24T08:26:10.397-08:002023-01-24T08:26:10.397-08:00Trying to import 23 Excel files but no log errors ...Trying to import 23 Excel files but no log errors or no output Beginnerhttps://www.blogger.com/profile/14664006203445559031noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-45334738941209666622022-04-03T21:30:32.118-07:002022-04-03T21:30:32.118-07:00Why these Errors are comming in SAS studio given b...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.ANIRBAN DUTTAhttps://www.blogger.com/profile/08630369225470353619noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-41397660935778630862022-02-25T17:20:24.316-08:002022-02-25T17:20:24.316-08:00Hello, I followed above suggestion and get this er...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. Anonymoushttps://www.blogger.com/profile/15756649256646570023noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-87499583897037253572021-06-10T22:40:46.470-07:002021-06-10T22:40:46.470-07:00OTE: The infile MYFILES is:
Unnamed Pipe Acc...OTE: The infile MYFILES is:<br /> Unnamed Pipe Access Device,<br /><br /> PROCESS=dir "T:\D33Shr\SYSFCST\load forecasting<br /> EU\Test\Sandbox\PepcoDCAMonthlySummaryReagan\" /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 />Josehttps://www.blogger.com/profile/09212734425637836778noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-78908581271324834762021-06-10T22:31:57.290-07:002021-06-10T22:31:57.290-07:00OTE: The infile MYFILES is:
Unnamed Pipe Acc...OTE: The infile MYFILES is:<br /> Unnamed Pipe Access Device,<br /><br /> PROCESS=dir "T:\D33Shr\SYSFCST\load forecasting<br /> EU\Test\Sandbox\PepcoDCAMonthlySummaryReagan\" /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 />Josehttps://www.blogger.com/profile/09212734425637836778noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-12232118399993638682021-01-18T15:01:13.784-08:002021-01-18T15:01:13.784-08:00How could this be done with 14 text delimited file...How could this be done with 14 text delimited files instead of Excel files?PHILJhttps://www.blogger.com/profile/16554904565838646097noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-5173768453177382162020-02-17T11:24:59.652-08:002020-02-17T11:24:59.652-08:00The code successfully imports all 13 Excel files b...The code successfully imports all 13 Excel files but doesn't generate a data set of the all the observations. The output file reflects only the observations in the last imported file. Please advise.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-52174464792688931762019-09-27T22:49:32.953-07:002019-09-27T22:49:32.953-07:00In one of the interview, i was faced the below que...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. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-31881658659163525612019-06-11T01:03:05.253-07:002019-06-11T01:03:05.253-07:00Great! Great! Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-24191704130262033362019-06-11T00:43:10.708-07:002019-06-11T00:43:10.708-07:00now its working sirnow its working sirqanihttps://www.blogger.com/profile/06795360088796980175noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-993203656316734002019-06-10T06:54:58.885-07:002019-06-10T06:54:58.885-07:00What error you are getting?What error you are getting?Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63245513672095437242019-06-10T06:12:49.496-07:002019-06-10T06:12:49.496-07:00error coming
error coming<br />qanihttps://www.blogger.com/profile/06795360088796980175noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-28120788030530321622019-06-10T06:12:33.406-07:002019-06-10T06:12:33.406-07:00its not working sirits not working sirqanihttps://www.blogger.com/profile/06795360088796980175noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-60537918268935086002019-05-17T22:06:31.523-07:002019-05-17T22:06:31.523-07:00Thanks for providing this useful guide on importin...Thanks for providing this useful guide on importing excel files. It's really very useful. Also, I added your blog to my favourite sites list. Keep sharing. Merge Multiple Excel Fileshttps://www.synkronizer.com/compare-excel-tables-features/mergenoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-14864377280391789432017-10-12T01:22:20.224-07:002017-10-12T01:22:20.224-07:00dbms=xlsx should be dbms=excel in my case. dbms=xlsx should be dbms=excel in my case. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-37507920258225637852017-09-06T01:10:11.566-07:002017-09-06T01:10:11.566-07:00Very Nice! Awesome!Very Nice! Awesome!Anonymoushttps://www.blogger.com/profile/09882260547347730694noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-18156109001571045212017-01-09T12:11:54.501-08:002017-01-09T12:11:54.501-08:00Awesome!!!!Awesome!!!!Anonymoushttps://www.blogger.com/profile/01379742747456544081noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-27844897747871147242016-04-29T07:06:16.519-07:002016-04-29T07:06:16.519-07:00Can you update the code to only include the first ...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?Anonymoushttps://www.blogger.com/profile/10628718275026224790noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-19591893247189298882016-02-01T14:04:48.930-08:002016-02-01T14:04:48.930-08:00How can we use the code when some variables may be...How can we use the code when some variables may be different (or some files have some variables that others don't have).<br />ThanksAnonymoushttps://www.blogger.com/profile/16181283427184967748noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-77235023418234491042015-11-20T08:06:54.989-08:002015-11-20T08:06:54.989-08:00Please start with introduction to macros.Please start with introduction to macros.Anonymoushttps://www.blogger.com/profile/14455518312933507057noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-8742220986333710562015-08-26T01:00:15.580-07:002015-08-26T01:00:15.580-07:00Hi, Can you update a article on basic introduction...Hi, Can you update a article on basic introduction to sas macros?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10065963906246046122015-05-28T05:40:08.768-07:002015-05-28T05:40:08.768-07:00Great Work!!Great Work!!Anonymousnoreply@blogger.com