hi,   I have 2 character columns in a table, and am tring to combine the 2 columns into new column, like I can concatenate in excel. How can i combine the 2 with SQL query?   Thanks, SKP   ... View more

Hi,   I'm trying to append data from one table to the other and create new table with UNION ALL query, but got the error which seems to be due to NULL value in one of the field. Can someone please let me know how I should do this?   Here is what I am trying to do: In table 1, I have Customer ID Cutomer Name Location Product ID Purchase amount in Jan Purchase amount in Feb Purchase amount in March Purchase amount in April   In table 2, I have Cutomer Name Product ID Purchase amount in Jan Purchase amount in Feb Purchase amount in March Purchase amount in April   I'm trying to append data in table 2 to table 1, and rename it as C.   Thank you for your help. SKP     ... View more

Hi,   I imported a data from excel file into SAS dataset, and I had month name (e.g. Jan, Feb) in one of the fields.  When I imported it, the fields was imported as Character, but I'd like to change it to date (MONNAME3.) format.  I tried it to change in "Property" tab, and under "General" -> "Group" to Date, but I saw only Character in Group.  Can someone help me how I can change it?   Thanks. ... View more

Hi,   I'm tyring to conver month number (e.g. 1,2,3) to name (e.g. JAN, FEB, MAR) in a field "Month" which is character field. I tried below code;   Proc Format;  INVALUE Month '1'='JAN', '2'='FEB','3'='MAR', Run;   But it got errored out and error says that 'JAN' was not acceptable format.  I'm not sure what that means.... Does anyone how to fix this or know a batter to do?   Thanks, SKP ... View more