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
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.
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.