About weweaw

weweaw · ‎07-12-2018

Hello, I want to make indicator variables if the second two digits are a particular set. The variable its self it char. The numbers go from 0-9 for both positions. If it was h678 then I want to make an indicator var to be called _67 (or nit67) and that to be 1. I've been trying to make a do loop but cannot make it work. This is what I have: id nit 234 a019 453 b033 457 c101 And this is what I want: id nit _01 _02 _03 _04 _05 _06 _07 _08 _09 _10 234 a019 1 0 0 0 0 0 0 0 0 0 453 b033 0 0 1 0 0 0 0 0 0 0 457 c101 0 0 0 0 0 0 0 0 0 1 Thank you!

weweaw · ‎09-12-2017

Ok, I see where I changed it wrong. No error but total_sum is 0 for everything now and the other new variable i has odd numbers that my data could not sum to. data t3; set try1; array _h(*) hmo_1 - hmo_60; total_sum = 0; do i=biop_pr to biop; total_sum = sum(total_sum, _h(i)); end; run;

weweaw · ‎09-12-2017

Sorry I was using my ready data H_# is hmo_# and biop_pr is for the H-start and biop is for the H-stop.

weweaw · ‎09-12-2017

I'm confused. For every ID there is a different start and stop H variables. For "do i=h_start to H_end;" What do I put in the '_start' and the '_end'? Edit again to add the post I was referring to. data want; set have; array _h(*) h_1 - h_12; total_sum = 0; do i=h_start to H_end; total_sum = sum(total_sum, _h(i)); end; run; Edited to add: For A I need it to sum H_3 throught H_6, for B I need it to add H_2 though H_5, and C would be H_9 through H_12. The variable H-Start is the number of H_# I want it to begin summing and the variable H-end has the H I want it to stop at.

weweaw · ‎09-12-2017

I'm getting the error message (biop_pr is my var name for start number and biop is my variable for the stop value). NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 613:14 NOTE: Variable hmo_biop_pr is uninitialized. NOTE: Variable hmo_biop is uninitialized.

weweaw · ‎09-12-2017

I added my wanted output to the original post.

weweaw · ‎09-12-2017

Hi, Sorry, maybe I wasn't clear. I want to add a variable to sum the specific H_# for each person. My real data has about 30K ID's and 60 H values. Thanks.

weweaw · ‎09-12-2017

Hello, I bet this is easy but I've been failing for a while now so maybe someone can help me. Below is sample data. ID H-Start H-End H_1 H_2 H_3 H_4 H_5 H_6 H_7 H_8 H_9 H_10 H_11 H_12 A 3 6 0 1 1 1 1 1 0 1 0 1 1 1 B 2 5 0 1 0 0 0 0 1 1 1 1 1 1 C 9 12 1 1 0 0 0 0 0 0 0 0 0 1 I need to sum the H_# for certain ranges. The variable H-Start has the start H value and H-End has the end. For ID 'A' I want to sum H_3 through H_6. I've been trying to write a do loop and macros to solve this but have been failing. I would like the output to look like this: ID H-Start H-End H_1 H_2 H_3 H_4 H_5 H_6 H_7 H_8 H_9 H_10 H_11 H_12 Want_Sum 1 3 6 0 1 1 1 1 1 0 1 0 1 1 1 4 2 2 5 0 1 0 0 0 0 1 1 1 1 1 1 1 3 9 12 1 1 0 0 0 0 0 0 0 0 0 1 1 Thank you!

weweaw · ‎06-15-2017

Hello, I would like to have a value repeated when the next line has a '.' and then when the next line has a value to start using that value to repeat. I've been trying a "If x then do y" sort of thing and I cannot get it right. My data looks like this id Type date 1 date 2 1 a 1/1/2016 . 1 b 1/4/2016 1/4/2016 1 a 5/4/2016 . 1 a 6/7/2017 . 1 b 6/8/2017 6/8/2017 1 a 6/10/2017 . 2 a 3/5/2012 . 2 b 4/5/2012 4/5/2012 2 b 4/12/2012 4/12/2012 2 a 4/15/2012 . 2 b 5/7/2014 5/7/2014 And I want it to look like this id Type date 1 date 2 1 a 1/1/2016 . 1 b 1/4/2016 1/4/2016 1 a 5/4/2016 1/4/2016 1 a 6/7/2017 1/4/2016 1 b 6/8/2017 6/8/2017 1 a 6/10/2017 6/8/2017 2 a 3/5/2012 . 2 b 4/5/2012 4/5/2012 2 b 4/12/2012 4/12/2012 2 a 4/15/2012 4/12/2012 2 b 5/7/2014 5/7/2014 edit to show the first id 2 should have a '.' for date 2 not the date 2 from id 1. Thank you!

weweaw · ‎05-12-2017

I added a few rows to show when there is a type b within 90 days of another and how then the type a would not count and type be would be marked as bad. I'm not even for sure but I think this would do it. I will need to be able to calculate what is the average number of a's for each good b event and also what is the total good type a's. ID Claim_ID Claim_line Date Type Type_b_good typeb_number in_90_good 1 1 1 11-Feb a . . 1 1 2 1 11-Mar b 1 1 0 1 2 2 11-Mar b 0 2 0 1 2 3 11-Mar a . . 1 1 3 1 11-Jun b 1 3 0 1 3 2 11-Jun a . . 0 1 3 3 11-Jun a . . 0 1 4 1 3-Jul a . . 0 1 5 1 6-Jul a . . 0 1 6 1 9-Sep b 1 4 0 2 1 1 8-Aug a . . 1 2 2 1 10-Sep b . 1 0 2 3 1 30-Nov a . . 1 2 4 1 11-Dec b 1 2 0 2 5 1 12-Dec a . . 0 2 6 1 13-Dec b 0 3 0

weweaw · ‎05-12-2017

I really don't know where to begin but I've been trying and failing for days. The end is I need to count how many times type a happened 90 days before type b, but there cannot be any other type b's 90 days before. I can do this if I'm only looking at one instance of type b. I did then by adding a new var of the date of type b of a person's to all their other claims. I have a very crude idea how to do this for all but I'm hoping for a more elegant solution. Here are the funny parts of my data: type b can happen multiple times in the same claim so day and in that case I would treat it as one type b event. A person can also have many type b's, I think it can be as high as 150 of them. So I need to mark the b events that have no other b events 90 days before so then I can count the type a events that happened in that window. In my real data type a can be many types and I will need to have how many time a type a happened and what category the type a was. ID Claim_ID Claim_line Date Type 1 1 1 11-Feb a 1 2 1 11-Mar b 1 2 2 11-Mar b 1 2 3 11-Mar a 1 3 1 11-Jun b 1 3 2 11-Jun a 1 3 3 11-Jun a 1 4 1 3-Jul a 1 5 1 6-Jun a 1 6 1 9-Sep b 2 1 1 8-Aug a 2 2 1 10-Sep b 2 3 1 30-Nov a 2 4 1 11-Dec b

weweaw · ‎06-04-2015

I am trying to create a variable that is a 1 if it is in a range My code looks like this: data new; set old; if var1 in (41000:41099) then var2 = 1; else var2 = 0; run; It turns up with only 0's. When I run this proc freq data = new; table var1; where var1 in (41000:41099); run; It shows 50 numbers and hundreds of numbers in the freq. What am I doing wrong?

weweaw · ‎02-05-2015

I'm very sorry for the confusion. If this was my list DRG 2 2 2 3 5 7 13 19 22 54 For example one run would have A B C 2 2 2 3 5 7 13 19 22 54 Then I want to know the mean of each and say Run Average A B C Run 1 Average 18.8 8.666667 4.5

weweaw · ‎02-05-2015

Oh, I did not mean probability. I meant if my list was 10 then A would have 5 of the numbers, B would have 3 of the numbers, and C would have the last two numbers in it.

weweaw · ‎02-05-2015

PGStats The groups option is causing a syntax error. It seems groups is not an option for this proc SAS/STAT(R) 9.2 User's Guide, Second Edition It is possible it is another option? Thank you so much.

Online Status	Offline
Date Last Visited	‎10-02-2020 08:46 PM

If in do loop or macro in data step

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Do loop sum variables

How to repeat value until the next value and then repeat that

Re: Identifying events that will happen multiple time and information ...

Re: If in do loop or macro in data step

Re: Do loop sum variables

Re: How to repeat value until the next value and then repeat that

Re: Do loop sum variables

If in do loop or macro in data step

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Re: Do loop sum variables

Do loop sum variables

How to repeat value until the next value and then repeat that

Re: Identifying events that will happen multiple time and information ...

Identifying events that will happen multiple time and information abou...

Number range in if statement not working

Re: Monte Carlo / Random number

Re: Monte Carlo / Random number

Re: Monte Carlo / Random number