Help using Base SAS procedures

PROC SQL CAST

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

PROC SQL CAST

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

 


Accepted Solutions
Solution
‎01-20-2017 12:34 PM
Super User
Posts: 7,762

Re: PROC SQL CAST

input(B,best.) as amount
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎01-20-2017 12:34 PM
Super User
Posts: 7,762

Re: PROC SQL CAST

input(B,best.) as amount
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 42

Re: PROC SQL CAST

Posted in reply to KurtBremser

Great,

 

Thank you Kurt!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 2229 views
  • 1 like
  • 2 in conversation