Hello,
I have an existing table that I want to add a blank column to. Below is an example of what it looks like right now. I don't know what to write out as the format if I'm trying to make it a character field and not numeric.
proc sql;
alter table lib.metadata_match_test
add test char format=.;
quit;
Thanks!
Not the way I would do it, just add this into any other step in your process, bit of a waste having a step just to add an empty variable. Anyway, strings are $ followed by a number refering to the length, e.g $20, means a string of length 20.
Not the way I would do it, just add this into any other step in your process, bit of a waste having a step just to add an empty variable. Anyway, strings are $ followed by a number refering to the length, e.g $20, means a string of length 20.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.