I am creating 3 tables using proc sql and I want to create a new column for each of them. I just know case when to create column based on different conditions. But here, I only want to create one to work like a lable: new column=secure the value would be Y
It may help to provide some example data of what one of the sets looks like and what the desired result.
If you want to create variable with the same value for everyrow the easiest is to have something like this in the Select clause:
"Y" as new_var
create table work.new as
select *, 'Y' as new_var
A little confused about the question. But you can also add a new variable like this, using alter table and add. This would be in SAS, code is to add a new character variable, length 9, called staffID
alter table work.sqlinsas
add staffID char 9
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.