Yes - EG = Enterprise Guide = or perhaps called Enterprise for some 😄   Having converted - I prefer EG and I like being able to organize all my SAS programs. It's also made for non-programmers where you can point and click. But if you keep your style and program - you can use EG at least for organization if nothing else 🙂 (although EG can do a TON of things) ... View more

Also when you open files - you can right click on the program/file you are opening and select open with SAS Base vs. SAS EG. ... View more

  What you wrote will remove embedded blanks with the COMPRESS statament. The questions askes to change the embedded blanks to 0's - so we need to keep those in the dataset so we know where the 0's should go.   I can think of a few ways this may be set up without seeing the data set - 1) need leading zeroes or 2) need zeros inside or 3) need leading and zeros inside which we will not know unless you have a variable like '  3-29-3 9 '  so i'm assuming you have a numeric variable and you need either #1 or #2 done. 🙂 ****************************************************************************************************************************************   So if we want to add the leading zeros - we can define the new SSN variable and tell it it'll be 9 spaces. We will conver the numeric to a character value format with leading zeros. ... SSN_LEADING= put(SSN,z9.); format NEW_SSN z9.; ... More info here about leading zeros: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000205244.htm   ****************************************************************************************************************************************  To change the embedded blanks that are not leading you can try this function: .... SSN_INSIDE= tranwrd(strip(SSN)," ","0"); ...  ... View more

Awesome - this worked!  Thanks so much for the help! ... View more

Excited for the new swag!   ... View more

I do have the cloudera one i think - Data is the new Tofu.   Some reason the tofu ones were plentiful and the bacon ones ran out, lol. ... View more

I thought it was already set up! I just called Disney and confirmed hotel room. Disney then connected me to the Magical Express to confirm transportation as well - I had to tell flight # and confirmation # for room. Thank goodness I read this otherwise I would be hitching a ride with one of you from airport! 😉 ... View more

I 2nd the Kennedy Space Center - we were there a few weeks ago and it was really cool.  Warning - you could spend the whole day as there is a bus tour that is included with attendance that is 2hrs+ long and they drive you out to some of the launching pads.  The last one is at 3pm - so you'll need to get there early.  Earlier is where everything is happening as later in the day (after 2:30pm stuff is dying down and no more activities).  They had stuff like meeting with astronaunt, signing autographs, different small sessions - it was really cute.  Will warn it's hot, so wear comfortable lightweight clothes! ... View more

I'm in the east side of dallas - so a good 30m drive it seems like ona good day to airport, lol. ... View more