DATA Step, Macro, Functions and more

Assigning data types in PROC SQL

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

Assigning data types in PROC SQL

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 =)


Accepted Solutions
Solution
‎03-18-2016 02:22 PM
Super User
Posts: 19,817

Re: Assigning data types in PROC SQL

Posted in reply to PhatRam33

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

View solution in original post


All Replies
Solution
‎03-18-2016 02:22 PM
Super User
Posts: 19,817

Re: Assigning data types in PROC SQL

Posted in reply to PhatRam33

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
Contributor
Posts: 23

Re: Assigning data types in PROC SQL

Worked like a charm! Thank you very much!

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 221 views
  • 0 likes
  • 2 in conversation