🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 01-27-2017 12:26 PM
(110974 views)
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.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc sql;
create table myNewData as
select
input(numberStr, best.) as myNumber,
shortStr as longStr length=32
from myData;
quit;
PG
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc sql;
create table myNewData as
select
input(numberStr, best.) as myNumber,
shortStr as longStr length=32
from myData;
quit;
PG
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Just a slight comment
You can use the same name
input(mynumber,5.) as mynumber length=4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, figured as much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you.