Desktop productivity for business analysts and programmers

can i open sas7bdat file in sas eg 6.1

Reply
Frequent Contributor
Posts: 81

can i open sas7bdat file in sas eg 6.1

hi,

can we open a sas7bdat file in SAS EG 6.1.

regards

anand

Esteemed Advisor
Posts: 6,646

Re: can i open sas7bdat file in sas eg 6.1

Just tested it. Yes.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Grand Advisor
Posts: 17,329

Re: can i open sas7bdat file in sas eg 6.1

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.

Frequent Contributor
Posts: 81

Re: can i open sas7bdat file in sas eg 6.1

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??

Frequent Contributor
Posts: 115

Re: can i open sas7bdat file in sas eg 6.1

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 meSmiley Happy

Valued Guide
Posts: 3,206

Re: can i open sas7bdat file in sas eg 6.1

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.

---->-- ja karman --<-----
Frequent Contributor
Posts: 115

Re: can i open sas7bdat file in sas eg 6.1

Oh yes, That's true, I fully agree with youSmiley Happy

Esteemed Advisor
Posts: 6,646

Re: can i open sas7bdat file in sas eg 6.1

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Valued Guide
Posts: 3,206

Re: can i open sas7bdat file in sas eg 6.1

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.  

---->-- ja karman --<-----
Community Manager
Posts: 2,693

Re: can i open sas7bdat file in sas eg 6.1

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

Valued Guide
Posts: 3,206

Re: can i open sas7bdat file in sas eg 6.1

@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.

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 10 replies
  • 746 views
  • 0 likes
  • 6 in conversation