Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ChrisW75
  • Content: Threads
  • Order by date
  1. ChrisW75

    Calculating the MODE.

    Hi guys, I've got a bit of a sticky problem here. I need to calculate the mode (most common value) across about half a dozen columns. There doesn't seem to be a "MODE" function though. I was hoping I could do something like this:- data _null_; a = 1; b = 4; c = 4; d = 6; e = 10...
  2. ChrisW75

    Script to create code to read data into SAS.

    Hi guys, I spend ALOT of time writing SAS code to read data in to SAS, it's a tedious job, and one I'd like to avoid if I can. I have this idea that it shouldn't be TOO difficult to write a script (say in Python or something similar) which could scan a file, work out what the delimiter is...
  3. ChrisW75

    One to stretch you a bit - Geocoding in SAS without GIS.

    Anyone tried doing any geocoding type work in SAS without using the GIS product? By geocoding I mean working with address data and assigning things to geographic locations? Primarily my interest at the moment is in trying to find a way to find the nearest point to another point, for...
  4. ChrisW75

    Notification Thread.

    People don't always check in here very often, I know I occasionally go a few days without checking in. So, I'm setting this thread up for any interested parties to subscribe to. If you post a new thread that you want people to know about, post a short note here along the lines of "New Thread...
  5. ChrisW75

    The Conversation Thread.

    Morning/afternoon/evening all. I just thought it might be nice to put in a conversation thread where we can chat, say hi, introduce ourselves, that sort of thing. I'll start. Hi, My name is Chris, I'm English, but living in Melbourne, Australia. I'm a SAS programmer and have been for about 8...
  6. ChrisW75

    Newbie Question - Trouble using IDE

    Hiya, I'm completely new to Perl (Day one of "Teach yourself in 21 days"). I've played a little and written a couple of short scripts, and I'm used to programming (SAS and VB programmer). So, I'm learning Perl, and I've coded one of the example scripts from the book, it works fine when...
  7. ChrisW75

    SAS report output to Excel.

    OK, I've been playing around with trying to output a report to Excel using ODS Tagsets. I found this Tagset on the SAS Support site:- http://support.sas.com/rnd/base/topics/odsmarkup/excltags.tpl which didn't work right off, I had to change references to "colwidth" (but not "$colwidth") to...
  8. ChrisW75

    How do I create a copy of the BE from within code in the FE.

    I've got an MS Access application to which I've added some auditing procedures, and password protected the Back End database (also MS Access) so that users cannot get to the data without going through the Front End. However, some of the users want to be able to take copies of the data out into...
  9. ChrisW75

    Any other users of SAS9 and/or Enterprise Guide 3.0 out there?

    I'm now using the new version of SAS 9.1.2 and Enterprise Guide 3.0. Was wondering if anyone else out there is using these yet and any issues/quirks/great features anyone may have come across? We've had numerous bugs in SAS/EG 3.0, but haven't really stressed SAS 9 yet.
  10. ChrisW75

    Resolving Object name at runtime (VBA)

    Hi, I've got a 2 dimensional array containing a field (text box) name and it's initial value. When I come to update my database, I want to cycle through the array and check each value against the current value to check for changes (I'll then be sending changes to an audit table). How can I...
  11. ChrisW75

    VBA - Memory not freed when Word Document Closed.

    Hi, I've written a VBA program to open and close a large number of word documents, saving as RTF and removing the password. The problem is that when a word document is closed, the memory doesn't seem to get freed up, so after processing about 2000 documents, I start getting warning messages...
  12. ChrisW75

    Article on The Register about SAS9.

    An interesting article for those interested in the latest version of SAS. http://www.theregister.co.uk/content/53/36685.html
  13. ChrisW75

    ERROR: Rename of temporary member for WORK.x.DATA failed.

    Hiya, Here's a really obscure problem. We get the error message:- ERROR: Rename of temporary member for WORK.CLAIM.DATA failed. on a semi-regular basis when running a job in batch on Unix. We've got an outstanding call with SAS, but they've not come up with anything constructive so far...

Part and Inventory Search

Back
Top