Cannot process my accelerometer data

[OrourkeBow]

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. 

[ballardw]

Please do not make multiple posts with essentially identical information on this forum.

If the question is in the wrong section we can move the question if needed. This question is more related to INPUT/OUTPUT or general programming as you have not gotten to the point where you have a data set to do any statistical analysis and would belong in the general programming.

Asking the same question repeatedly leads to fragments of the problem scattered across the multiple posts. Such information as in one of your threads on this topic that the code is 10+ years old is important as the environment you are trying to run in did not exist then. So it is very likely that changes need to be implemented. Note that files written using a WINDOWS based file format have a different end of line character than UNIX uses and so the INFILE statements likely need to address the WINDOW to UNIX end of line difference as the web-based version currently us a UNIX based system.

Questions related to reading specific files should, if at all possible include a copy of the file. That way we can attempt to run the code an see why results aren't as expected.

[OrourkeBow]

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.