topic Re: How to create a variable with values as 1 in proc sql in SAS Enterprise Guide

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

saikiran_nemani — Tue, 29 May 2018 12:32:57 GMT

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

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

ChrisHemedinger — Tue, 29 May 2018 12:41:53 GMT

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;

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

RW9 — Tue, 29 May 2018 12:56:34 GMT

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;

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

SuryaKiran — Tue, 29 May 2018 13:19:26 GMT

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;

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

Reeza — Tue, 29 May 2018 14:42:20 GMT

Homework question?

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

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

TomKari — Tue, 29 May 2018 15:56:48 GMT

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