ACCESS DATABASE
in [SAS]
|
Prev: Trend matching
Next: Non Normal Data
From: Mary on 17 Dec 2009 15:16 Are you sure you mean .dbm? That's a file format for UNIX. Where are you planning on using the file? If you have the SAS display manager, then you should be able to get it into SAS using File...Import...then choosing the options. -Mary --- tw2(a)MAIL.COM wrote: From: Tom White <tw2(a)MAIL.COM> To: SAS-L(a)LISTSERV.UGA.EDU Subject: ACCESS DATABASE Date: Thu, 17 Dec 2009 14:58:42 -0500 Hello SAS-L, I have a .txt file about 4gb in size. It is too large to open with access. Is there any way to open it and then export it (convert it) to a .dbm file? Thanks. Tom
From: Tom White on 17 Dec 2009 16:57 I don't recall the extension for access datasets. I think it is .dbf or .dbm I wish to read a 4GB .txt file into ACCESS and then export it. Then I will read it into SAS. If I can read this delimited (|) .txt file into SAS directly that would be= great. How do I do that? Thanks tom -----Original Message----- From: Mary <mlhoward(a)AVALON.NET> To: SAS-L(a)LISTSERV.UGA.EDU Sent: Thu, Dec 17, 2009 2:16 pm Subject: Re: ACCESS DATABASE Are you sure you mean .dbm? That's a file format for UNIX. Where are you= =20 lanning on using the file? If you have the SAS display manager, then you should be able to get it int= o SAS sing File...Import...then choosing the options. -Mary -- tw2(a)MAIL.COM wrote: From: Tom White <tw2(a)MAIL.COM> o: SAS-L(a)LISTSERV.UGA.EDU ubject: ACCESS DATABASE ate: Thu, 17 Dec 2009 14:58:42 -0500 Hello SAS-L, have a .txt file about 4gb in size. t is too large to open with access. s there any way to open it and then export it (convert it) to a .dbm file? hanks. om
From: Tom Abernathy on 17 Dec 2009 17:45 Tom - It is easy to read a delimited file into SAS. Just use a data step. First define your variables, then point to the txt file with an INFILE statement and then read it with an INPUT statement. I suggest add the line IF _N_ <= 5 then list; To the program below to get a look at the first 5 lines to see what the format of the file really is. Does it have a header line? If so then add FIRSTOBS=2 to your INFILE statement to skip the header line. Do you know what the variables are? if not then read them in as long character strings and look at them to figure it out. - Tom Abernathy data bigfile; attrib var1 length=$8 label='Variable one'; attrib var2 length=8 label='Variable two'; infile 'bigfile.txt' dlm='|' truncover; input var1 var2; run; On Dec 17, 4:57 pm, t...(a)MAIL.COM (Tom White) wrote: > I don't recall the extension for access datasets. > I think it is .dbf or .dbm > I wish to read a 4GB .txt file into ACCESS and then export it. > Then I will read it into SAS. > > If I can read this delimited (|) .txt file into SAS directly that would be= > great. > How do I do that? > > Thanks > > tom > > > > -----Original Message----- > From: Mary <mlhow...(a)AVALON.NET> > To: SA...(a)LISTSERV.UGA.EDU > Sent: Thu, Dec 17, 2009 2:16 pm > Subject: Re: ACCESS DATABASE > > Are you sure you mean .dbm? That's a file format for UNIX. Where are you= > =20 > lanning on using the file? > If you have the SAS display manager, then you should be able to get it int= > o SAS > sing File...Import...then choosing the options. > -Mary > > -- t...(a)MAIL.COM wrote: > From: Tom White <t...(a)MAIL.COM> > o: SA...(a)LISTSERV.UGA.EDU > ubject: ACCESS DATABASE > ate: Thu, 17 Dec 2009 14:58:42 -0500 > Hello SAS-L, > have a .txt file about 4gb in size. > t is too large to open with access. > s there any way to open it and then export it (convert it) to a .dbm file? > hanks. > om- Hide quoted text - > > - Show quoted text -
From: Joe Matise on 17 Dec 2009 17:01 ..MDB is access. You should read it directly into SAS. You have a lot of options; the simplest, if not always most usable, is to import it with the wizard and/or PROC IMPORT: proc import file="file.whatever" out=datasetname dbms=dlm dlm='|' replace; run; or something to that effect. You can also read it in directly [more usable typically as it lets you assign formats]: data datasetname; infile 'file.whatever' dlm='|'; format var1 2.; format var2 8.; format var3 $52.; *also informats; input var1 var2 var3 $ .... ; run; -Joe On Thu, Dec 17, 2009 at 3:57 PM, Tom White <tw2(a)mail.com> wrote: > I don't recall the extension for access datasets. > I think it is .dbf or .dbm > I wish to read a 4GB .txt file into ACCESS and then export it. > Then I will read it into SAS. > > If I can read this delimited (|) .txt file into SAS directly that would be > great. > How do I do that? > > Thanks > > tom > > > -----Original Message----- > From: Mary <mlhoward(a)AVALON.NET> > To: SAS-L(a)LISTSERV.UGA.EDU > Sent: Thu, Dec 17, 2009 2:16 pm > Subject: Re: ACCESS DATABASE > > > Are you sure you mean .dbm? That's a file format for UNIX. Where are you > lanning on using the file? > If you have the SAS display manager, then you should be able to get it into > SAS > sing File...Import...then choosing the options. > -Mary > > -- tw2(a)MAIL.COM wrote: > From: Tom White <tw2(a)MAIL.COM> > o: SAS-L(a)LISTSERV.UGA.EDU > ubject: ACCESS DATABASE > ate: Thu, 17 Dec 2009 14:58:42 -0500 > Hello SAS-L, > have a .txt file about 4gb in size. > t is too large to open with access. > s there any way to open it and then export it (convert it) to a .dbm file? > hanks. > om >
From: Mary on 17 Dec 2009 18:19
So it is a pipe delimited file. I'm assuming you are not to good at coding in SAS, so just open up the SAS display manager. Choose File Choose Import Data Choose Tab Delimited file from the drop-down Browse to the file and choose it. There's an options button on that screen that should allow you to change the character imported to a pipe. Then just put in a member name on the next screen Then you just proceed and it should attempt to pull in the file. If that doesn't work, go to the log and copy the code, and then you can modify that code and run the code to try it again. To export as a Microsoft Access database, you do the same thing but this time choose File-Export Data; and the choices of types to export does include MS Access. -Mary --- tw2(a)MAIL.COM wrote: From: Tom White <tw2(a)MAIL.COM> To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: ACCESS DATABASE Date: Thu, 17 Dec 2009 16:57:37 -0500 I don't recall the extension for access datasets. I think it is .dbf or .dbm I wish to read a 4GB .txt file into ACCESS and then export it. Then I will read it into SAS. If I can read this delimited (|) .txt file into SAS directly that would be great. How do I do that? Thanks tom -----Original Message----- From: Mary <mlhoward(a)AVALON.NET> To: SAS-L(a)LISTSERV.UGA.EDU Sent: Thu, Dec 17, 2009 2:16 pm Subject: Re: ACCESS DATABASE Are you sure you mean .dbm? That's a file format for UNIX. Where are you lanning on using the file? If you have the SAS display manager, then you should be able to get it into SAS sing File...Import...then choosing the options. -Mary -- tw2(a)MAIL.COM wrote: From: Tom White <tw2(a)MAIL.COM> o: SAS-L(a)LISTSERV.UGA.EDU ubject: ACCESS DATABASE ate: Thu, 17 Dec 2009 14:58:42 -0500 Hello SAS-L, have a .txt file about 4gb in size. t is too large to open with access. s there any way to open it and then export it (convert it) to a .dbm file? hanks. om |