How to create a variable with values as 1 in proc sql

[saikiran_nemani]

How to create a variable with values as 1 in proc sql

[ChrisHemedinger]

I'm guessing that you want to create dummy variables to prep data for modeling.

You can do this with simple boolean expressions.  Example:

proc sql;
 create table dummy_class
  as select name, age,
   sex="M" as isMale,
   sex="F" as isFemale
 from sashelp.class;
quit;

[RW9]

Please post a clear example of what you have - test data in the form of a datastep - and what you want out at the end.  Otherwise you will not get good answers.  Simply:

proc sql;
  create table want as
  select *,
         1 as new_var
  from   have;
quit;

[SuryaKiran]

If your trying to create a new variable on a condition on other variable then you can use a case expression.

proc sql;
select *, Case  when Age>15 then 1 
				when Age<13 then 0
			else 2 end as new_var
	from sashelp.class;
quit;

[Reeza]

Homework question?

https://communities.sas.com/t5/General-SAS-Programming/How-to-create-a-table-of-0s-and-1s-using-proc...

[TomKari]

If you just want a variable that's always 1:

proc sql noprint;
	create table want as select name,
		1 as OneVar
	from sashelp.class;
quit;

Tom