Help using Base SAS procedures

Changing data types and lengths in a proc sql select statement?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Changing data types and lengths in a proc sql select statement?

Say, I have a source table with coumns of various data types and I want to create a second table by selecting some of those columns and changing their data types or lengths.

 

For example,

  • if I have a char column that has sotred numbers, how do I convert it to numeric so I can do calculations at a later date?
  • How do I expand the length of a char variable, say from char (8) to char (32) so I can concatenate more data later?

 

Thanks in advance.


Accepted Solutions
Solution
‎01-27-2017 10:22 PM
Respected Advisor
Posts: 4,936

Re: Changing data types and lengths in a proc sql select statement?

proc sql;
create table myNewData as
select
	input(numberStr, best.) as myNumber,
	shortStr as longStr length=32
from myData;
quit;
PG

View solution in original post


All Replies
Solution
‎01-27-2017 10:22 PM
Respected Advisor
Posts: 4,936

Re: Changing data types and lengths in a proc sql select statement?

proc sql;
create table myNewData as
select
	input(numberStr, best.) as myNumber,
	shortStr as longStr length=32
from myData;
quit;
PG
Valued Guide
Posts: 505

Re: Changing data types and lengths in a proc sql select statement?

Just a slight comment

 

You can use the same name

 

 input(mynumber,5.) as mynumber length=4.

Occasional Contributor
Posts: 18

Re: Changing data types and lengths in a proc sql select statement?

Posted in reply to rogerjdeangelis

Thanks, figured as much.

Occasional Contributor
Posts: 18

Re: Changing data types and lengths in a proc sql select statement?

Thank you.
☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 1414 views
  • 2 likes
  • 3 in conversation