topic Re: Open a file in SAS (Enterprise Giude) in SAS Programming

Open a file in SAS (Enterprise Giude)

costasRO — Tue, 08 Oct 2024 10:41:45 GMT

Hello SAS users,

I was sent a SAS data file that I want to open. The issue is that, when I save the file into a folder on my PC and then create a SAS library that points to this folder, SAS cannot "see" this file, the library seems empty. The extension of the file is .sas7bdat, which suggests a regular file. However, when I right clink on the file it says that it opens with "SAS Enterprise Guide 6.1", and I am not sure what this is. I want to save this file as a regular SAS file that I can access. How can I do this? I am using SAS 9.4.

Thank you Costas

Re: Open a file in SAS (Enterprise Giude)

PaigeMiller — Tue, 08 Oct 2024 11:00:59 GMT

First thing I would check is to make sure that the folder name in your LIBNAME statement is 100% correct, no spelling errors, and the proper folder name.

If that's not it, then show us a screen capture of the folder and file in your operating system and also show us your LIBNAME statement (LIBNAME statement doesn't have to be a screen capture, it can be plain text). When providing screen captures, please use the "Insert Photos" icon. Do NOT attach files.

Re: Open a file in SAS (Enterprise Giude)

yabwon — Tue, 08 Oct 2024 11:42:01 GMT

Question, is the file name in low-case letters (like file.sas7bdat) or is it in up-case letters like (like FILE.sas7bdat)?

Bart

Re: Open a file in SAS (Enterprise Giude)

costasRO — Tue, 08 Oct 2024 12:29:43 GMT

Hi,
Seems that by only changing the file name the problem is solved. It was
inddatanew_2021_final(2).sas7bdat and I changed it to inddatanew_2021_final.sas7bdat
Thanks!
Costas

Re: Open a file in SAS (Enterprise Giude)

Tom — Tue, 08 Oct 2024 16:25:07 GMT

The name of the file is the member name that SAS will use to reference it.

Member names cannot use () characters, unless you change the VALIDMEMNAME system option to EXTEND.