I have a ID variable of text type as below   020011 020028 020036 020029 020013   I want to convert it into the following by adding a "-" in between 02-0011 02-0028 02-0036 02-0029 02-0013   Thank you so much! ... View more

Hi all,   I have a date and time fields, both are Text data type   C_Date looks like 18/06/19  (YY/MM/DD) C_Time looks like 12:30:48   I need to convert the above 2 text fields into one DateTime field (datetime20.), like 19JUN2019:12:30:48     Thank you!! ... View more

  Hi all,   I have a sig_Date variable of type YYMMDD10. and a sig_Time variable type TIME5. Like  sig_Date 2018-09-10  sig_Time 11:22   I want to combine them into 1 variable called sig_DateTime like 2018-09-10 00:11:22 using function  sig_DateTime = dhms(sig_Date,0,0,0)+ sig_Time; format sig_DateTime is8601da.;   what I got is something like ********** Can someone tell me where I am wrong and I have been using this function for all the data and time to DateTime conversion, it all works well until this one      Thanks as always ... View more

  Hi all,   Is there a SAS format to make the date appearing as shown below:   04-Sep-2017 14-Jun-2015 21-May-2016   Thanks zimcom ... View more

Hi Community,   I received 30 plus SAS datasets and want to quickly retrieve all the variable names of each datasets    Is there a quick way to do this?    Thanks as always ... View more

  Good Friday everyone!   I use ODS excel to generate a report, but the text in some of the columns got automatically wrapped like the example below:    Worsening of Congestive heart failure Cardiac failure congestive   Is there a way to control not let the ODS wrap the text, or I can control the width of the columns through style (data)?   Thanks!   ... View more

Hi all,   I have a dataset with a variable birthday saved as text type (bithday_old) and I want to convert it to bithday_new using 15 of the month and make it as number type so that I can calculate the age bithday_old bithday_new 1947/02 1947-02-15 1970/06 1970-06-15 1953/08 1953-08-15 1940/12 1940-12-15 1930/01 1930-01-15 1961/02 1961-02-15 1964/02 1964-02-15 1964/12 1964-12-15   Thank you fo ryour help as always   ... View more