Hi Guys,    I have a file with a long address string called "Address". I have to create a file with a max of 3 address columns, let's call them address 1-2-3. Each column has a max length of 36 characters and I don't want to break up part of a word to move over to the next line.   I need something that will break up the string into columns of the desired length taking into account complete words. In other words not split a word in half to create a new line, instead if the particular word would make it go over 36 characters to then move that word on to the next column and so forth.   For example, if this were the address line:   This is an example of a really long address string which needs to be split into columns of 36 characters   Into something like:   This is an example of a really long address string which needs to be  split into columns of 36 characters 35 33 35   Any suggestions would be much appreciated. I looked at some of the samples posted but they all seem to revolve around delimited long strings.   Thanks! ... View more

Hi Guys,    I'm creating an address file which I then need to format into columns based on number of characters. However, I am first trying to replace words within the address string to common abbreviations to cut down some of the length.   I have an address string on a file (work.addresses) like so:   123 maple court avenue, anycity, anystate   I have a separate list (work.abbrev) which gives me the abbreviations, it has 2 columns Word and Abbreviation:   Court | Ct Avenue | Av   I want to know how I can do a tranwrd loop or something similar which will look at the words from the address string against the words on the abbreviations list and on the ones that match replace the matching word with the abbreviation.    final result would be: 123 maple Ct Av, anycity, anystate   I'm not quite sure how to build the syntax..there was a similar topic on here however, it didn't really cover how to loop through a separate list of words to match   Any help would be much appreciated!     ... View more

Hey Guys,    I am trying to figure out how to do a mean of the last 6 months of balances. I have a table that I keep on appending to every new end of month. E.g. Bal01012016, Bal 02012016, Bal 03012016, etc..   I have an array as follows:   array T1Table{*} T1:; T1Last=T1Table[hbound(T1Table)];   Which works fine, I am able to get the Hbound and Lbound values, however, I want to be able to figure out how to get the mean from the last 6 months for balances, so basically get the last T1 Value and do the mean calculation against that one and the previous 5 T1 values..   Any idea on how I can achieve this? My array usage is limited so I don't recall.   Thanks in advance for the help!   Jose S ... View more

Hey guys, I tried searching for any previous comments on this, but nothing quite the same came up... I have a User defined function in SQL server for converting Julian dates to Gregorian Dates, and another for Jaro Winkler Probability (distance), The question is, Would there be a way to call these functions in SAS on a proc sql statement? I tried putting them on the statement but SAS cannot find the function it says the function cannot be located.. Any suggestions? I know that for the Julian I can process in SAS but I would like to keep the processing on the server side..I am more interested in the other function.. Thanks! ... View more