About bollibompa

bollibompa · ‎04-20-2015

Hi, Hope anyone can help with this problem: I hava two colums (character), a and b like this: a b 0|1|2|3|4 0|1|2|3|4|5|6|7|8 3|4 0|1|2|3|4|5|6|7|8 0|1|2|3|4 1|2|3|4|5|6|7|8 0|1|2|3|4 0|1|2|3 I want to add a third variable (match) if column b contains the information in column a. Like this a b match 0|1|2|3|4 0|1|2|3|4|5|6|7|8 1 3|4 0|1|2|3|4|5|6|7|8 1 0|1|2|3|4 1|2|3|4|5|6|7|8 0 2|3|4 0|1|2|3 0 Can this be done with contains-function? Thanks Thomas

bollibompa · ‎04-16-2015

Thanks everyone for brilliant answers! Solved! Thomas

bollibompa · ‎04-16-2015

Thanks thats great! It is possible to also keep the "base" each loop (p_loop_all_&): Like this: p_loop_all_1 (contains 10000 rows) p_loop_all_2 (contains 20000 rows) p_loop_all_3 (contains 30000 rows) /T

bollibompa · ‎04-16-2015

Hi, I hope someone can help me solve this: I have created a macro appedning two datasets (creatd in another macro): %macro p_loop; %do i=&start %to &stop; data P_LOOP_&i; set C_LOOP_&i T_LOOP_&i ; run; %end; %mend; %p_loop; Let say that every generated p_loop_&i includes 10 000 rows. p_loop_1 =10 000 p_loop_2 = 10 000 p_loop_3 = 10 000 I now want to create another loop/macro that appends the p_loops The first will include 10 000 rows The second will include p_loop_1 and p_loop_2 and contain 20 000 rows The third will include p_loop_1 and p_loop_2 and p_loop_3 and contain 30 000 rows and so on.. Thanks in advance /Thomas

bollibompa · ‎10-11-2014

Hi, I have question which statistic test to use (if possible): I want to analyse the use of medicines after an intervention. The dataset includes a control drug and an intervetnion group and the number of drugs after the intervention are statified into 4 different strata (dummy data below). Is it possible to calculate a p-value for each stratum ie. a p-value between control/intervention for "No drugs" and a p-value for control/intervention for "1-2 drugs" and so on.for Thank in advance for help! /Thomas Control Intervention No drugs 125 100 p=? 1-2 drugs 50 60 p=? 3-5 drugs 15 30 p=? more than 5 drugs 10 10 p=? Total 200 200

bollibompa · ‎08-15-2014

Hi, Problem solved! Many thanks for all brilliant answers! /Thomas

bollibompa · ‎08-13-2014

Hi are there any easy way to keep the last two observations within a group? Thanks thomas

bollibompa · ‎06-19-2014

Thanks! Works fine! Just curious, would it be possible to do the same operation with retain? Just trying to understand the retain statement /Thomas

bollibompa · ‎06-19-2014

I think I am doing something wrong with the retain statement. I hope someone can guide me. I have a table like this and I want to carry forward the last observed date ID date 1 01jan2013 1 . 1 . 1 12mar2013 1 . 1 . 2 07feb2013 2 . 2 . 2 25apr2013 2 . 2. . The result should look like this: ID date 1 01jan2013 1 01jan2013 1 01jan2013 1 12mar2013 1 12mar2013 1 12mar2013 2 07feb2013 2 07feb2013 2 07feb2013 2 25apr2013 2 25apr2013 2. 25apr2013 Thanks Thomas

bollibompa · ‎06-19-2014

Thanks! Works perfectly! /Thomas

bollibompa · ‎06-18-2014

Thanks I am not sure that this solves my problem i would like to write a code to enumerate 1-10 in each ID ( i only have a column with ID:s) data want; ser have; by id; if first.id then count 1 to 10 run;

bollibompa · ‎06-18-2014

Hi, I have a list of ID:s (25000 st) and I now want create a new column next to the ID:S and enumerate each of this ID:n with 1-10. Like this: ID number 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 2 1 2 2 2 3 2 4 2 5 2 6 2 7 2 8 2 9 2 10 an so one I hope someone can help me with this! /Thomas

bollibompa · ‎02-19-2014

Thank you all for quick replies! INDSNAME was exactly what I was looking for, works perfect! Thomas

bollibompa · ‎02-17-2014

I have a library with data from four years (2010-2014) each dataset includes two variables: id and source library: data_2010 data_2011 data_2012 data_2013 I now want to append these years and in the append step (or what step the best for doing this...) create a variable that tells you which year the data comes from. Like this: id source year (new) 1 a 2010 2 a 2010 1 b 2011 2 b 2011 and so on... I'd rather not create the variable in each dataset because they are huge Is it possible to create this variable in the append step? /Thomas

bollibompa · ‎01-30-2014

Thanks for answer. It works fine! However, I now realize that I have startdate2 and stopdate2 in another table and the same id can also have more than one startdate2 and stopdate2 Like this: data one id startdate1 stopdate1 1 7FEB2013 28FEB2013 2 15MAR2013 1APR2013 data two id startdate2 stopdate2 1 1JAN2012 30NOV2012 1 1JAN2013 30MAR2013 2 1MAR2011 20APR2011 2 30MAR2012 31DEC2012 2 1JAN2013 15FEB2013 data want: id startdate1 stopdate1 match 1 7FEB2013 28FEB2013 1 /*This id should have a match=1 because the timeperiod of 7FEB2013 and 28FEB 2013 is included data two (row 2) */ 2 15MAR2013 1APR2013 0 /*This timeperiod is not included in data two for id2*/ I have tried different sql-queries with having-clauses but with no luck Thank for help! Thomas

Online Status	Offline
Date Last Visited	‎03-05-2017 04:00 AM

Re: Interpret text

Interpret text

Re: Propensity score match with replacement

Re: Help with forecasting/prediction

Propensity score match with replacement

Help with forecasting/prediction

Re: Covariate balance randomized trials

Covariate balance randomized trials

Re: Help with SGPLOT scatter

Re: Help with SGPLOT scatter

Re: SAS enumeration with condition

Re: Ridge in logistic regression?

Re: Contains?

Contains?

Re: Help with a macro-appending data

Re: Help with a macro-appending data

Help with a macro-appending data

Which stattest?

Re: Keep last two observations

Keep last two observations

Re: Retain

Retain

Re: Enumeration within ID

Re: Enumeration within ID

Enumeration within ID

Re: proc append - keep identifier

proc append - keep identifier

Re: Compare/match timeranges