Hi,   Here is how my data looks:   ID    Type 1      4045 1      0014 1      0100 1      0038 2      0014 2      4045  2      0006   I want to identify all IDs where Type=0100 (this means the procedure did not run so the other types aren't accurate), while keeping the data the same when there is no Type 0100 for the ID.   So in this case my data would look like this:   ID    Type2   1      procedure didn't run 2      0014 2      4045  2      0006   How would I do this? I'm thinking it may have to do with using first and last.   AC   ... View more

Hi,   I want to create a new variable "MonthPaid" that is dependent on two other date variables. Here is how I created the variable for one month (January 2016):   data new; set old; if (pwrkcode='D' and workcode='P' and ('01jan2016'd <= dtclpaid <='31jan2016'd) and ('01jan2016'd <= dtwork <='31jan2016'd))  then MonthPaid='Jan-16'; run;   How would I turn this data step into an array/macro to create the variable for 12 months (I want 'MonthPaid' to populate with 'Jan-16', 'Feb-16', 'Mar-16', ........'Dec-16')? Ideally, I'd like to factor in the year, as well, ('MonthPaid would also populate with 'Jan-17', 'Feb-17', etc.) but if that's too complicated, I'm fine having a data step for each year of interest.   If there's a better approach, I'm happy to adjust my plan.   AC     ... View more

Hi,   This is a really simple problem, but I can't seem to find a solution.   My date variable is in an informat and format of DATETIME20. I want it to be in a MMDDYY10. format. How do I change my date variable from a DATETIME20. to MMDDYY10. format? I want my date variable that looks like this "01FEB2016:00:00:00" to look like this "02/01/2016."     ... View more

Hi,   Here is what my data looks like:   Unique ID      Col1      Col2     Col3     Col4    1                Text1                  Text3    2                Text1     Text2                 Text4    3    4                              Text2     Text3   I'm trying to create a new column that lists all the text from column 1 through 4, with commas and a single between the different texts, and that shows nothing when there is no text. Here's what I want:   Unique ID     NewCol    1                Text1, Text3    2                Text1, Text2, Text4    3    4                Text2, Text3   I can't seem to figure out a way with out creating ", , ," for line 3, and extra commas in the text strings (this creates a problem since I actually have 29 columns of text I'm trying to put in a text sting in a single column).   Any suggestions?   Amanda   ... View more