08-20-2015 03:04 PM
Can I put both and Character and Numeric under the same variable and assign the variable type as Numeric? I wanted to merge these two table with set command and it says Table 1 code is Numeric and Table 2 Code is Character.
Can I merge them like this with a set command so that all codes come?
08-21-2015 03:14 AM
No. A variable defined as numeric can only hold numerical values.
08-21-2015 05:09 AM
As has been mentioned above structurally you can only have a column which is of character or numeric. You can however do this in one step:
input code $ name $;
create table WANT as
select put(CODE,1.) as CODE,
"" as NAME