Search results for query: *

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

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

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

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

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

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

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

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

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.

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

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

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

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