I'm trying to modify a timestamp variable (currently in character form) to include zeros in the milliseconds column:   Timestamp 2010-12-07 10:20:00 2011-12-10 13:21:54 2011-10-09 08:10:45.333 2011-08-15 10:15:33.4 2009-07-27 11:26:24.56 2009-10-10 14:13:00 I need to add zeros to the milliseconds column, to look like this: Timestamp 2010-12-07 10:20:00.000 2011-12-10 13:21:54.000 2011-10-09 08:10:45.333 2011-08-15 10:15:33.400 2009-07-27 11:26:24.560 2009-10-10 14:13:00.000 I tried using prxchange:     data want; set have; *timestamps with just seconds; timestamp_new=prxchange('s/(:\d\d) /$1.000/', -1, timestamp); *timestamp with one digit in milliseconds; timestamp_new=prxchange('s/(\.\d) /$100/', -1, timestamp_new); run; The first prxchange for records with just seconds using the capture buffer works. However, the second prxchange not only doesn't add 00 milliseconds but deletes seconds. It seems to be an issue with the fact that I want the digits 00 to come right after the capture buffer. Putting a space between the capture buffer and 00 produces expected results.    There may also be an easier way to add zeros to the milliseconds column.    ... View more

I have a datetime variable that looks like this:   06JAN17:14:30:00 05APR15:10:15:15 07JUN12:08:12:05 08JUN15:09:10:00 07JUN16:11:12:13   Is there a straightforward way to remove datetimes with 00 seconds, so that the output looks like this:   05APR15:10:15:15 07JUN12:08:12:05 07JUN16:11:12:13     ... View more

I'm trying to covert a character variable, timestamp, to a datetime variable that will merge with another datetime variable, date_created, in the format datetime22.3 Timestamp is currently in this format:     And I would like it to match date_created, which looks like this (datetime22.3):   I tried input, but received the error "invalid argument to function input". data want; informal time datetime22.3; set have; time=input(timestamp, datetime22.3); format time datetime22.3; run; Putting ?? before the format in the input statement got rid of the error and applied the format according to proc contents, but it produces no output. data want; informal time datetime22.3; set have; time=input(timestamp, ?? datetime22.3); format time datetime22.3; run; The output looks like this, where the first column is the variable timestamp, and the second column is the variable time.   I appreciate any advice!   ... View more

Some of my variables have a space before the period, like this:   word .word word .word I would like them to look like this: word.word word.word I'm trying to use prxchange, but it's not working.    prxchange('s/ \w+ \./\w+\./', -1, variable); What am I doing wrong??     ... View more

I have a character variable that looks like this:   Var1 Order1 order2 OR order 3 Something else Order3 or Order5 Text3 Order4 Or Order8   How do I select just the observations that contain 'or' in the middle of the text string, which could between two, three, or four words? Moreover, is there a way for it not to be case sensitive? I tried proc sql: proc sql; select * from data where var1 like '%OR%' or var1 like '%or%' or var1 like '%Or%; quit; But that includes records which have the word 'Order', which I don't want. I thought maybe SAS would recognize the Or if I put a space around it: proc sql; select * from data where var1 like '% OR %' or var1 like '% or %' or var1 like '% Or %'; quit; But it doesn't. I really don't want to write the text out in full, because it's very long. I appreciate any help.    ... View more

I have a variable with a long text string:     Text something 1- something 2 some 4 text2-text3-text4-text5   SAS prints the text to look like this: Text something 1 - somet some 4 text2-text3-text4-text SAS will not print the variable with the updated length, despite recognizing in proc contents that I've changed the length, the format length, and the informat length to 32 characters (the text doesn't exceed 32 characters). This was the code I used:   data want; length Text $32; format Text $32.; set have; *** code *** informat Text $32.; run;   In the past, I've never had to use a special option in proc print to print the full variable with the updated length. But I tried:   proc print data=have width = full; run; and it didn't work. Any ideas?  ... View more