f



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;
0
chang_y_chung (1975)
5/6/2004 1:09:06 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
531 Views

Similar Articles

[PageSpeed] 5

Reply:

Similar Artilces:

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: 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 automatic...

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

Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2 #2
> From: A Little Birdie > > I just searched the SAS-L archives (should have done that > first) and found references to these two pages: > > http://www.sascommunity.org/wiki/Category:V9.2_Phase_2 > > http://www.sascommunity.org/wiki/V9.2_Phase_2_install_guide > > Have you seen this page? > ***************************************************** > http://support.sas.com/kb/35/631.html <---<<< NICE! ***************************************************** > It looks like it addresses your needs, and might be something > nice to add to the SASCo...

Re: MS Access
DATA <whaterver>; is a 'replace/create' action. If you want to update, use UPDATE in PROC SQL. proc sql; update rads.monthly_status ... ; quit; Just because you are using UPDATE inside the datastep, it doesn't mean that it is not still creating a new dataset [or in this case, MSAccess table]. PROC SORT does the same thing; it creates a [theoretically new] dataset sorted in the order requested, with the original dataset as input. Now, here ODBC may be part of the issue; when I use LIBNAME EXCEL for excel, it requests Excel do the sorting [which should work...

Re: from SAS to MS Access without Proc Export #2
You got sas/access for odbc? It's easy to do w/that: libname mdb ODBC required = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\Documents and Settings\pardre1\Desktop\DocEMails.mdb" ; libname scratch "\\ctrhs-dbserver\warehouse\sasdata\crn_vdw\scratch" ; data scratch.DocEMails ; set mdb.DocEMails ; run ; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Bill Droogendyk Sent: Monday, November 22, 2004 12:04 PM To: SAS-L@LISTSERV.UGA.EDU Subject: from SAS to MS Access without Proc Export Folks: I've an application running from my PC via SAS Connect to the Mainframe that harvests some MF data, downloads the data and uses proc export to build an MS Access file. Now and again, the app fails due to a glitch on our PC network. I'm doing it this way because we don't have proc export on the MF. I can produce xl files from the MF to the PC network with ODS, html and ftp. MS Access imports xl files quite readily, but xl files do have a size limit that we sometimes exceed.Is there also a simple "equivalent" way to produce (directly) ms access files with only SAS Base? Thanks, Bill ...

Re: Exporting Multiple SAS files to MS Access #2
Kim - open the MDB with the Access libname engine and use proc copy. libname mdb 'file.mdb'; proc copy in=sashelp out=mdb mt=data; select c:; run; libname mdb clear; You can list the files in the select statement or just drop it if you are copying a whole library. The MDB has to already exist, unlike the Excel libname the Access libname does not create files - so you can create it by hand, or trick SAS into making it. data dummy; dummy=''; run; filename MakeMDB 'file.mdb'; proc export data=dummy outtable="dummy" dbms=access2000 replace; database=MakeMDB; run; filename MakeMDB clear; proc delete data=dummy; run; libname acctb access 'file.mdb'; proc delete data=acctb.dummy; run; libname acctb clear; hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kim Brown Sent: Friday, December 05, 2008 9:47 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Exporting Multiple SAS files to MS Access Hi all, Export from SAS to MS Access: Is there a way to export 20 Data sets from SAS into MS Access without writing separate export statement? This is the syntax, I’m using now. PROC EXPORT DATA= K.HDHS_APR08 OUTTABLE= "HDHS_apr08" DBMS=ACCESS REPLACE; DATABASE="LOCATION"; RUN; Any help is appreciated, Thanks. Kim ...

Re: help SAS/MS ACCESS, general database questions #2
You're describing my project with the Department of Education! We had a dbase database and used a Clipper application to massage it into 'presentable' form. And I thought I was on the bleeding edge (back edge, that is) 8 years ago. As with everything, it depends on what your main purpose is. In my case, it was to disseminate the information to as many people as possible in a format that could be read by/into as many applications as possible. So, we converted our data to flat files and supplied an 'application' that generated sas code that would read the flat files into a sas dataset (complete with formats and labels), so the researcher could write their own code to run against the sas dataset. It sounds like your project isn't quite as ambitious, but the reason I include this example is that it's hard to predict what form data will take, say, 5 years from now. I'll bet you've already run into difficulties in using Clipper, and you'd like to avoid these kind of problems the next time you update/analyze your data. Sas has had some changes in going from one version to another--generally, upgrading to the next version involves updating your dataset to the next version's format. So, if you're purpose is to archive your data for the next iteration of your survey, unless you're going to be active in the data, sas might not be the best choice for data storage. Somewhat more stable would be something like SQL server (cheap, ...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sorts of a copy left/right mess at the moment. On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: >I use both SAS and R; I"ve used SAS for 10 or 15 years, R for about 6 >months - 1 year. > >Each has strengths and weaknesses; I'd not like to give up either. > >Strengths of SAS (esp. compared to R) > >Tech support - I have SAS tech support's phone number and our license >number memorized. They're great. > >SAS-L - There's also an R-help list...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #2
jontugman, Test preparation is akin to following a simple algorithm: 1. Evaluate the test and discover if it is worth taking. 2. If #1 evaluates false then go to exit. 3. Determine if your *test* knowledge of SAS is insufficient. 4. If #3 evaluates true, do the test preparation. 5. Pay the money. 6. Take the test. 7 Exit. From your standpoint, the step of paramount importance is step #1. That is where you mainly failed. From SAS' standpoint, only one step matters: #5. This is the only reason the test was created in the first place. The world would be a better place if all employers understood that as well. However, some recruiters/HRers require the certificate as a CYA backup should they accidentally hire a pure test-passer. Fortunately, I have not seen many occurrences of this nature since the inception of the boondoggle, perhaps because most candidates are almost inevitably interviewed by people qualified in SAS better than HR. And most qualified people saw the program for what it is even before its advent. SAS-L is replete with numerous posts to prove it. Needless to say, it does not imply in any way that any certificate-holder has no more SAS behind the belt than the certificate can cover. Far from that! Many fantastic real-world people have been forced into the thing by their SAS partnership business needs, many have taken it just for the heck of it because their employer would pay for it, etc. My opposition to the thing as a matter of principle is based on t...

Re: SAS/access for Oracle and MS SQL server are different license? #2
The way they do this is pretty confusing (at least to me). But my understanding is that the Access products are licensed separately. The terminology "SAS/Access for RDBMS" is an all encompassing term to describe the product line and not the components of the product line. Many shops will license ODBC or OLE DB to access databases in a more generic way. Access for Oracle and Access for SQL Server are (I think) "native" drivers. I've never seen much difference in performance between native, OLE DB and ODBC to be honest. Finally, you can get a complete set of Access drivers for WPS as part of the base product. In other words, you don't have to pay additional fees to access the databases with WPS. The list of drivers for WPS can be found at: http://www.teamwpc.co.uk/products/wps/features/data_access Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ya Huang Sent: 04/28/2009 3:03 PM To: SAS-L@LISTSERV.UGA.EDU Subject: SAS/access for Oracle and MS SQL server are different license? Hi there, I ran proc setinit and see we have SAS/ACCESS Interface to ORACLE, but not MS SQL server. Does it mean we need to pay the license of SQL server in order to access SQL server? I see people sometimes simply say "SAS/access for RDBMS", does it mean all RDBMS (Orac...

Re: SAS 8.2 to SAS 9.1 libname convertion #2
I am able to read Access 2000 tables using SAS 9.1.3, with syntax modeled on yours. Try proc contents data=bb._all_; run; to see what tables and views are detected. On Fri, 8 Jul 2005 13:51:40 -0700, DC <chendlcan@YAHOO.COM> wrote: >Hi All, > >my codes created on SAS 8.2 does not work on SAS 9.1? >Anyone knows how to convert the below code to SAS 9.1? >Thanks a lot! > >SAS 8.2: >libname bb dbaccess 'x:\a\b\c\d.mdb' bbb='asdfgh >zxcvbn'; >libname cc dbaccess 'x:\a\b\c\d.mdb' ccc='asd zxc'; > >proc sql; > create table eee as > select b.* > from cc.ccc A, bb.bbb B > where a.id=b.id; >quit; > >SAS 9.1: >libname bb 'x:\a\b\c\d.mdb' ; >libname cc 'x:\a\b\c\d.mdb' ; > >proc sql; > create table eee as > select b.* > from cc.asd_zxc A, bb.asdfgh_zxcvbn B > where a.id=b.id; >quit; > >problem: >seems sth wrong with "asdfgh_zxcvbn" >log shows "File bb.asdfgh_zxcvbn.DATA does not exist." > > > > > >____________________________________________________ >Sell on Yahoo! Auctions � no fees. Bid on great items. >http://auctions.yahoo.com/ ...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #2
Graham , I am not sure that the SI Tech Support examples should have all the error checking that Chang wanted to throw in the macro. The examples should be clear concise and easy to read and get going, as well as be illistrative. Too much error checking in an example well is just over kill and even detrimental to an example. However, any code solution on the SI Tech Support web sit should follow basic rules of good practices and sound advice. Such as with thier macros having atleast a somewhat good Macro design. Look at Example SAS Sample 1728: The first method well lets say is soooo bad...

Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2
Subject: Re: v9.2 phase 2, page update "Make the installation of SAS BI Server easier!" .... Ok w/me! Just remember that the majority of us are still just installing only SAS Foundation v9.2, and possibly Enterprise Guide v4.2 My rant/suggestion to Tech Support has been addressed. I have added notes about my conversation with Tech Support to this sas community wiki page: http://www.sascommunity.org/wiki/V9.2_Phase_2_install_guide summary: if you have Build # greater than or equal to 28 then you can dispense with ForceInstall. Ronald J. Fehd, IT Spec HelpDesk Level 3: SAS CDC S...

Re: How to access automatically in SAS a MS Access table name
i am not sure if SAS will support long file name if you use libname. a workaround is to use passthrough. On Jan 16, 2008 12:31 PM, JKamgang@Yahoo.com <JBKamgang@gmail.com> wrote: > 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=ANY ; > > 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.'tblInfantHIVTestResultsAdditional'n (keep = > > testid studyid labid i2 i2_da i2_mo i2_yr i2a i2b i2text > > ); > * > > run*; > > - - - The log - - > > 1636 > > 1637 /* Creating the Pediatric HIV result information additional */ > > 1638 > > 1639 data pedResultadd ; > > 1640 set dbsource.'tblInfantHIVTestResultsAdditional...

Re: SAS maps / SAS Graphs #2
I had to look that up, and found this: a.. If a picture is not worth a 1000 words, to hell with it (quote from = Ad Reinhardt -- note this is from the original Chinese quote that "a = picture is worth 10,000 words).=20 From: http://www.washington.edu/computing/training/560/zz-tufte.html -Mary (who actually right this instant is working on a trying to make a = "nice" diagram right now from a sketch done on the back of a file folder = with over 50 circles and connecting lines everywhere) ----- Original Message -----=20 From: data _null_,=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Thursday, March 06, 2008 12:15 PM Subject: Re: SAS maps / SAS Graphs How do you define nice? Do you use Tufte's Data-ink ratio? On Thu, Mar 6, 2008 at 12:08 PM, Vincent Granville <vincentg@datashaping.com> wrote: > We are looking for nice SAS graphs to post in the image section on > AnalyticBridge. If you have produced such graphs, you are welcome to = post > them (migh require a sign up, but it's free). You can also rate the = graphs > posted by other participants. It's a good way to be noticed for the > quality of your work. See http://www.analyticbridge.com/photo/photo = to > view the graphs currently posted (not all of them are produced with = SAS). > ...

Re: Running SAS jobs sequentially in batch mode
> Note that unless you clean up work datasets and any macro variables created by each production job, subsequent jobs will not be starting in a pristine environment. It may be a good idea to include a new program between each production job to kill all work datasets and query sashelp.vmacro to create %symdel statements to delete macro variables. Would you be kind enough to give sample statements to do the CLEANING and KILLING? Susie Li TV Guide 1211 Avenue of the Americas New York, NY 10036 Tel 212.852.7453 Email susie.li@tvguide.com -----Original Message----- From: SAS(r) Discussion [m...

Re: SAS/DMS library default library allocations using SAS V8.2 on #2
The library allocations have to be stored <somewhere>, otherwise you wouldn't continue to get the prompt. You can look under your userid to see if it's there (though I suspect you've already done that), but a better question would be directed at the SAS sysadmin--ask them where these profiles/customizations are stored (the sasuser.profile is the generic one--your personal one is concatenated along with it). You may be able to see your session info under your userid tso log (shows usage information), though off the top of my head I can't remember if it captures al...

Re: How to access automatically in SAS a MS Access table name #3
Jean - Unfortunately you are stuck - SAS only allows dataset names up to 32 bytes long - using name literals or conventional names. Defining short-named queries of your tables within MSAccess is a very good idea. The SAS libname engine will read the queries as tables and it doesn't necessitate changing your table names. Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of JKamgang@Yahoo.com Sent: Wednesday, January 16, 2008 9:32 AM To: SAS-L@LISTSERV.UGA.EDU 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=ANY ; 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.'tblInfantHIVTestResultsAdditional'n (keep = testid studyid labid i2 i2_da i2_mo i2_yr i2a i2b i2text ); * run...

Re: SAS and MS Access
If you don't then you could perhaps consider bolting on your own JDBC interface in Java? (JDBC is free SAS ACCESS to PC is not...) On Thu, 6 May 2004 07:27:13 +0100, =?iso-8859-1?q?Ari=20Toikka?= <toikkari@YAHOO.CO.UK> wrote: >Hi, > >if you have ACCESS to PC Data files licensed, >you can use the import / export wizards (File / Import Data) >You can then save the generated program, which >might look for example like this: > >Proc import out = sasuser.test > datatable="h456test" > dbms =ACCESS97 replace; > DATABASE="T:\h345test.mdb"; >run; >If you have columns in MS Access having a length over 1024 characters, >you have to add: > >Memosize=xxxxxxx ; /* xxxxx=the maximum length */ > >Ari Toikka >Statistics Finland > > > > > > >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. > >Thanks >Peter. > > >--------------------------------- > Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now ...

Re: SAS 9.2 Import/Export From/To MS Office 2007 #2
Michael, I'm using both Office 2007 and SAS 9.2 Phase 2. I don't see the problem. I can import Office 2007 files created by Excel and Access. The IMPORT wizard lists the relevant file extensions. -Randy -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Michael Raithel Sent: Tuesday, July 21, 2009 1:50 PM To: SAS-L@LISTSERV.UGA.EDU Subject: SAS 9.2 Import/Export From/To MS Office 2007 Dear SAS-L-ers, Here at SAS Mecca, we are just starting to migrate some "Early Adopters" from SAS 9.1.3 to SAS 9.2 TS2M0 on Windows XP Version...

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

Local access and transport area - Wikipedia, the free encyclopedia
Local access and transport area (LATA) is a term used in U.S. telecommunications regulation. It represents a geographical area of the United ...

Facebook Expanding Access to Conversion Lift Measurement
Facebook launched conversion lift measurement in January 2015 with the goal of helping advertisers track conversions instead of clicks, and the ...

Planet OS Opens Access To Weather Data
... for software developers using weather data to power their apps, researchers and climate specialists enabling them to discover, access and build ...

Access your clipboard from any PC or Mac with 1Clipboard
1Clipboard is a free tool which enables sharing your clipboard contents with other PCs or Macs. The developer says that Android and iOS apps ...

Ankara court bans Facebook and Twitter access - Business Insider
Turkey last year blocked access to Twitter over the sharing of photographs of a prosecutor being held at gunpoint by far-left militants.

US says losing access to China-claimed waters would be huge
CANBERRA, Australia (AP) — A U.S. Navy commander warned Wednesday that if the United States lost access to international waters claimed by China ...

MIT, Harvard researchers push new way for users to control access to personal data
Cryptography researchers at MIT and Harvard have developed software called Sieve that is designed to help users keep track of encrypted personal ...

How to access Google Drive files faster with Launch Center Pro
... Launch Center Pro has solved many workflow problems for me over the years. Most recently it’s been an immense time-saver when it comes to accessing ...

Cal Investigation Finds Assistant Coach Sexually Harassed Reporter Who Accused Him Of Trying To Trade ...
... a copy of Cal’s investigation into the matter, and even Hufnagel’s own statements make it appear that he attempted to trade sex for access, ...

Paragon's early access starts now, no more progress wipes
Paragon is gearing up for launch in the future, but for now, Epic is keen on putting it into an Early Access phase. The good news is that there ...

Resources last updated: 3/19/2016 3:23:53 AM