topic Re: How to create a dataset with values that range around values in a smaller dataset? in Advanced Programming

How to create a dataset with values that range around values in a smaller dataset?

Ani7 — Mon, 01 Feb 2021 17:48:24 GMT

I have a dataset that contains a range of IDs in numeric format that looks like this:

How would I create a dataset that essentially has all values that are within 2 values of the ID in the above table? The final table should look like this

ID
2
3
4
5
6
96
97
98
99
100

Re: How to create a dataset with values that range around values in a smaller dataset?

CarmineVerrell — Mon, 01 Feb 2021 18:12:25 GMT

/*Two options below..*/

/*First option is with Macro variables, you create two macros, start and end and assign values */

%let Start=4;
%let end=98;

Data file1(drop=i);
do i=&start to &end;
Id=i;
output;
end;
run;

/*Second option would be to use your datasource that has two observations in sorted order */
Data source;
ID=4;
output;
ID=98;
output;
run;

Data file2(drop=i);
set source end=eof;
retain start end;
if _n_=1 then start=id;
else end=id;
if eof then do;
do i=&start to &end;
Id=i;
output;
end;
end;
run;

Re: How to create a dataset with values that range around values in a smaller dataset?

Reeza — Mon, 01 Feb 2021 18:20:07 GMT

data want;
set have;

do i= (ID-2) to (ID+2) by 1;
      output;
end;

run;

If you need account for values less than 0 you may need to add in some more checks, but otherwise this should work.

@Ani7 wrote:

I have a dataset that contains a range of IDs in numeric format that looks like this:

ID

4

98

How would I create a dataset that essentially has all values that are within 2 values of the ID in the above table? The final table should look like this

ID

2

3

4

5

6

96

97

98

99

100