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,
Thanks in advance.
proc sql;
create table myNewData as
select
input(numberStr, best.) as myNumber,
shortStr as longStr length=32
from myData;
quit;
proc sql;
create table myNewData as
select
input(numberStr, best.) as myNumber,
shortStr as longStr length=32
from myData;
quit;
Just a slight comment
You can use the same name
input(mynumber,5.) as mynumber length=4.
Thanks, figured as much.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.