topic PROC SQL CAST in SAS Procedures

PROC SQL CAST

fabdu92 — Fri, 20 Jan 2017 17:25:17 GMT

Hi,

I have this kind of proc sql

PROC SQL;
CREATE TABLE B1 AS
SELECT A AS TYPE,
B AS AMOUNT
FROM WORK.A1;
QUIT;
RUN;

I would like to cast B in integer. For now it's a varchar. And I would like to do it inside this proc sql if possible. Is it possible?

Thanks for answers

Kurt_Bremser — Fri, 20 Jan 2017 17:32:00 GMT

input(B,best.) as amount

fabdu92 — Fri, 20 Jan 2017 17:35:28 GMT

Great,

Thank you Kurt!