f



Re: MS Access and SAS datasets #2

Hi David -

I agree with Howard that CNTLOUT will give you your formats to develop
lookup tables in Access.   Alternately if your data isn't large and you
don't care about normal form, you could process your variables through your
formats with put statements and create parallel formatted data.

In v9 there's VLABEL, VLABELX, and VARLABEL, etc.  You can use VLABEL and
array all your _numeric_ and then _character_ columns and create a label
dataset.

There's also the data dictionary which you can query and use the into:
command to load a macro, or just dump the labels in a dataset.

Personally, I like to use "options VALIDVARNAME=ANY;" and rename my
variables as their labels before I port data to external databases, but I'm
an analyst, not a programmer, and I can hear several mavens groaning in the
distance as I write this. ;-)

Good luck and hth -

Paul Choate
DDS Data Extraction
(916) 654-2160


On Mon, 23 May 2005 14:01:18 -0800, David Neal <afdbn@UAA.ALASKA.EDU> wrote:

>I'm trying to move several SAS datasets to a single MS Access database.
>When I use proc copy to move the data, I get the following note:
>
>
>
>NOTE: Copying SCFSAS.PT_MISC to SCFFAS.PT_MISC (memtype=DATA).
>
>NOTE: SAS variable labels, formats, and lengths are not written to DBMS
>tables.
>
>
>
>My problem is that I'm interested in keeping the variable labels and the
>formats as well.  Is it possible for SAS to automatically create
the "lookup
>tables" from the formats?  Also, is there a way to keep the variable labels
>when I move from SAS to Access?
>
>
>
>David Neal
0
pchoate (2538)
5/24/2005 3:43:18 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
425 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

Re: SAS/ACCESS
DBMAX_TEXT does the trick; thank you all who helped! Matt -----Original Message----- From: Jack Hamilton [mailto:jfh@stanfordalumni.org] Sent: Sat 1/24/2009 1:42 AM To: Pettis, Matthew (Prof II&RS) Cc: SAS-L@LISTSERV.UGA.EDU Subject: Re: [SAS-L] SAS/ACCESS - Oracle: setting field lengths in SAS datasets returned from passthrough Does the DBMAX_TEXT option do what you want? http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a003113591.htm -- Jack Hamilton jfh@alumni.stanford.org Videtis illam spirare libertatis auram On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote: > Hi, > > > > I have a CLOB coming back from an Oracle passthrough query that is > >1024 > in length. How do I specify that my receiving variable in a SAS > dataset > be longer than 1024 characters to accommodate this? By default, I get > SAS thinking that this is 1024 characters, when it is really a CLOB > and > I want to set some large default length on this variable length... > > > > Thanks, > Matt ...

Re: combine n SAS datasets in to one SAS dataset. #2
On Thu, 17 Jan 2008 12:06:01 -0800, stulkem@YAHOO.COM wrote: >Thanks for your help in advance! > >I have hundreds of SAS datasets that I want to combine into one SAS >dataset. > >For example, I want to set file20070101.sas7bdat - >file20071231.sas7bdat (365 total files) into >file_history.sas7bdat. > >How can I write this into a macro or array or whatever will work so I >don't have to write each individual file name?? > >Thanks again! > >Mark You must provide some rule or process which SAS can use to discover the names of the data sets to be processed. Here is how I might deal with the example (one file for each day of a calendar year): data _null_; call execute('proc datasets library=mylib nolist;'); call execute('delete file_history;'); call execute('run;'); do day = '01jan2007'd to '31dec2007'd; call execute('append base=mylib.file_history data=mylib.file' || put(day,yymmddn8.) || ';'); end; call execute('quit;'); run; ...

Re: How to access automatically in SAS a MS Access table name #2
Hi Jean, It looks like your problem is that you've got a quote in a table name: Additional'n=20 If it is possible to rename that table, that might work. =20 Also, if you use the import feature in SAS, it will write code for you = that you can save and put in a program- you might try that to see if it = can handle this kind of file name. I'd rename the table in Access, = though- a quote in a table name is likely to contiously cause you = problems. -Mary ----- Original Message -----=20 From: JKamgang@Yahoo.com=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Wednesday, January 16, 2008 11:31 AM Subject: How to access automatically in SAS a MS Access table name = which has more than 32 characters? Dear All, Happy New Year , Please, I need your help in figuring out how to access in SAS a MS Access table name which has more than 32 characters. As this program merges 5 databases, I need to have almost everything automated. That's why I don't want to rename manually the table names. Please find the program below. Thanks in advance for your kind assistance, Jean Baptiste The program: - - - options VALIDVARNAME=3DANY ; libname DBsource access 'S:\Data Management\External\Projects\MTCT-Plus\MTCT-Plus November 2007 Data\Programs\Data\MTCT-PlusData All.mdb'; /* Creating the Pediatric HIV result information additional */ data* pedResultadd ; set dbsource.'tblInfantHIVTest...

Re: Deleting SAS Data from a SAS DATASET #2
Chandra - this isn't my expertise area - I'm sure others may have better ideas but I'll make three comments. If your datasets have a large number of variables, in your datastep method a WHERE clause will be more efficient - the IF statement causes each record to be fully read before it can be selected for deletion. A WHERE clause would only read the single variable in the case of records that meet the criteria for deletion. Data prod.Master_date; set prod.master_date; where snap_dt ne "&end_dt"d; run; You probably would be better off changing your data model though - my first thought would to be to store your data as separate yearly or monthly files and then access them with a view of the past two years or 24 months. With each month or year you would delete the oldest file and change the view one time period forward. *set up the data; data time1 time2 time3 time4; do i = 1 to 100; do t = 1 to 4; if t=1 then output time1; if t=2 then output time2; if t=3 then output time3; if t=4 then output time4; end; end; run; *three successive example views; data filet1 / view=filet1; set time1 time2; run; data filet2 / view=filet2; set time2 time3; run; data filet3 / view=filet3; set time3 time4; run; One more thought - since the data are appended - if the file is not reordered and you have the record counts from each append - then you can use firsto...

Re: SAS
Chandu, ken, To be explicit start at http://support.sas.com/rnd/scalability/spde/index.html Russ Lavery and I have a NESUG Paper "An Annotated Guide: The New (8.2), Free & Fast SPDE Data Engine". It will be availiable at http://www.nesug.org/ whenever everyone has general access to papers. Ian Whitlock ================= Date: Mon, 3 Jul 2006 12:40:24 -0400 Reply-To: evilpettingzoo97@AOL.COM Sender: "SAS(r) Discussion" From: Ken Borowiak <evilpettingzoo97@AOL.COM> Subject: Re: SAS - 9; Partition of SAS Datasets. Comments: To: chandu.isi@GMAIL.COM In-Reply-To: <1151942580.122486.98030@v61g2000cwv.googlegroups.com> Content-Type: text/plain; charset="us-ascii"; format=flowed Chandu, You should be able to find some info in the SPD Engine section of the on-line documentation. HTH, Ken -----Original Message----- From: chandu.isi@GMAIL.COM To: SAS-L Sent: Mon, 3 Jul 2006 09:03:00 -0700 Subject: SAS - 9; Partition of SAS Datasets. Hi All, Recently I heared from some of my friends...that SAS - 9 supports PARTITION of SAS datasets. I tried for getting syntax and some details, but couldn't able to get. Is anyone has any idea about the partitions of SAS datasets, if so can any one help me out on this? Thanks in advance. Chandu. ...

Re: MS Access and SAS datasets
Use PROC FORMAT with the CNTLOUT option to dump your formats. I don't know about the labels. Access has a "Description" field in its metadata structure, so it's reasonable to expect the labels to end up there. On Mon, 23 May 2005 14:01:18 -0800, David Neal <afdbn@UAA.ALASKA.EDU> wrote: >I'm trying to move several SAS datasets to a single MS Access database. >When I use proc copy to move the data, I get the following note: > > > >NOTE: Copying SCFSAS.PT_MISC to SCFFAS.PT_MISC (memtype=DATA). > >NOTE: SAS variable labels, formats, and lengths are not written to DBMS >tables. > > > >My problem is that I'm interested in keeping the variable labels and the >formats as well. Is it possible for SAS to automatically create the "lookup >tables" from the formats? Also, is there a way to keep the variable labels >when I move from SAS to Access? > > > >David Neal ...

Re: SAS and MS Access #2
On Wed, 5 May 2004 23:33:43 -0400, Peter Hruby <hrubyp@SYMPATICO.CA> wrote: >Hi SAS-L, > >I am wondering what choice do I have to access tables in MS Access datbase. >Can I use SAS/Access to ODBC or SAS/Access to PC Files or DDE or WB scripts? >I appreciate any experience and examples. Hi, Peter, If you have SAS/Access OLE DB, then it gives you more control. The following code shows that you can use an access table as if it is a sas dataset. If field name has embedded blanks, you can use something like, 'field name'n as the variable name. dbmax_text dataset option handles long text fields (>254 or >1000, I can't remember exactly) or memo field. HTH. Cheers, Chang libname myMdb oledb provider = "Microsoft.Jet.OLEDB.4.0" properties=('Data Source'='c:\my.mdb') preserve_tab_names=yes ; proc freq data=myMdb.myTable(dbmax_text=32767); tables myField/list missing; run; libname myMdb clear; ...

Re: SAS Macro to delete a SAS dataset #2 313487
I too like(d) PROC DELETE. When I used it I was forced to remove it and use PROC DATASETS because PROC DELETE is not documented. Also, but I have not tested it. How does it work with indexed data sets, audit trails, generation data groups, views, etc.? I don't worry much about deleting, "all" of my programs run in batch and are obsolete as soon as they are written. On 12/3/09, Fehd, Ronald J. (CDC/CCHIS/NCPHI) <rjf2@cdc.gov> wrote: > > From: SAS Techies > > Subject: SAS Macro to delete a SAS dataset > > > > Here's a simple SAS...

Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS. Gerhard On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM> wrote: >Is it possible to read a sas dataset NOT using sas and have >observations and variables etc. rather than having meaningless chunks >of text? ...

Re: Using SAS with large datasets (linking SAS and Access)
I have very little experience with using this but I have found that if you have SAS Access for PC Products licensed, just as you can issue a libname statement pointing to an Excel workbook, you can also issue one for an Access database. Try doing this and then look at your SAS explorer window where you will see an icon for the Access file and will then be able to look at the Access tables as if they were SAS data sets. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 ben.powell@CLA.CO .UK Sent by: "SAS(r) To Discussion" SAS-L@LISTSERV.UGA.EDU <SAS-L@LISTSERV.U cc GA.EDU> Subject Re: Using SAS with large datasets 06/23/2008 06:01 AM Please respond to ben.powell@CLA.CO .UK If you haven't already, export the data out of Access asap as mdb operations tend to be several orders of magnitude slower than SAS. Export to tab or csv and import into SAS. The export procedure from Access is relatively painless. If you've already done that and are still facing problems you should provide more info on variabl...

Re: MS Access and SAS datasets #9
Howard, I completely agree on fixing the normalization issue. Oftentimes though it is something that has to be done later. SQL Server Express has the .NET CLR built-in which means that you can use most .NET code in the SQL expression. Regardless of whether this is a proprietary extension (which it is...a LOT), Access is a less than optimal database. However, it will probably work as you suggest with some work on normalizing the structure. Thanks, Alan Savian "Bridging SAS and Microsoft Technologies" -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Howard Schreier <hs AT dc-sug DOT org> Sent: Tuesday, May 24, 2005 8:48 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MS Access and SAS datasets Does SQL Server Express have a lot of proprietary extensions to the SQL language which provide array processing and the like? If not, the column capacity may be more a curse than a blessing. I don't know the specifics of David's project, but based on experience I suspect that a lot of normalization is possible, and that if it is done, even the capacity of Access will be far more than adequate. On Tue, 24 May 2005 20:07:03 -0600, Alan Churchill <SASL001@SAVIAN.NET> wrote: >David, > >I believe SQL Server Express (which is free) can handle 1024 columns. You >may want to consider that approach if you have to move it anyway. > >Thanks, >Alan > >Savian >"Bridging SAS and Microsoft...

Re: MS Access and SAS datasets #7
David, I believe SQL Server Express (which is free) can handle 1024 columns. You may want to consider that approach if you have to move it anyway. Thanks, Alan Savian "Bridging SAS and Microsoft Technologies" -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David Neal Sent: Tuesday, May 24, 2005 6:54 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MS Access and SAS datasets You are right, the "slightly" was an understatement on my part.(I guess I was being nice.) I believe ACCESS is limited to 256 (or 255 I forget which) columns so I am required to do a bit of reshaping anyway. I will be working with(reshaping) the data in SAS and then move it into ACCESS. I feel much more comfortable tweaking it in SAS and then moving it to ACCESS. David -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Howard Schreier <hs AT dc-sug DOT org> Sent: Tuesday, May 24, 2005 5:26 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MS Access and SAS datasets I suspect that you don't need a "slightly" different approach. You probably need a significantly different one. Wide tables are clumsy to work with in SAS, but I think in Access the problems will be much more severe. I would think that the occasion of a port from one platform to another provides the opportunity to reshape and streamline. You will probably find it easier to do this before porting, rather than after. ...

Re: MS Access and SAS datasets #8
Does SQL Server Express have a lot of proprietary extensions to the SQL language which provide array processing and the like? If not, the column capacity may be more a curse than a blessing. I don't know the specifics of David's project, but based on experience I suspect that a lot of normalization is possible, and that if it is done, even the capacity of Access will be far more than adequate. On Tue, 24 May 2005 20:07:03 -0600, Alan Churchill <SASL001@SAVIAN.NET> wrote: >David, > >I believe SQL Server Express (which is free) can handle 1024 columns. You >may want to consider that approach if you have to move it anyway. > >Thanks, >Alan > >Savian >"Bridging SAS and Microsoft Technologies" > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David >Neal >Sent: Tuesday, May 24, 2005 6:54 PM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: MS Access and SAS datasets > >You are right, the "slightly" was an understatement on my part.(I guess I >was being nice.) >I believe ACCESS is limited to 256 (or 255 I forget which) columns so I am >required to do a bit of reshaping anyway. I will be working with (reshaping) >the data in SAS and then move it into ACCESS. I feel much more comfortable >tweaking it in SAS and then moving it to ACCESS. > >David > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTS...

Re: MS Access and SAS datasets #6
You are right, the "slightly" was an understatement on my part.(I guess I was being nice.) I believe ACCESS is limited to 256 (or 255 I forget which) columns so I am required to do a bit of reshaping anyway. I will be working with(reshaping) the data in SAS and then move it into ACCESS. I feel much more comfortable tweaking it in SAS and then moving it to ACCESS. David -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Howard Schreier <hs AT dc-sug DOT org> Sent: Tuesday, May 24, 2005 5:26 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MS Access and SAS datasets I suspect that you don't need a "slightly" different approach. You probably need a significantly different one. Wide tables are clumsy to work with in SAS, but I think in Access the problems will be much more severe. I would think that the occasion of a port from one platform to another provides the opportunity to reshape and streamline. You will probably find it easier to do this before porting, rather than after. On Tue, 24 May 2005 09:26:21 -0800, David Neal <afdbn@UAA.ALASKA.EDU> wrote: >Thanks for the input. Unfortunately, the datasets are quite wide. One >of them, for example, has over 1000 variables (columns). Had I been >involved with the creation of the initial SAS datasets, I would have >suggested a slightly different approach. Since this wasn't the case, >I'm stuck working with things the way they...

Re: MS Access and SAS datasets #4
MS Access also has a CAPTION field that behaves more like a SAS variable label. However, I have not found a way to write to that field from SAS. Ed Edward Heaton, SAS Senior Systems Analyst, Westat (An Employee-Owned Research Corporation), 1600 Research Boulevard, RW-3541, Rockville, MD 20850-3195 Voice: (301) 610-4818 Fax: (301) 610-5128 mailto:EdHeaton@Westat.com http://www.Westat.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Howard Schreier <hs AT dc-sug DOT org> Sent: Tuesday, May 24, 2005 11:21 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MS Access and SAS datasets Use PROC FORMAT with the CNTLOUT option to dump your formats. I don't know about the labels. Access has a "Description" field in its metadata structure, so it's reasonable to expect the labels to end up there. On Mon, 23 May 2005 14:01:18 -0800, David Neal <afdbn@UAA.ALASKA.EDU> wrote: >I'm trying to move several SAS datasets to a single MS Access database. >When I use proc copy to move the data, I get the following note: > > > >NOTE: Copying SCFSAS.PT_MISC to SCFFAS.PT_MISC (memtype=DATA). > >NOTE: SAS variable labels, formats, and lengths are not written to DBMS >tables. > > > >My problem is that I'm interested in keeping the variable labels and >the formats as well. Is it possible for SAS to automatically create the "lookup >ta...

Re: fail to access the SAS dataset #2
Yu, Is it possible that the file had been saved with a different engine than the one you are currently using? If so, then you would have to specify the appropriate engine when assigning the libname (e.g., libname D2 V6 "c:\oldv6files";). HTH, Art ------- On Mon, 8 May 2006 17:26:05 -0400, Yu Zhang <zhangyu05@GMAIL.COM> wrote: >Dear All, > >I couldn't find a SAS dataset in SAS explorer window or access it within a >datastep. The error in LOG window is: > >ERROR: File D2.STATUS0506.DATA does not exist. > >However, the dataset is in the folder "D2" specified. For some reason, SAS >won't recognize it. >Can someone help me out, Please? ...

Re: MS Access and SAS datasets #3
Thanks for the input. Unfortunately, the datasets are quite wide. One of them, for example, has over 1000 variables (columns). Had I been involved with the creation of the initial SAS datasets, I would have suggested a slightly different approach. Since this wasn't the case, I'm stuck working with things the way they are. To complicate things, ACCESS won't handle tables that wide so I'm having to mess with he data anyway. Your (and Howard's) suggestions will at least get me going on the right path. (Maybe I'll just round up some "slave" labor, AKA a graduate student, to set up all the lookup tables in ACCESS.) Thanks again David Neal Choate, Paul@DDS wrote: > Hi David - > > I agree with Howard that CNTLOUT will give you your formats to develop > lookup tables in Access. Alternately if your data isn't large and you > don't care about normal form, you could process your variables through your > formats with put statements and create parallel formatted data. > > In v9 there's VLABEL, VLABELX, and VARLABEL, etc. You can use VLABEL and > array all your _numeric_ and then _character_ columns and create a label > dataset. > > There's also the data dictionary which you can query and use the into: > command to load a macro, or just dump the labels in a dataset. > > Personally, I like to use "options VALIDVARNAME=ANY;" and rename my > variables as their labels before...

Re: MS Access and SAS datasets #5
I suspect that you don't need a "slightly" different approach. You probably need a significantly different one. Wide tables are clumsy to work with in SAS, but I think in Access the problems will be much more severe. I would think that the occasion of a port from one platform to another provides the opportunity to reshape and streamline. You will probably find it easier to do this before porting, rather than after. On Tue, 24 May 2005 09:26:21 -0800, David Neal <afdbn@UAA.ALASKA.EDU> wrote: >Thanks for the input. Unfortunately, the datasets are quite wide. One >of them, for example, has over 1000 variables (columns). Had I been >involved with the creation of the initial SAS datasets, I would have >suggested a slightly different approach. Since this wasn't the case, >I'm stuck working with things the way they are. To complicate things, >ACCESS won't handle tables that wide so I'm having to mess with he data >anyway. Your (and Howard's) suggestions will at least get me going on >the right path. (Maybe I'll just round up some "slave" labor, AKA a >graduate student, to set up all the lookup tables in ACCESS.) > >Thanks again > >David Neal > >Choate, Paul@DDS wrote: >> Hi David - >> >> I agree with Howard that CNTLOUT will give you your formats to develop >> lookup tables in Access. Alternately if your data isn't large and you >> don'...

Re: SAS/ACCESS
Does the DBMAX_TEXT option do what you want? http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a003113591.htm -- Jack Hamilton jfh@alumni.stanford.org Videtis illam spirare libertatis auram On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote: > Hi, > > > > I have a CLOB coming back from an Oracle passthrough query that is > >1024 > in length. How do I specify that my receiving variable in a SAS > dataset > be longer than 1024 characters to accommodate this? By default, I get > SAS thinking that this is 1024 characters, when it is really a CLOB > and > I want to set some large default length on this variable length... > > > > Thanks, > Matt ...

Re: Storing SAS-programs and -macros in SAS-datasets on a HOST-platform #2
How about catalogs? They are already used for macros. I believe other code could be used via %INCLUDE. On Tue, 5 Oct 2004 09:57:46 -0700, Jesper Sahner <jespersahner@HOTMAIL.COM> wrote: >Hi! > >Ususally SAS-programs and -macros on a HOST-platform are stored in >PDS-datasets, which are not SAS-datasets. However I am interested in >storing programs in a regular SAS-dataset in the same way tables and >formats are stored. Is that possible? (this should be easy in SCL - >which I am not familiar with - but how do you do it in Base-SAS? > >I believe that storing pro...

Re: How to access a MS SQL file in SAS? #2
Hi Mayukh, You can read and write the tables directly. You can read queries directly. * READ MSACCESS TABLES FROM PC SAS ; %let mdbname=c:\temp\db1.mdb; * parse out mdb path ; %let xtmp=%sysfunc(reverse(%trim(%left(&mdbname)))); %let xtmp=%substr(&xtmp,%eval(%index(&xtmp,\)+1)); %let mdbpath=%sysfunc(reverse(&xtmp)); * build ODBC connection string ; %let noprompt=DRIVER=Microsoft Access Driver (*.mdb); %let noprompt=&noprompt%str(;)UID=admin; %let noprompt=&noprompt%str(;)UserCommitSync=Yes; %let noprompt=&noprompt%str(;)Threads=3; %let noprompt=&noprompt%str(;)SafeTransactions=0; %let noprompt=&noprompt%str(;)PageTimeout=5; %let noprompt=&noprompt%str(;)MaxScanRows=8; %let noprompt=&noprompt%str(;)MaxBufferSize=2048; %let noprompt=&noprompt%str(;)ReadOnly=0; %let noprompt=&noprompt%str(;)FIL=MS Access; %let noprompt=&noprompt%str(;)DefaultDir=&mdbpath; %let noprompt=&noprompt%str(;)DBQ=&mdbname; %let noprompt=%BQUOTE(&noprompt); * assign library reference ; LIBNAME mymdb ODBC NOPROMPT="&noprompt"; * sample using datastep ; data table1; set mymdb.Table1; run; * sample using datastep ; data tablefromquery1; set mymdb.Query1; run; * sample using SQL ; proc sql; create table table1 as select * from mymdb.table1 ; quit; * sample using macro ; %macro GetTable(nm); proc sql; create table &nm as select * from mymdb.&nm ...

Re: Import MS Access data to SAS #2
some code copied from my blog and hope it useful: *********************************************************** * METHODS TO READ DATA FROM ACCESS DATABASE INTO SAS * * DATE : JUL-30, 2005 * ***********************************************************; *********************************************************** * METHOD 1: OLEDB (SAS/ACCESS INTERFACE REQUIRED) * ***********************************************************; libname OLEmdb oledb init_string=3D"Provider =3D Microsoft.Jet.OLEDB.4.0; Data Source=3D c:\temp\demo.mdb"; data demo; set OLEmdb.tblDemo; run; libname _all_ clear; *********************************************************** * METHOD 2: PROC IMPORT * ***********************************************************; proc import table =3D "tblDemo" out =3D demo dbms =3D access; database=3D"c:\temp\demo.mdb"; run; *********************************************************** * METHOD 3: ODBC (ODBC DRIVER REQUIRED) * ***********************************************************; libname ODBCmdb odbc complete =3D "DSN=3DMS Access Database; DBQ=3DC:\temp\demo.mdb"; data demo; set ODBCmdb.tblDemo; run; libname _all_ clear; *********************************************************** * END OF CODE * ***********************************************************; On 3/24/06, Guibo Xing <gx7656@hotmail.com> wrote: > > Hi all, > > What is a good way to transfer MA Access data to SAS. I used proc import > (or > ...

Re: Exporting SAS Dataset to Access
Hi Dearnne, Here are several alternatives: * CONNECT TO MSACCESS TABLES FROM PC SAS ; %let mdbname=c:\temp\db1.mdb; * parse out mdb path ; %let xtmp=%sysfunc(reverse(%trim(%left(&mdbname)))); %let xtmp=%substr(&xtmp,%eval(%index(&xtmp,\)+1)); %let mdbpath=%sysfunc(reverse(&xtmp)); * build ODBC connection string ; %let noprompt=DRIVER=Microsoft Access Driver (*.mdb); %let noprompt=&noprompt%str(;)UID=admin; %let noprompt=&noprompt%str(;)UserCommitSync=Yes; %let noprompt=&noprompt%str(;)Threads=3; %let noprompt=&noprompt%str(;)SafeTransactions=0; %let noprompt=&noprompt%str(;)PageTimeout=5; %let noprompt=&noprompt%str(;)MaxScanRows=8; %let noprompt=&noprompt%str(;)MaxBufferSize=2048; %let noprompt=&noprompt%str(;)ReadOnly=0; %let noprompt=&noprompt%str(;)FIL=MS Access; %let noprompt=&noprompt%str(;)DefaultDir=&mdbpath; %let noprompt=&noprompt%str(;)DBQ=&mdbname; %let noprompt=%BQUOTE(&noprompt); * assign library reference ; libname mymdb ODBC NOPROMPT="&noprompt"; * create sample table in MSAccess using datastep ; data mymdb.Table1; name='Barney ';output; name='Fred ';output; name='BamBam ';output; run; * create a SAS dataset to append with ; data BedrockLadies; name='Wilma ';output; name='Betty ';output; name='Pebbles';output; run; * append with a PROC ; proc append base=mymdb....

Re: SAS/MS Experts: Pass Protecting Excel Sheet Created By SAS #2
SAS-Xperts: I'd like to publicly acknowledge the following SAS-L members for there assistance concerning my inquiry about password protecting an Excel spreadsheet: Mark Terjeson (MTerjeson@Russell.Com) Data _NULL_ (datanull@gmail) Howard Schreier (Howard Schreier <hs AT dc-sug DOT org>) Both the mysterious Data _NULL_ and Howard (along with SI Tech support) suggested the DDE path. Data _NULL_ sent sample code, which I was not able to successfully run - I'm not at all Excel savvy, which is more than likely the cause. Mark noted some changes coming down the line from M$, Excel Services that might be helpful. I probably should have clarified the goal was to protect the Excel spread sheet, it didn't have to be done using Excel's password protection. To that end, and the light bulb clicking on, zipping the Excel files and password protecting the zip archive is more than satisfactory. We purchased the command line version of WinZip a while ago (which I now believe is free), and can use this to accomplish what we need. Once again, thank you all for taking the time to assist us, it is very much appreciated. Hope everyone is having a great weekend ! -Gerry Gerard T. Pauline Mgr, Internet Applications & University Web Master Computer Systems, DoIT Pace University ...

Web resources about - Re: MS Access and SAS datasets #2 - comp.soft-sys.sas

Data set - Wikipedia, the free encyclopedia
For IBM mainframe term for a file, see Data set (IBM mainframe) . For the telecommunications interface device, see Modem . A dataset (or data ...

Data : Where can I get large datasets open to the public?
Answer (1 of 91): Here's the ones I've found most useful: CrunchBase, US Census, Google Public Data, Infochimps, Timetric, Factual, Freebase, ...

YouTube - Hans Rosling: Let my dataset change your mindset
Hochgeladen am 31.08.2009 http://www.ted.com Talking at the US State Department this summer, Hans Rosling uses his fascinating data-bubble software ...

The Mindset, Skillset, Dataset Approach to Social Media
... Social media is comprised primarily of unstructured data, which is difficult to analyze. A new approach called Mindset, Skillset, Dataset can ...

Sending large datasets to Amazon? Use the Post Office
Amazon has introduced a new method to move large amounts of data to and from …

The Full Dataset on What VCs are Thinking About Funding in 2016
... challenging and many other startups were cutting costs (as many of ours has done in late 2015). We promised that we would clean up the dataset ...

Yahoo Releases the Largest-ever Machine Learning Dataset for Researchers
Yahoo is announcing the public release of the largest-ever machine learning dataset to the research community.

IDG Contributor Network: Are datasets truly anonymized? Two well-suited researchers are going to find ...
With little fanfare or formality, Adam Smith , associate professor of computer science and engineering in Penn State's School of Electrical Engineering ...

House GOP looks to shed light on EPA secret datasets
House Republicans have introduced a bill that would block the Environmental Protection Agency from crafting regulations based on “secret” scientific ...

Guest Contribution: “Capital Control Measures: A New Dataset”
Today we are pleased to present a guest contribution written by Andrés Fernández (IDB), Michael W. Klein (Tufts), Alessandro Rebucci (Johns Hopkins ...

Resources last updated: 3/18/2016 8:17:48 PM