topic Re: accelerometer data processing issue in SAS Programming

accelerometer data processing issue

OrourkeBow — Mon, 13 Jan 2025 22:26:46 GMT

Hi,

I have existing code from older work from a previous user. This code is set up to path to files on my computer. These are in .AWC. format, specific to the accelerometer we use - the Actical.

The main issue is that SAS on demand or SAS viya for learners will not recognize my data for some reason. I can open the data as a test and see the variables and data, so it will not collect the values for some reason. The data is 2 columns, time and steps. This data has been analyzed properly before by a previous researcher, but we do not have contact with them. Plus, this was a much older version of SAS, and I cannot open our .egp Flow process on there, as it seems to not be capable with 4.3.

If you see the code, I have all my data in the "DATA" folder, ending with AWC. And the participants are coded as the following: PLA001T1 (withT1 to T3 possible), hence labelled as 8 for length.

I am also trying to export that data into xlsx (Excel), and this will not work. For clarity, I am using a Mac, but it should be fine as I am using the browser versions.

Although no data shows up in the spreadsheets, the code seems to be ok overall, but I also get this error at the end. This error comes up twice. From my searching, this is due to it making an error trying to export into excel.

ERROR: Server Name is invalid or missing.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

The entire code is attached for reference.

I am unsure if this makes any sense, but any help would be appreciated. I am a beginner, using existing code, as I was volunTOLD to do this by my supervisor lol.

Thank you in advance.

Re: accelerometer data processing issue

ChrisHemedinger — Mon, 13 Jan 2025 22:30:07 GMT

Can't speak to the rest of it, but at a glance the PROC EXPORT should have the DBMS=XLSX option, and that should solve that error.

Re: accelerometer data processing issue

OrourkeBow — Mon, 13 Jan 2025 22:33:32 GMT

I had this with the intro line at the beginning of my data, but it did not work. My data is not in excel format. From my understanding this more for input from excel?

Again, the code I have (The libname code is the only thing I added) has worked before. The only thing that should require a change is the path directory. As instructed by the previous user in the "*---*" areas. I am also very noob, so I hope this makes sense.

Re: accelerometer data processing issue

ChrisHemedinger — Tue, 14 Jan 2025 13:39:23 GMT

I only meant the part at the end should have the DBMS= option. That tells SAS what mechanism to use to write the Excel file. I realize it may not solve any of the other (main) part before that with reading your accelerometer data...

proc export data = peradult1 outfile = "&xls_path." DBMS=XLSX; run;

Re: accelerometer data processing issue

OrourkeBow — Tue, 14 Jan 2025 14:27:56 GMT

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!