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: 
mikeed
‎07-15-2020
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

How do I condition on a different observation?

by Calcite | Level 5 in SAS Programming
‎07-15-2020 12:08 PM
‎07-15-2020 12:08 PM
I'm examining a dataset where everyone within the same household has the same ID, but different person numbers (PNUM).   They also have marital status pointers that point to PNUMs of their spouses.   I want to check if a persons spouse has some other condition.   What's the best way of going about this? ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-13-2018 01:51 PM
‎04-13-2018 01:51 PM
I'm sorry, your code was not detailed enough and did not work since it did not help me tally the MONTHs that I needed to find the statistics for. ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-13-2018 11:16 AM
‎04-13-2018 11:16 AM
For each ID, I'd would like to add up all the VALUES, from MONTH 1 to MONTH 12, for an annual VALUE. Then I would like to find summary statistics of annual VALUE for each ID.   Perhaps this explains it better and it can't be accomplished in a single procedure, and that's my problem? ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-13-2018 08:27 AM
‎04-13-2018 08:27 AM
I don't need to use Univariate, but I'm still having difficulty trying to figure out how to determine the annual values of the summary statistics    Help still requested. ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-12-2018 02:27 PM
‎04-12-2018 02:27 PM
thanks, would you be able to provide an example of the proc univariate code I would use? ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-12-2018 02:23 PM
‎04-12-2018 02:23 PM
ID MONTH VALUE 1   1             65 1   2             17   .    .               . 1   11           47 1   12           99     2   1             55 2   2             98  .    .               . 2   11            45 2   12            18   3 ... ... View more

Re: Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-12-2018 02:20 PM
‎04-12-2018 02:20 PM
sorry, typo. all 12 months.   each person has a unique ID and MONTHCODE variable from 1-12. I want to sum the VALUEs of MONTHCODE1-12 for each person, then determine mean/median annual VALUE.   ... View more

Proc Univariate help for a newbie

by Calcite | Level 5 in SAS Procedures
‎04-12-2018 02:06 PM
‎04-12-2018 02:06 PM
I'm working with a very large dataset and it has a MONTH variable from 1-12, and also a VALUE variable, with amounts possible for each month.   I would like to determine mean, median, etc. for a yearly (annual) amount, summing each person's (observation) for 2 months of values.   What's the easiest way for a noob to do this? Thanks in advance... ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-15-2020 05:55 PM
Likes given to
View All
Quick links