SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Re: Create a new variable based on value of a specific observation in another variable

Reply
Trusted Advisor
Posts: 1,204

Re: Create a new variable based on value of a specific observation in another variable

Another way to do this...

proc sql;
select x1, y1 into :x2, :y2 from have
where group=2;
select x1, y1 into :x3, :y3 from have
where group=6;
quit;

data want;
set have;
x2=&x2;
y2=&y2;
x3=&x3;
y3=&y3;
run;

Ask a Question
Discussion stats
  • 0 replies
  • 184 views
  • 0 likes
  • 1 in conversation