topic how to generate new variable using sql in SAS Programming

how to generate new variable using sql

akhilbattu — Thu, 17 Nov 2022 08:45:59 GMT

Re: how to generate new variable using sql

PeterClemmensen — Thu, 17 Nov 2022 08:49:09 GMT

Do you simply want to generate a new variable or is there more to the question?

Re: how to generate new variable using sql

feige — Thu, 17 Nov 2022 09:49:31 GMT

Use the following sample code:

proc sql;
select col1 into :var1 separated by ',' from lib1.table1;
quit;

if handle multiple columns into multiple variables, you can input the below code:

proc sql;
select col1,col2 into :var1, :var2
from table1;
quit;

Maybe you could look up SAS Documentation helper and find the appropriate answers.

Re: how to generate new variable using sql

ballardw — Thu, 17 Nov 2022 16:53:59 GMT

Generic:

Proc Sql;
   create table wanted table as
   select <expression> as variablename
   from <some sort of source expression like a data set goes here>
  ;
quit;

Expressions could be just about any manipulation of one or more variables.

Re: how to generate new variable using sql

Tom — Thu, 17 Nov 2022 16:57:23 GMT

@feige wrote:

Use the following sample code:
proc sql;
select col1 into :var1 separated by ',' from lib1.table1;
quit;
if handle multiple columns into multiple variables, you can input the below code:
proc sql;
select col1,col2 into :var1, :var2
from table1;
quit;
Maybe you could look up SAS Documentation helper and find the appropriate answers.

That is not generating any variables. The first one will populate a MACRO VARIABLE. The second one will fail because the list of values to select goes BEFORE the INTO and the list of target macro variable names goes AFTER the INTO.

Re: how to generate new variable using sql

Sajid01 — Fri, 18 Nov 2022 01:03:58 GMT

The following code generate a new variable BMI using SAS Proc SQL

proc sql;
select name, age ,height, weight ,703*weight/(height**2) as BMI format z5.2 
from sashelp.class;
quit;