Question: Please help me with the query 
Below are the table and requirement details

[![enter image description here](https://i.stack.imgur.com/ux4O6.png)](https://i.stack.imgur.com/ux4O6.png)

Answer: 
Case statement constructs one variable.

For your example you can try this, with one statement of Case :

```
data example;
  input x $;

  datalines;
  A
  A
  A
  B
  B
  ; 
run;

proc sql;
  create table make_two_from_one_2 as
  select *
  , case
      when x = 'A' then 'Result1A,Result2A'
      when x = 'B' then 'Result1B,Result2B'
      else 'Error'
    end as thing0

  from example
  ;
quit; 

data example1(drop=thing0);
  set make_two_from_one_2;
  thing1=scan(thing0,1,',');
  thing2=scan(thing0,2,',');
run;

```
In your case, maybe you could try this:

```
proc sql;
  create table make_two_from_one as
  select *
  , case
      when x = 'A' then 'Result1A'
      when x = 'B' then 'Result1B'
      else 'Error'
    end as thing1,
    translate(calculated thing1,'2','1') as thing2
   from example
  ;
quit; 

```