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: 
SAS_taozi
‎03-12-2024
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

wanted to know the simplest way to compute clopper Pearson confidence ...

by Calcite | Level 5 in SAS Programming
‎02-07-2024 07:42 PM
‎02-07-2024 07:42 PM
I wanted to compute clopper Pearson confidence interval for the all the variables I have and wanted to know what's the simplest way. A sample variable I have can be   ID test 1 Y 2 Y 3 N 4 . 5 . 6 N 7 N so among the 7 subjects, 2 were missing, 3 had no test, 2 had tested. I want to model the probability of being tested in SAS ... View more

tabulate using proc freq!

by Calcite | Level 5 in SAS Programming
‎02-07-2024 07:28 PM
‎02-07-2024 07:28 PM
I have this data:   Age  Pets  Country    height (cm) 35     3       US             165 65     2        UK            171 21     2        US            181 28     2        China       159 35     1        China       176 65     1        US             175 40    2         UK             178   And I want to summarize the variables using proc freq (so general summary statistics including n, mean,  median, std, q1, q3, min, max) by 3 groups, US, UK and China. A sample table is:     variable   Group     P-value     US UK China   age             n           mean           median           std           Q1, q3           Min,max         Height             n           …           The aesthetics can be different by methods and preferences but wanted to know how should I organize the data and merge them into this desired way (summary statistics for each variable in rows, by country in columns). Ideally I want to use proc report to generate the table but if it's too much, I want to know how to most efficiently merge the table at least. Thank you so much!! Discussion is welcomed   ... View more

How to use 'group by' for different situations in one step?

by Calcite | Level 5 in SAS Programming
‎07-18-2022 08:16 PM
‎07-18-2022 08:16 PM
I have a dataset below and would like to how to get the minimum price each month. The product could only be possibly priced in one of the months. So if the product has been priced in June, I would like to get the minimum price by product ID in June; if the product has been priced in July, then the minimum price by product ID in July should be attained. ID          June         July 1            25            . 1            24            . 1            26            . 2            .               34 2            .               37 3            .               56   The desired the dataset I want to generate would be: ID          June         July 1            24            . 2            .               34 3            .               56   I tried to do two if ... then do; group by ID; end; BUT the error shows up like " More than one BY statement specified for a SET, MERGE, UPDATE, or MODIFY statement." I am wondering how to solve this... Many thanks for anyone replies!   ... View more

What is the best way to create extra rows by swapping variables?

by Calcite | Level 5 in SAS Programming
‎06-28-2022 12:48 PM
‎06-28-2022 12:48 PM
Hi everyone,   I need to create extra rows by swapping variables. For example, I have a dataset with two variables first name and last name: firstName lastName Sara        Daner   And I want an extra row by swapping first name and last name, desired dataset will be like: firstName lastName Sara        Daner Daner      Sara   What is the best way to do it? Thanks!     ... View more

Re: How to test the occurrence of a certain value before the occurrenc...

by Calcite | Level 5 in SAS Programming
‎03-23-2022 05:18 PM
‎03-23-2022 05:18 PM
Hi there, you are correct, the data should not go from 1 to 0, is should only go from 0 to 1... I guess it's a manual error when recording. I just want to check the overall data quality... when there is data go from 1 to 0, I need to what are the IDs for them, so I could manually check on them again. But I need a list of IDs at least...I don't want to check on every equipment. ... View more

Re: How to test the occurrence of a certain value before the occurrenc...

by Calcite | Level 5 in SAS Programming
‎03-23-2022 04:22 PM
‎03-23-2022 04:22 PM
Hi there, thanks very much and for the detailed explanation. I guess first. and last. would not suffice what I want here... Another example I had is:   Obs ID Status 1      5    0 2      5    1 3      5    0 4      5    1 5      5    0 So the status actually changes intermittently, I definitely need to manually review it, because for obs 2 and obs 3, status = 1 already occurred but followed by a status = 0. It does not make sense, because for our equipment, once activated, it is not even feasible to deactivate it.... Do you have any ideas to solve this problem? Thanks! ... View more

Re: How to test the occurrence of a certain value before the occurrenc...

by Calcite | Level 5 in SAS Programming
‎03-23-2022 04:17 PM
‎03-23-2022 04:17 PM
Hi there, thanks very much for your reply! I actually only want one check value per ID, like an overall check score... which means if it's 1 then change to 0, it should be 0 for this ID since it is not qualified. Is there a way to do it? Thanks! ... View more

How to test the occurrence of a certain value before the occurrence of...

by Calcite | Level 5 in SAS Programming
‎03-23-2022 03:00 PM
‎03-23-2022 03:00 PM
Hi all,   I have a long table (group data) of activation status for equipments  we have. Different status 1 = activated 0= not activated. We have measurements across all time points. I wanted to know whether if the occurrence of 0 is before 1 for all equipments (if 1 occurred before 0, meaning that it was activated but later on it's not activated any more, that does not make sense, right? for such data, I need to manually review them). Below is an example:   ID Status 1   0 1   0 1   0 1   1 1   1 2   0 2   1 4   1 4   0 4   0     What I want is .... ID Status Check 1   0         1 1   0         1 1   0         1 1   1         1 1   1         1 2   0         1 2   1         1 4   1         0 4   0         0 4   0         0   different equipments may have different numbers of records... Do anyone know how to do this? very much appreciated!     ... View more

how to test whether a variable equal to the same value by group?

by Calcite | Level 5 in SAS Programming
‎03-23-2022 02:30 PM
‎03-23-2022 02:30 PM
Hi All, I am dealing with a long table (group data) of purchase records. I want to know for each customer, whether they have the exactly same purchase price every time of their visits. Let's say my goal is to test whether the purchase price is $10 for each customer each time they visit.. Below is an example:   ID Price 1   3 1   4  1   3 2   5 2   5   And what I want is ...   ID Price  Same_Price_equal_to_10 1   3       0 1   4       0 1   3       0 2   5       0 2   5       0 3   10     1 3   10     1 3   10     1 3   10     1 Note that if this customer has persistent purchase price of 5... is not nothing I wanted. I want to set a target for the purchase price and only if this targeted purchase price is consistent all the time would be something I wanted... Anyone could help me with that? Very much appreciated! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-12-2024 04:09 PM
Likes given to
View All
Quick links