Hi jenn,
If sounds like you might prefer preparing your data using SQL. You could do so from the data builder by manually editing the code on the "Code" tab of a data query or star schema. Here's some information that might be helpful to you:
http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1bhe7s7u4l7egn1d2ahwvqw34is.htm
Best regards,
Lorrie
... View more