About nbirkett

nbirkett · ‎03-22-2014

Argh! Can't believe it was that simple. Thanks.

nbirkett · ‎03-22-2014

I'm running SAS 9.4 under Parallels v9 on an iMac with Lion as the OS. I am trying to access a mysql database on a remote server. I can't get SAS to connect to the server. 1. SAS can access a mysql database set-up on a local server running in Parallels (set-up using WAMP). SO, the basic code is OK and SAS has the capability to access mysql. 2. I can access the remote mysql database from my iMac using SEQUEL PRO. So, I know that the configuration/IP address/Port is OK and that I have permission to get remote access to the database on the server. 3. SAS can access neither the mysql database on the remote server nor one which I set-up on my iMac using MAMP. I have checked the ports and they are correct. My SAS code is: libname mysqll2 mysql user=njb1 password=password database=njb1 server='http://xxx.xxx.xxx.xxx port=3306 ; The error message that is posted in my log file is: ERROR: Error trying to establish connection: Unknown MySQL server host 'http://xxx.xxx.xxx.xxx' (2) ERROR: Error in the LIBNAME statement. I've googled, and read the relevant SAS manuals but nothing seems to help. Anyone been able to connect to a remote server in this situation? Nick.

nbirkett · ‎03-03-2014

Thanks both. Largely confirms what I was thinking. I'm trying to avoid Access for practical reasons. The Microsoft Office package for iMacs does not include Access. So, to use it, I'd either have to adopt the OpenOffice version or run it in Parallels, like I currently do for SAS. I'd like to use a native OS/X database. I now see two choices: buy the upgrade for SIR or get Filemaker Pro 13. The former is more expensive and runs under X11 on my iMac (i.e. it is not really 'native'). It's still somewhat 'old school' but has the advantage that all of my current code will run without requiring any modification. And, I could do updates as time permitted. Filemaker takes more advantage of CSS, styling, graphic presentation, etc. It has record locking and support data entry from remote sites via the internet (not a priority a prsent but something which could become useful). But, I'd have to develop completely new screens/programs to replace my current ones. And, it has no option to write the database and entry screen definition code in a file and the run them - you have to do all of that using the graphic interface and menu selection (which I find slower then typing code). Plus, the linkage to SAS is a bit more complicated. A compromise would be to get the SIR upgrade to support my existing databases but use Filemaker for any new work that I do. Hmmm. Decisions, decisions.

nbirkett · ‎03-02-2014

I have used SIR for most of my data entry and editing, with SAS for statistical analysis. However, the SIR software (which is still the 1987 version - I never updated) is running on a computer which is to be de-commissioned. Since I will need to change software, I am exploring replacing my data entry/editing screens with programmes developed in SAS. What I need is to have the data fields positioned on the screen as if they were a questionanire. In some places, this means having a matrix style layout with, for example, rows being different reporting years with columns collecting data in physical activity amounts and types within the year. A simple table or spreadsheet layout isn't suitable. I need something like a Filemaker screen. I have read the manuals on SAS/AF and it has some nice features. But, I am not sure that I see how to display the specific variables from a dataset on a /AF screen for editing. /FSP seems to be limited to text style layouts. I did a google search and looking through this forum but didn't find anything to help. So, before I spend a lot more time on either 'solving the impossible' or 're-inventing the wheel', does anyone have any pointers or advice? I have considered using something like Filemaker but it can't create SAS programmes to access data like I can from SIR (ODBC might work). I'd rather not get into having to design HTML/PhP/MySQL code from scratch. Would appreciate any advice. Nick Birkett, Ottawa, Ontario, Canada

nbirkett · ‎06-17-2011

Yes, I agree with you. The 'filename' was included just to delete the name allocated to the output. The deletion occurred in the previous code fragment. I will look into the 'noxwait' suggestion. Thanks. Nick.

nbirkett · ‎06-17-2011

I have a SAS programme which I have to submit to a remote site to execute. In order to preserve my log/print output, I use O/S commands to delete and create them (see below for code). This has worked fine for several months and continues to work on my test machine. But, for the past two weeks, the remote site has been unable to delete the log/print files after my programme has completed. They get an error saying that the file is still in use. They are storing the files on a network server, not a local machine. Any advice/suggestions would be appreciated. Nick. options noxwait; data _null_; command = "rmdir /S /q &location_results"; call system (command); command1 = "mkdir &location_results"; call system (command1); run; proc printto; run; filename outlog CLEAR; filename outlog "&location_results\log_cohort1_mf.txt"; filename outprint CLEAR; filename outprint "&location_results\print_cohort1_mf.txt"; proc printto new log=outlog print=outprint; run;

Online Status	Offline
Date Last Visited	‎05-04-2021 11:01 AM

Re: mysql access

mysql access

Re: Creating data entry/editing forms

Creating data entry/editing forms

Re: Deleting log/print files

Deleting log/print files