Hi!   I have a messy time date variable in a character string.   the orignal values look like this...   Inc 291900MAR07 142300APR07 03APR07 10APR07   I'm creating two  separate variables (date_var time_var) from the original variable (inc)  In the values with the longer string the first two numbers are actually the day, and the 3-6 is the time.  Many of the values do not have a time entered.  What I want to do is have the time variables set to missing if the time is missing.   So, to create the date_var I did this (and it worked fine) data want ; set have (keep=rescuereportid inc); inc=compress(inc); date_var=substr(inc,1,2)||substr(inc,max(1,length(inc)-4)); run;   How can I create a time variable with variables that are different in length (i don't want to write over values that have existing time vlaues)?  Want to look like this....   Orig_Var Date_Var Time_Var 291900MAR07 29MAR07 1900 142300APR07 14APR07 2300 03APR07 03APR07 . 10APR07 10APR07 .   Help is appreciated!               ... View more

Hi!   Is it possible to change a range of variables (namepers1-namepers3)  currently a character string spearated by delimiter "/"   I was able to do it for one variable at a time...but for efficiency, is there a way to do Namepers1-namepsers3 in one datastep?   All the values in each variable are the same character string format...   data rr.namepers2006; set sar_raw.rr2006 (keep=namepers1-namepers3) ; array new_var(*)$ last rank grade; i=1; do while(scan(namepers1, i, "/") ne ""); new_var(i) =scan(namepers1, i, "/"); i+1; end; run;      thank you!     ... View more

Hi!   I have some character values for varialbe FlightHrs   1.2   new format  => 1.20 1.30 => 1.30 1.42 => 1.42 1.3 =>    1.30   I would like to make all the values numeric format (4.2?) with added zero at the end if missing.   I tried this, but no success flighthrs=input(flighthrs,4.2);   Thanks you! ... View more

I have a date/time character string that looks like this:   02OCT07:2240 03APR07:1825 02OCT07:2240   I need some help converting this into a datetime sas format.  I think some combination of input and scan?   Help is appreciated!         ... View more

Hi!  I have compressed date/time variables in a character string with values that now look like this:     312140AUG07 311415MAY08 092105MAR07   The first two numbers are the day(date). 3-6 is the time.  THen month and year....   I would like it to look like this format DDMMMYY:HHMM   What I am doing is not working.  Appreciate your help!!     data rr.datetime2006 (keep=Inc Alert Launch OnSce Locate Recov Deliv RTB);     set rr2006labels;         array change _character_;         do over change;         change=compress(change,'');         day=substr(change,1,2);         time=substr(change,3,4);         month=substr(change,7,3);         year=substr (10,2);             date=catt(day,month,year);             change=catt(date,time);  *want this to look like DDMMMYY:HHMM; end;     run; ... View more

Hi!   I have a variable: Report_Num   Character values should be xx-xxx (e.g 07-041)  BUT some values have an extra character at the end (eg. 07-055D). Is there a way to strip off that last character for some of these values?   Thanks!     ... View more