Help using Base SAS procedures

How do you create two variables simultaneously using proc sql?

Reply
N/A
Posts: 1

How do you create two variables simultaneously using proc sql?

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!

Super User
Posts: 5,441

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

Use

calculated trtsta as trtsdt

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 166 views
  • 1 like
  • 2 in conversation