topic Re: Importing .sasbat in SAS Procedures

Importing .sasbat

omega1983 — Mon, 21 Oct 2013 01:34:59 GMT

libname adhoc_vb pcfiles

path = '//gaserver/myfile.sas7bat'

server= "2233";

port = 2234;

proc import datafile = '//gaserver/myfile.sas7bat'

out = order1;

dbms =

server= "2233";

run;

I want to import ths file called myfile.sasbat. In this case what would the dbms be called or is there another way to import a file with the .sasbat file extension?

Re: Importing .sasbat

Mit — Mon, 21 Oct 2013 01:58:08 GMT

You don't need to import a sas data.
If your library is defined ok then you can open the data directly. Just check if the libname is successful.

Re: Importing .sasbat

Patrick — Mon, 21 Oct 2013 03:26:16 GMT

As Mit wrote: The data is already stored as a SAS file so you need only to define a libname to access it within your SAS program, e.g:

libname mylib '' '//gaserver';

proc print data=mylib.myfile;

run;

Re: Importing .sasbat

dnuti — Tue, 18 Nov 2014 12:57:25 GMT

I have a related question that isn't answered yet.

I also have a .sasbat file. I want to use proc import so that I don't have to list the near hundred variables in an input statement. Is there no way to get around this?

Re: Importing .sasbat

LinusH — Tue, 18 Nov 2014 13:12:13 GMT

sasbat is not a common file suffix that I'm aware of. What file type is it?

What does it look like when opened in Notepad/vi?

Re: Importing .sasbat

dnuti — Tue, 18 Nov 2014 13:13:59 GMT

It cannot be opened in anything but SAS. Otherwise it's giberish. Not an original file but I don't have access to an original file.

Re: Importing .sasbat

Kurt_Bremser — Tue, 18 Nov 2014 13:35:25 GMT

Rename it to .sas7bdat, put it into a location where you have assigned a libname, and see if it is a valid SAS dataset. If not, discard.

Re: Importing .sasbat

dnuti — Tue, 18 Nov 2014 13:51:43 GMT

It's a valid dataset.

How do I get around listing each variable name?

Re: Importing .sasbat

Kurt_Bremser — Tue, 18 Nov 2014 14:18:18 GMT

You don't need to import it, just use it.