Search results for query: *

I have a very large dataset from which I need to create a subset of customers where their balance equals a target value... So for example, giving the following dataset: Customer 1 - 30 Customer 2 - 100 Customer 3 - 50 Customer 4 - 20 Customer 5 - 50 If I set my target value to 120, then I...

Having a problem rounding a number to the tenth decimal place. Using SAS V8. data Inputs; input NoIn $50.; datalines; 325256.95299286436284664885258 ; run; data Rounded; set Inputs; format NoOut 32.10; NoOut = round(NoIn,.0000000001); run; Would expect to see a return of...

Hi, using SAS version 8. If I set up a remote library to a SQL Server, any tables on that SQL server with names longer than 32 characters do not show in the library. Is there a setting somewhere to just have SAS truncate the name so it is visible? Cheers Nick where would we be without...

I've created a macro which returns a single value. how do I implement it within a datastep so as to create a new variable within that datastep. i.e. data AppendParent; set MyInputs; format UltimateParent 11.; UltimateParent = FindUltimateParent(ChildEntity); run; So basically I want my...

Not sure if this is possible but can I parse the results of the following into a dataset? x 'find /c "searchstr" "x:\sas\data\*.sas"'; basically all this does is call the DOS "find" command. The idea of the program is that it will search sas program files for a particular word or phrase...

Has anyone been involved in a SAS server upgrade. SAS are telling us that the Metadata server is fundamental to the operation of SAS 9. I can't help think that this is just SAS trying to squeeze yet more money out of us. Can anyone shed any light on this? where would we be without rhetorical...

Is it possible to count every NULL in a table? I have a large table and users are asking how well it's populated. Thanks nick where would we be without rhetorical questions...

This is a bit of strange one although it's probably my fault! I loop through all the <select> elements on my page and set the visibility to 'hidden' function HideAllObj(){ var objType = document.getElementsByTagName('select'); for(var i=0; i <= objType.length-1; i++){...

Basically I have a fairly large xml file and all I'm wanting to achieve is add some sort of paging to this so if you have a better solution feel free to chip in! I thought the best way to achieve the above would be to load the XMl to a recordset however no matter what I try I get the following...

I'm using the following code to perform a recursive loop in order to get a total count of all files contained within a parent folder and it's sub folders. Sub CountFiles(OfFolder As Scripting.Folder) Dim SubFolder As Scripting.Folder FileCount = FileCount + OfFolder.Files.Count...

Is there a way to issue the "signoff" command when the user closes SAS? i.e. Is there an onclose event or something? Nick

The following code creates a new word document. I have 2 lots of data from Excel that I need to put on the word document so I thought best solution would be to copy and paste. The code should take the first lot of cells I want to copy and put these on the document, then insert a page break, copy...

Can I do a Select Into across 2 DB servers? Nick

Hi, lets say i have the following dataset... data test1; input var1 $; datalines; a b c e f ; run; and i want to concatenate var1 into one big string i.e. abce... I've tried this but it doesn't seem to work and I really cant figure out why! data test2; set Test1; retain mstr; if...

I'm looking to see if anyone can suggest an alternative to Cursors? The scenario: each day we perform a table transfer from our production DB to another SQL Server. This backup will then get transferred to a SAS server, however before I make it available to the SAS users I have to perform a...

Is there a way I can detect if a query was submitted locally or remote to the server? Reason I ask is that I have a bunch of macro's that are used by various people. At the moment they have to run these locally as the libnames are different for remote submission. Cheers Nick

Having a bit of a problem with setInterval lag withing FF. Just wondering if anyone had any work around for this... Here's what I'm working on: http://development.nicksplaysite.co.uk/gb/Calendar.asp?cab=Benearb Basically I have the timer set to 1000th of a second. In IE this works fine and...

What I have is a basic search function. I use the search results for form some XML which I am saving to a database as well as displaying to a user. My problem is that XML is sometimes too big to store within a String variable and is therefore truncated. Can anyone help with a solution to this...

I have an onchange event on an input field. Is there anyway to trigger this if the field is updated by another piece of javascript? Here's an example of what I mean: <script language="javascript"> function ChangeIt(){ var obj = document.getElementById('MyInput'); obj.value='Hello!'; }...

I've changed the scrollbar color for the body of the page body {scrollbar-base-color:#3A66A7;} but I want elements like textarea to keep the default colors... how would I go about doing this? Thanks Nick