Search results for query: *

Just to let everybody know I got this resolved by doing the following in Office 2007: * Select the textbox * Click on the line spacing option * Choose Line spacing options * Under special, change from "Hanging" to "none" I'm not sure I ever messed with this setting, but this was how I reverted...

Hi, I have typed some text into a textbox in Microsoft Word. Then I think I messed with some text settings and as a result, my text is indented from the second line of each paragraph onward. Something like this: ---------------------- The text in my textbox ****begins here, ****however as you...

Hi, Simple question but I don't know what this is called so I haven't been able to find good results from the web. Does something like this work in a data step? where 0 < var < 6; That is to say, is it always equivalent to where var > 0 and var < 6; I've tested with a made-up dataset...

Hi Chris, So let's say my dataset has 1 variable called description. Let's just say I have 5 observations: peter and john go to school john is a boy i like john, mark and peter i go to school peter goes to school the list that i have, called name list, contains the following: peter john...

Hi, I have a dataset with a variable called description. A description may contain zero, one or many names matching names in a list called namelist. I'm trying to search description for these names and, when found, create new variables containing them called name1, name2, name3, etc. For the...

Hmm....strange. I restarted sas, applied the options and reran the code and it ran just fine. (-: Thank you!

Hi all, I found a macro that appends one dataset to the bottom of another and keeps the greater variable length between the 2 sets of variables: http://support.sas.com/kb/33/407.html I'm trying to adapt this macro so that the macro accepts as many input dataset names as I give it and outputs...

Thank you Chris. You've been most helpful.

As far as I know, the in operator and the colon operator modifier work splendidly before, during and after a datastep. What I mean is that the following three statements all work (albeit slightly differently): data test2; set test; where textnumber in:('1','2'); run; data test2; set test...

wow...your code is way more efficient than mine. I think it was slick to pull only matching personids using the in() statement. Thank you! One thing I've been puzzled for a while and haven't found a satisfying answer. What's the difference between the where and the having statements? I am under...

Hi all, I have 2 datasets: b is the main dataset, a contains the list of relevant unique personIDs that I want to pull data from b based on. In particular, I'm pulling the minimum date grouped by personID. I also want to restrict the minimum date for class "A" persons only and exclude missing...

Isn't SAS 9.3 already released, or parts of it are? Can't wait for the ability to write UDFs!

Dear kdt82, That was extremely useful. I'm glad that right after joining the forum I was exposed to such quality responses from you. I've used your code with a slight modification that differentiates the interval depending on whether the second day of the month is greater or less than the...

Hi, I'm trying to create a macro that returns the number of months elapsed between two dates. The macro would be called in a datastep pulling in the dates from two variables and returning the months difference into a new variable. Here is what I have so far: ************************* %macro...