Select values between to numeric columns

Sniekp — Tue, 13 Jul 2021 09:03:14 GMT

I haven't been working with SAS for very long and I'm really struggling with the following problem. (SAS enterprise guide 7.1)
I have a table named CONTROLE
select * from CONTROLE 
gives the following result (all numeric)

CONTROLE | BEGIN | END
17135 | 40 | 45

17136 | 46 | 48

I want to transform this into

CONTROLE | RANGE

17135 | 40

17135 | 41

17135 | 42

17135 | 43

17135 | 44

17135 | 45

17136 | 46

17136 | 47

17136 | 48

is there a simple solution?

Re: Select values between to numeric columns

Kurt_Bremser — Tue, 13 Jul 2021 09:17:56 GMT

Yes, there is 😉

A simple data step DO loop will do it:

data have;
input CONTROLE $ BEGIN END;
datalines;
17135 40 45 
17136 46 48
;

data want;
set have;
do range = begin to end;
  output;
end;
keep controle range;
run;

topic Re: Select values between to numeric columns in SAS Data Management

Select values between to numeric columns

Re: Select values between to numeric columns