Given that input: 10 1/7 04/12/13 04/12/2013 10 10.1 10weeks 10w1d 101/7 weeks it would be nice if the original poster could indicate his interpretation of the value required ... View more

Will there ever be more than two terms for an ID? Is there a text length limit? Is it 5 characters or more? ... View more

Have a look at at the google search result: Using DATA Step Component Objects: Using the Java Object - SAS Support support.sas.com › lrcon › HTML › default Using the Java Object. The Java object provides a mechanism that is similar to the Java Native Interface (JNI) for instantiating Java classes and accessing fields and methods on the resultant objects. You can create hybrid applications that contain both Java and DATA step code. To this url: http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a003252712.htm It is for SAS9.2 so expect improvements to be available ... View more

Try overloading the formats to make a single lookup return the multple columns by parsing the returned value on a suitable delimiter. Then you need just one format lookup for each dimension. However the problem of loading the format into memory is still needed in each step (I expect). ... View more

Usually &outside is used in a boolean test. Its value is fixed as either 0 or 1.It is used in constructing proc template code - I do not think the %do loop provides much benefit over a repeat of the base code being generated with the few, minor variations  ... View more

%scan(2,2-&outside)Seems a complicated way to produce 2 or nothing ... View more

In one of the macros at the link provided above by @ballardw, I was very surprised to see: %scan(2,2-&outside) Could someone explain what this does when &outside has value=0 ? ... View more

Reads like P. Dorfman code 🙂 ... View more

Ask the provider of the macro ... View more

Needs a semicolon ... missing from one of the trailing @@ ... View more