Hi all,   Please excuse me if I don't explain this very well, I will do my best to outline what I'm after. I have 2 datasets in SAS that look like this:   1)   2)   I would like a final dataset that takes dataset 2 and assigns it a band based on the min-max spread depicted by dataset 1, something that looks like the following:   Any help is much appreciated! I had thought about somehow forcing a one to many merge, where every business in dataset 2 was duplicated by the amount of bands, then simply running if minvalue<value<=maxvalue then dummyvariable="YES", then getting rid of any rows that aren't "YES".   Many thanks, Declan ... View more

Hello,   My SAS is on a remote server that I remotely sign onto. I recently tried to run a proc means with a median option and my log informed me I had run out of memory.    How exactly can I find out how much memory I have available to work with? Little worried it's not adequate...   Many thanks, Declan ... View more

Hello,   I have dates being generated in a numeric format of yymm (eg. 1706 = June2017).   I have been trying to substring it to grab the month and then convert it into "mmm" using monname3. but with no success. In the example above I am trying to grab "Jun".   As a test I have tried:   data test ; mon=06 ; month=put(mon,monname3.) ; run ;   However this always returns "Jan" in month?! Very confused, any help is much appreciated. Declan ... View more

Hello,   I am trying to use the DATDIF function to retrieve the amount of actual days between two dates:   The dates I am working with are numeric and in the format eg. 170102 and 170320 (2nd Jan 2017 and 20th Mar 2017).   I am unsure of how to prep these dates such that when I input them into DATDIF it will be able to run properly.   Any help is much appreciated, Declan ... View more