BookmarkSubscribeRSS Feed
genetist
Calcite | Level 5

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

2 REPLIES 2
Patrick
Opal | Level 21

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.

genetist
Calcite | Level 5

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 487 views
  • 0 likes
  • 2 in conversation