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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.