cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tadedir1
‎09-15-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Pulling certain observations based on a cut off in a large dataset

by Calcite | Level 5 in New SAS User
‎09-15-2019 07:40 PM
‎09-15-2019 07:40 PM
Expected output  Option: Set those with cut off less than 0.8 as missing    Study Number A B C D E F 1 1 0.98 0.99 0.98 .8 0.98 2 . 1 1 . 1 1 3 1 . 1 1 1 1   or    Have 6 different tables only displaying the cutoffs greater than or equal to 0.8   Study Number A B C D E F 1 1 0.98 0.99 0.98 .8 0.98 2 .6 1 1 .4 1 1 3 1 .3 1 1 1 1    Study Number      a 1                           1 3                           1   study number       b 1                          0.98 2                           1   study number        c 1                           0.99 2                           1 3                           1 ... View more

Re: Pulling certain observations based on a cut off in a large dataset

by Calcite | Level 5 in New SAS User
‎09-15-2019 07:19 PM
‎09-15-2019 07:19 PM
Yes I want to drop observations that don't meet the 0.8 criteria.     ... View more

Re: Pulling certain observations based on a cut off in a large dataset

by Calcite | Level 5 in New SAS User
‎09-15-2019 07:14 PM
‎09-15-2019 07:14 PM
When I run the arrays displayed above: I'm still pulling variables that are less than 0.8. ... View more

Re: Pulling certain observations based on a cut off in a large dataset

by Calcite | Level 5 in New SAS User
‎09-15-2019 05:52 PM
‎09-15-2019 05:52 PM
If you had 8,000 columns, do you have to write out each variable name (i.e. vars (*) A B C D F...8000) or is there a faster way to doing it this way? ... View more

Pulling certain observations based on a cut off in a large dataset

by Calcite | Level 5 in New SAS User
‎09-15-2019 05:29 PM
‎09-15-2019 05:29 PM
Hi,   I currently have dataset with 388 observations(rows) and over 8,000 variables of interest(i.e. columns). The data is in a matrix form. The row contains study numbers and each column is a  gene. Each cell contains a ratio from 0 to 1. I want to tell SAS for each column pull study numbers that greater than 0.8. I've been manually doing this and I am not sure if there is a more efficient way of doing this. I am not familiar with sas macros or arrays. Below is a table of the data structure.    Study Number A B C D E F 1 1 0.98 0.99 0.98 .8 0.98 2 .6 1 1 .4 1 1 3 1 .3 1 1 1 1 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-15-2019 11:01 PM
Quick links