selecting one column values based on difference between members of another column

Reply
Occasional Contributor
Posts: 12

selecting one column values based on difference between members of another column

hi to all,

i have data like this

ASSAY MP  chr#

XY1723 408068 1

XY1727 463360 1

XY1708 880744 1

XY1709 900596 1

XY487 1174585 1

XY1641 1239146 1

XY1714 3057570 1

XY1721 3522443 1

my aim is to select ASSAY on every CHR# like this i have 12 chromosomes (values in column C), The criteria to select assay column is, i want to select Assay based on MP column and i want to select ASSAY after a range of every 250,000 (hundred thousand, 100kb) value in MP column . For example if i select XY1723 and i want to select next memebr of assay column having MP column value should equal to 563360 may little less or more. How can we solve this in SAS presently i am using excel for this and it is taking lot of time. any help would be highly appreciated, Thanks,

Genetist

Respected Advisor
Posts: 3,887

Re: selecting one column values based on difference between members of another column

How do you get from a value of "408068" for ASSAY "XY1723" to a value of "563360" while talking of 250T ranges? Can you please elaborate and show us the exact calculation? Also: Is the starting point for these ranges the lowest MP value or something else.

I assume what you call "column C" is "chr#" and you're referring here to the column name in your Excel sheet.

Occasional Contributor
Posts: 12

Re: selecting one column values based on difference between members of another column

Dear Patrick,

thank you very much for your reply to my query, I am sorry C column means Chr# only,
i get from a value of "408068" for ASSAY "XY1723" to a value of "658068 (408068+250000)" not the "563360" and it may little less or more (no need tobe eaxctly same 658068) and i miss typed it and starting point is lowest MP value beasuce data was sorted MP and chr# coulmns. I want to select assays having 250000 MP differences for 1 in chr# column and then i want to repeat this upto 12 in chr# column because i have 12 numbers in chr# column basically i will treat all the assays having 1 in chr# column as one block and i select assays having 250000 MP differences in that block ans then go to 2nd block (assays having 2 in chr# column) and applying same procedure as we did before and want to repeat upto 12 in chr# column.

Thanking you very much,

Regards,

Genetist

Ask a Question
Discussion stats
  • 2 replies
  • 233 views
  • 0 likes
  • 2 in conversation