How do you create two variables simultaneously using proc sql?

[Haze]

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!

[LinusH]

Use

calculated trtsta as trtsdt