topic Re: Assigning data types in PROC SQL in SAS Programming

Assigning data types in PROC SQL

PhatRam33 — Fri, 18 Mar 2016 17:38:11 GMT

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 😃

Re: Assigning data types in PROC SQL

Reeza — Fri, 18 Mar 2016 17:51:56 GMT

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

Re: Assigning data types in PROC SQL

PhatRam33 — Fri, 18 Mar 2016 18:22:11 GMT

Worked like a charm! Thank you very much!