Hi, have you sorted this out? How did you address it? If not, copy and save a new file and create a new folder in SAS. Also, which version of SAS are you using🤔. Not that it is entirely a determining factor but it might help to know. ... View more

DanWaldo ! your approch and code was awsome and i had sucefully implemented it with some customization ... View more

Well, I am clearly wrong in thinking that string variables are stored with a variable number of bytes.  I ran a quick test to demonstrate.  (So, I learned something new today.) No, I don't know of a VARCHAR(n) equivalent, but maybe that would be a good thing to suggest to SAS. data test_string3_val3 ; length teststring $3 ; do i = 1 to 10000 ;   teststring = 'Joe' ;   output ; end ; drop i ; run ; data test_string399_val3 ; length teststring $399 ; teststring = 'Joe' ; do i = 1 to 10000 ;   output ; end ; drop i ; run ; data test_string399_val399 ; length teststring $399 ; do i = 1 to 399 by 3 ;   teststring = 'Joe' || trim(teststring) ; end ; lentest = length(teststring) ; put "Length(teststring) = " lentest ; do i = 1 to 10000 ;   output ; end ; drop i ; run ; data test_string399_val399_compressed compress=yes ; set test_string399_val399 ; run ; proc datasets ; run ; RESULTS:   # Name                                                                       Type      Size             Last Modified 2 TEST_STRING399_VAL3                                    DATA     4113408    07Mar13:11:11:34 3 TEST_STRING399_VAL399                               DATA     4113408    07Mar13:11:13:23 4 TEST_STRING399_VAL399_COMPRESSED DATA         17408      07Mar13:11:17:28 5 TEST_STRING3_VAL3                                         DATA         33792      07Mar13:11:11:34 ... View more

Gchart still works in 2012 ... better than ever, actually! 🙂 ... View more

I use INTNX to track product sales by week, for example, where it is very efficient to code sales date into a week number.  I would not use INTNX to calculate someone's age, because the function is using calendar dates, like Jan 1st, etc. for the interval boundaries.  Also, it is worth doing testing to understand INTNX especially for "week", because Jan. 2, for example, may not give you the value you thought, depending on which year it is, and what day of the week Jan. 1st falls on. As for PROC SQL - I love PROC SQL, but that doesn't mean it's the right tool for everything you do.  ("When all you have is a hammer, everything looks like a nail.")  I prefer a DATA step for SAS functions, like the date functions.   ... View more