w********u
发帖数: 328 | 1 Box # Contents
1 09005332-09005344
2 09005357-09005368
3 09005783-09005795
4 09005772-09005782
5 09005842-09005833
6 09005830-09005841
7 09005310-09005320
8 09005321-09005331
9 09005345-09005356
10
11
12
of course, this list is extremely long, in the colume 'content', actually it
's a range from the first number(min) to the second number(max). now, i have
a couple of numbers, i want to find out which | b*****o
发帖数: 482 | 2 data a;
set a;
min=1*substrN(contents, 1, 8);
max=1*substrN(contents, 10, 18);
if min
run; | l**********9
发帖数: 148 | 3
Oh!great code! Can it be shorter?
【在 b*****o 的大作中提到】
: data a;
: set a;
: min=1*substrN(contents, 1, 8);
: max=1*substrN(contents, 10, 18);
: if min: run;
| w********u
发帖数: 328 | 4 i think i should use loop or sth. like that because i'm searching this
number row by row
and if i can find out which range the particular number is in, i want to
have its corresponding box # as a return, how can i do that?
only '.....then output' doesn't work. thanks. | l**********9
发帖数: 148 | 5 Y it doesn`n work? Do you mean you only want to out put box# without showing
Contents? Then you can try
data box(keep=box#)
....
..
.
this data set will only contain the 'box#' | w********u
发帖数: 328 | |
|
