BookmarkSubscribeRSS Feed
OrourkeBow
Obsidian | Level 7

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. 

4 REPLIES 4
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
OrourkeBow
Obsidian | Level 7

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. 

ChrisHemedinger
Community Manager

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;

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
OrourkeBow
Obsidian | Level 7
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!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1766 views
  • 0 likes
  • 2 in conversation