I have attached a few pictures to help explain.  But I wanted to have everything I get essentially but in Excel. Also, I will put up a screenshot of old data that was exported long ago. This is the information I need.    But following the code logic you presented proc export dbms=xlsx data=mylib.PLADATA file='/home/u64122702/Output/paxraw.xlsx' replace; file='/home/u64122702/Output/perday.xlsx' replace; file='/home/u64122702/Output/perminute.xlsx' replace; file='/home/u64122702/Output/summary.xlsx' replace; file='/home/u64122702/Output/reports2/_invalid_data_characters.xlsx' replace; file='/home/u64122702/Output/reports2/_invalid_inten_step.xlsx' replace; run; could I add code like this? I also separated the code into 4 parts, based on how its set up, like step 1-4, with each as a separate program.    When I run the code above (even with just per day) I get an error for the mylib command - see log below:  OTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 251 file='/home/u64122702/Output/perday.xlsx' replace; ____ 180 252 file='/home/u64122702/Output/perminute.xlsx' replace; ____ 180 253 file='/home/u64122702/Output/summary.xlsx' replace; ____ 180 254 file='/home/u64122702/Output/reports2/_invalid_data_characters.xlsx' replace; ____ 180 255 file='/home/u64122702/Output/reports2/_invalid_inten_step.xlsx' replace; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 256 257 run; ERROR: Libref MYLIB is not assigned. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 914.37k OS Memory 27280.00k Timestamp 01/16/2025 07:41:35 PM Step Count 391 Switch Count 0 Page Faults 0 Page Reclaims 150 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 I will put a screenshot of the directory. I made a "reports2" folder to send this testing there and the pic of the output I need (and they want in a rush, ffs lol).    Thanks!!! ... View more

would i need to this for all the files? I would need the summary as a priority, but all of it would be good for storage and to keep locally - and delete later for data plan considerations. But i would also need the info in the PLA data and My person data, that only download when i click them ... View more

Hey,   It seems everything is going well, and all the data appears to be in the output, and data is being analyzed, so that is great!    But the next step would be to get everything out into Excel files. I am unsure how to do this. I have attached the log just in case any thing is clear there as to why. The files that come out in the reports folder, as the code dictates, are .xls.bak. So when I download it, they do not open in Excel.    I have also attached a picture of the file directory to depict it better. Please let me know what output I am getting.  Again, thank you so much for your time!        ... View more

Oh okay. Sorry about that. First-time user overall. I was not sure how siloed the topics were. It seems data science got me the best replies. You can delete any posts that have not got replies. ... View more

However, i still dont think it getting all thew participants. I am unsure where the data is actually going and how. to download into excel, as the new files are .xls.bak ... View more

I THINK IT WORKED - Your a legend ... View more

I did as you mentioned.    Attached is a screen shot of the second "stopped reading". It is at the very first file of the bunch. But they all similar. ... View more

so wjere should i move this line>? ... View more

Where is this stop located? I dont understand, sorry lol ... View more

would i still need the code you suggested above in your previous comment, and if so, where would I put it? I am also confused, as quikbluefish comments and yours, should I use both suggestions, like are you building off there recommendations as well? ... View more

Aha. The authors of this are the original coders, so we are in contact with them. But gain, since this was 2014, they have far moved on. This is accelerometer is not used much anymore, because of this code nightmare lol. We now use newer ones that we can use R packages, and the software gives excel output so life is much easier. But i have been given the awesome tasks of going back and scanning data for a study so this is where the issues coming from ... View more

This change in slash only applies to the file names? or the entire file lol. And replace with "/.\"? They do end with capilize AWC, so I will change that. If i add the code suggested, where should I add it? Also thanks you so much for the help! ... View more

ya, i can see the data in text/notepad files. Where should I out this line of code? at the end? The files end with "AWC" capitalized, ... View more

Is this something that can be changed? If I were to just run this on a Windows PC would it work based on the logic? Could I control F or find these spots easily? Would the awcm thing matter when it's on the cloud server? The code was originally made for old SAS version on some old PC in like 2014 lmao. Is this fixable? Or should i look to find a PC with SAS on it, but then I would need to physically have the files there vs just using the on demand, but on a PC? ... View more

Okay, I understand. Thanks! That addition did work when it came to Excel output. But yes, no data shows up, though! Since I got the other issues, at least that helped! ... View more