Date is formatted as such: 25JAN2018 and Time is formatted as such: 16:18:23   Trying to return a new field to where datetime is returned: 25JAN2018 16:18:23   I tried a cast function on both fields and attempted to combine and no such luck.  Is there anyway to do this in PROC SQL?   Thanks in advance.     ... View more

Is there a way in PROC SQL to split a string that contains commas so that the end result is displayed as a single value on each row?   example:   Variable1 1111,2222,3333,4444, 6666,7777,8888, 5555,9999   Need to return as: Variable1 1111 2222 3333 4444 6666 7777 8888 5555 9999   I tried using a scan function, however have not had much luck.  Any help would be greatly appreciated.  Thank you in advance.       ... View more

Using PROC SQL, is it possible to remove the Middle Initial (if it is present) from the created First_Name variable in the SQL below?   Example:   Smith, John M   SQL below returns Smith, John M John M Smith   Need to remove the middle initial 'M' where present from first_name   Here is what I have so far:   Select   FULL_NAME ,scan(FULL_NAME,-1,',') as first_name ,scan(FULL_NAME,1,',') as last_name FROM SAMPLE_TABLE   Thanks in advance.   ... View more

I'm using PROC SQL and my question is what is the correct syntax to assign a dataype to a field?  Kept receiving errors when trying to run this piece of code below.   Here is a simplified example:   proc sql; create table work.test2 as select t1.activity_type varchar(50) from work.test as t1 ; quit;   Thanks in advance 😃 ... View more

Is there a way to convert a field stored as a character/string and convert it into a date type field?   The database I'm pulling from has all date fields stored as character data types.   Example of how field is stored: 01/07/2016 17:44:32  Need to convert to date type to display as 07JAN2016.   Here was my first atttempt   ,input(substr(createtime,1,2) || substr(createtime,4,2) || substr(createtime,7,4), 10.) format=Date9. as TEST_DT   My end result was 30JAN4895 which is not correct =(.   Any help would be greatly appreciated. ... View more