How do you create two variables simultaneously using proc sql?

Haze — Wed, 05 Feb 2014 11:00:06 GMT

I am fairly new to proc sql and would like to know if there is a way to create two variables at the same time in the same line.

Below is an example of what I am trying to achieve. It's a simplified version of my code (which would bring in a number of different datasets).

I would like to create the variables trtsta and trtsdt to be the same, in a neat way.

proc sql;
create table data_test as
select catx(" ", a.trt, max(a.dose), a.dosu) as trtsta /*and trtsdt*/
from dataset1 as a

order trtsta;

quit;

I know I can do this by the below code, but I wondered if there was a smarter way of doing it?

proc sql;
create table data_test as
select catx(" ", a.trt, max(a.dose), a.dosu) as trtsta,

catx(" ", a.trt, max(a.dose), a.dosu) as trtsdt
from dataset1 as a

order trtsta;

quit;

Thanks for any ideas!

Re: How do you create two variables simultaneously using proc sql?

LinusH — Wed, 05 Feb 2014 11:22:14 GMT

Use

calculated trtsta as trtsdt