Assigning data types in PROC SQL

[PhatRam33]

I'm using PROC SQL and my question is what is the correct syntax to assign a dataype to a field?  Kept receiving errors when trying to run this piece of code below.

Here is a simplified example:

proc sql;

create table work.test2 as

select

t1.activity_type varchar(50)

from

work.test as t1

;

quit;

Thanks in advance 😃

[Reeza · Accepted solution]

If you just select an existing variable it keeps the same type as the source table.

To convert it, in SAS use INPUT/PUT to convert. 

In a database language this would be the equivalent of CAST or TO_CHAR functions.

put(t1.activity_type, $50.)  as activity_type

[PhatRam33]

Worked like a charm! Thank you very much!