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: 17,851

Re: Assigning data types in PROC SQL

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: 17,851

Re: Assigning data types in PROC SQL

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
  • 212 views
  • 0 likes
  • 2 in conversation