About michan22

michan22 · ‎04-05-2017

I put: array x{*} newcd4_1-newcd4_17; Min_index = 1; Do i = 1 to dim(x); if x(i) > diagnosis_date and x(i) ^= . and x(i) < x(min_index) then do; min_index = i; end; end; idx=whichn(min(of x{*}),of x{*}); min_date=vvaluex(cats(vname(x{idx}),'_date')); run; log says "array subscript out of range at line 400 column 29". Is it problem with my data?

michan22 · ‎04-05-2017

Using the code that @Ksharp provided in my last post, I think I have to add the if/then statement within the following code: array x{*} newcd4_1-newcd4_17; idx=whichn(min(of x{*}),of x{*}); min_date=vvaluex(cats(vname(x{idx}),'_date')); run; I am not sure where to add the if/then statement/do loop to let SAS know to ignore the values that are linked to dates before the the diagnosis_date? Thanks!

michan22 · ‎04-05-2017

Hi guys! I have another question. The same dataset: var1 var1_date var2 var2_date var3 var3_date var4 var4_date ....... diagnosis_date 200 08/09/16 300 05/02/15 400 06/10/14 500 01/20/13 ....... 02/01/16 250 07/06/16 200 04/10/14 05/10/14 100 01/02/17 150 06/01/15 550 02/10/15 03/30/15 . . . I need to find the lowest numerical value and its associated date for each observation, but I do not want to count or accept the values/dates if it happens before the diagnosis date (e.g. for obs 1 the lowest value would be 300 and date is 05/02/15, for obs 2 lowest value is 200 with date 04/10/14 and so on). I have a rough idea which is to use array and add if then statement within the array but do not know how to code exactly to get the value and its date. Thank you and I realy appreciate all of your advice!

michan22 · ‎04-05-2017

I did mark as solved and I will post a new question. Thank you!

michan22 · ‎04-05-2017

Also to find the date that's associated with that lowest value

michan22 · ‎04-05-2017

I have one more question relating to this dataset: I want to find the lowest numerical value for each observation. I also have an additional variable called diagnosis date, and I only want to accept the lowest value for each observation if the date that linked to the numerical value is before the diagnosis date. How can I proceed to do that? add if then do loop to the array??

michan22 · ‎04-04-2017

Thank you!!

michan22 · ‎04-04-2017

I changed the date variable names to .... _date and it worked! Can you tell me what vvaluex function does and what does this line do exactly? min_date=vvaluex(cats(vname(x{idx}),'_date')); Thank you so much!!

michan22 · ‎04-04-2017

Thanks for the advice! I created new variables for both the numerical and date variables so that they are in order (newcd4_1-newcd4_17 and newcd4date_1-newcd4date_17). I put: array x{*} newcd4_1-newcd4_17; idx=whichn(min(of x{*}),of x{*}); min_date=vvaluex(cats(vname(x{idx}),'_date')); run; log says argument to function VVALUEX is not a known variable name: newcd4_17_date. I think it's _date not matching the new variables I created?

michan22 · ‎04-04-2017

When I ran the array codes the log says ERROR: array subscript out of range at line 865 column 4. Are some of my variables not in the right format?

michan22 · ‎04-03-2017

Thank you for the advice! I am relatively new to SAS and can you explain what this line does? reeza = date(whichn(min(of var(*)), of var(*))); In order to find the date with the lowest value, I have to first tell SAS that var1 is linked to date1 and var2 linked to date2 and so on right? is that what the array match does?

michan22 · ‎04-03-2017

Sorry, I meant that I would want the new variable to return the date (that correspond to the lowest numerical value) for each observation, even if there are multiple observations with the same lowest numerical value. I don't expect there to be a lot of ties, but there will be a few observations with the same (lowest) numerical values.

michan22 · ‎04-03-2017

Yes I can create new variables and just make them equal to the values in the original variables. For ties, I would want to count both the date values if they are different. Is that possible? Thanks!

michan22 · ‎04-03-2017

Hi guys! I have a new question. I have a dataset that looks like (observation=108): var1 var1_date num2 num2_date cd4_3 cd4_3date var4 date4 ....... var16 date16 200 08/09/16 300 05/02/16 400 06/10/15 500 01/20/15 ....... 350 02/15/05 250 07/06/16 200 04/10/14 100 01/02/17 150 06/01/15 550 02/10/15 . . . I used the min function to find the lowest numerical value for each observation. Now, I need to find the date that correspond to minumum numerical value (e.g for obs 1 it would be 08/09/16, obs 2 would be 04/10/14...). How can I proceed to do that?? Thank you!!

michan22 · ‎04-03-2017

Wilconxon rank sum is a non-parametric test for 2 independent groups and it test whether a randomly chosen measurement from first group tends to be systematically bigger/smaller than one from the 2nd group. The null hypothesis mathmatically would be: P(X>=Y)=P(Y>=X)=0.5 The alternative hypothesis would be (depending on whether you are doing a one-side test or two-sided test): P(X>=Y)>0.5 or P(X>=Y)<0.5 or P(X>=Y) !=0.5 If your data distribution is approximately symmetrical then this is testing means and medians.

Online Status	Offline
Date Last Visited	‎03-14-2019 02:31 PM

Re: Histogram bar labels

Re: Histogram bar labels

Histogram bar labels

Re: Removing the first observation of duplicates

Re: Removing the first observation of duplicates

Re: Removing the first observation of duplicates

Re: Removing the first observation of duplicates

Removing the first observation of duplicates

Re: Wilcoxon Rank Sum Interpretations

Re: Wilcoxon Rank Sum Interpretations

Re: Removing the first observation of duplicates

Re: Checking for missing data

Re: Checking for missing data

Re: Checking for missing data

Re: Merge Problems

Merge Problems

Re: importing issue: no data in first 5 records

Re: if/then within array

Re: if/then within array

if/then within array

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Re: Finding the date that correspond to the lowest value (unordered)

Finding the date that correspond to the lowest value (unordered)

Re: Wilcoxon Rank Sum Interpretations