can i open sas7bdat file in sas eg 6.1

[AnandSahu]

hi,

can we open a sas7bdat file in SAS EG 6.1.

regards

anand

[Kurt_Bremser]

Just tested it. Yes.

[Reeza]

Yes, if you cantt you'll have to provide more details. If EG is on the server and the dataset is on your desktop their may be issues.

[AnandSahu]

Reeza,

yes, my EG is connected to server and the .sas7bdat file is in my desktop.

In this case, how can I access these files??

[naveen_srini]

Hi Good afternoon, Understanding that your EG is connected to the metadata server using your credentials and your dataset resides in the client desktop.I am using SAS EG 6.1 right now at office and I have just tried the same and it worked fine. How I did was, 1- Right click on the icon of the dataset 2. you will see open/open with SAS Enterprise guide 6.1 3 Clicking that should comfortably open. Well at least it did for me:)

[jakarman]

Yup naveen that will also work. What happens is it will read the sas-dataset using Eguide at Windows convert that int a sas-datastep with datlines embedded so it can be uploaded in character mode than it runs that dataset at sas-server side and opening that dataset at the server. I do not like all those conversions/overhead.

[naveen_srini]

Oh yes, That's true, I fully agree with you:)

[Kurt_Bremser]

I simply did File - Open - Data and navigated to the .sas7bdat I wanted to open. EG did open it.

Please provide more information if that does not work for you.

[jakarman]

Yes you can drag drop it to the server (from windows explorer) into the files-section seen with Eguide of your app-server.

This will start a binary transfer (part of XCEED libraries) from windows to you server.
Only with the cripple education (UE) version of Eguide this will not work. There will be a hurdle when you have a virtualized desktop. In that case you have to copy/move your data from your real one to your virtualized one first.

Please do no use the sas7bdat dataset form to files section but copy that to a location covered by the libnames section.  (RDBMS approach instead of Excel mode)

When your server is a Unix type, do not rename/use your file with upcase chars as that will make that dataset inaccessible by SAS.  

[ChrisHemedinger]

As others have answered, SAS Enterprise Guide can read your sas7bdat file from your desktop even if you don't have SAS installed.  Drag-and-drop the file onto your open project or else use File->Open.  SAS Enterprise Guide will use the SAS Local Data Provider to read/display the contents of your data set even when you're not connected to a SAS environment.

To efficiently move your local SAS data set to the server for analysis, use the Tasks->Data->Upload Data Files to Server task.  That will capture the upload step into your process flow for a repeatable process.

Chris

[jakarman]

@Chris there are tasks like that one you have mentioned that are getting personalized in the EGuide project (caused by uri's and home locations) By that imposing some difficulties when handing over to another person.  My suggestion would be improving by minimizing those dependicies and more easily getting changed when needed.