Computing the start of the gene neighborhood

We are looking at both coding and non-coding SNPs, so we need the gene neighborhood, not just the gene. We will define the gene neighborhood as within one hundred kilobases of the gene.

To get these neighborhoods we will use the Compute tool in the Text Manipulation section. First compute the new start position by subtracting one hundred kilobases from the column with the start position (c2). We want integers so choose YES for Round result and click Execute.

To compute the new end position run the Compute tool again this time with the expression "c3+100000" and the result of the first Compute as the dataset. Again choose YES for rounding and click Execute (not shown).