@Davar wrote:
This is what I am trying to do T1.Count1 is a char value and I am trying to convert to Num.
I thought if I assign the new name count can work as show below:
CREATE TABLE AUTO.QUERY_FOR_BUS_DAY AS
SELECT t1.'Active_Messages'n,
t1.'Total_Active_Messages'n,
t1.Aging,
Count =input(t1.Count1, 4.),
t1.'Age_Date'n,
t1.'Report_Date'n,
Using a = like that in a select creates a boolean (true/false 1/0 valued) un-named variable that SAS will assign a name for.
Please see this example:
data have;
input x;
datalines;
1
2
;
run;
proc sql;
create table result as
select x, x=1
from have;
quit;
When I ran that on my install I get a variable name _TEMA001, YMMV.
... View more
