About wajmsu

wajmsu · ‎03-11-2016

Many thanks. My date is already in this format (mmddyy10), still I need to keep this code?

wajmsu · ‎03-11-2016

Hi, Thanks. My response is similar to what I wrote to Jag; I have already entered data, how can I get my required output by writing codes instead of entering data. Also, INTCK() will not give decimals but I have seen that even the value is 0.9758 it would give 0 years; is that not wrong?

wajmsu · ‎03-11-2016

Thanks. My data are already entered and it is a dataset with around a thousand rows. Is there any way I do not have to enter the rahter I could get the required outcome by using the codes.

wajmsu · ‎03-10-2016

Hi, I want to get age out of the date of birth (DOB) as given below. I have following questions/points: 1. How can I get today's date in SAS dataset? 2. How can I get age in years, weeks and days? 3. How can I round off if it comes in decimals? Thanks DOB age 12/22/1994 12/5/1990 12/21/1978 12/27/1977 11/28/1980 4/26/1987 6/5/1977 10/8/1980 3/23/1990 8/3/1991 06/01/198 8/26/1982 5/17/1990 10/28/1985 8/8/1981 5/26/1995

wajmsu · ‎03-09-2016

Hi PGstats, I am writing this after exploring the web/SAS pages to find out answer but could not. How the following figures, such as 7 and 5 as demonitors and format are determined? As I plan to add my another matching variable, the date of blood withdrawal, with a matching range of 2 weeks, I need this information for completing the code in addition to my knowledge. euclid((c.age-s.age)/7, (c.edu-s.edu)/5) as distance format=5.2. Thanks

wajmsu · ‎03-07-2016

Hi Reeza, I could reorganized the dat variables. However, when I looked at the data found some IDs were with both dates and some were with one date. How can I remove the IDs with one date? thanks

wajmsu · ‎03-06-2016

No, there are more than 2 duplicates. Here is some problem. The whole row is not duplicate; as you can see the column C and D are different. I do not want them. I want those variables which I showed in table 2. I tried to use sort procedure with no duplicates but it does not remove the duplicates, probably these are not 'real' duplicates as I mentioned above that one or two columns are different.

wajmsu · ‎03-06-2016

Hi, I have a dataset about the blood sample withdrawal with more information than I need. I want to reduce the duplicates and change the way data are presented. Here is an example of the format I have data in (table 1) below and I want to change it as is shown in table 2 (both tables are not real datasets). Thanks for your guidance! Table 1: Existing format subject_id label sample_address sample_id date subj_date visit sample type 12 2 2 2 7/23/2004 2 040723 1 Plasma 12 2 q 4 7/23/2004 2 040723 1 Plasma 12 2 e 6 2/10/2005 2 050210 2 Plasma 12 2 D,11 8 2/10/2005 2 050210 2 Plasma 12 2 s 10 7/23/2004 2 040723 1 Plasma 25 6 c 20 4/3/2007 6 070403 1 Plasma 25 6 x 14 4/3/2007 6 070403 1 Plasma 25 6 D,11 16 12/10/2007 6 071210 2 Plasma 25 6 y 18 12/10/2007 6 071210 2 Plasma Table 2: The format I need subject_id label date of 1st sample date of 2nd sample samp_typ 12 2 7/23/2004 2/10/2005 Plasma 25 6 4/3/2007 12/10/2007 Plasma

wajmsu · ‎03-05-2016

Dear PGstats, Once again thanks a lot! I was able to get data with all variables and could perform analysis. As I shared with you this is not my real dataset; I will be getting my dataset soon and write codes for my real dataset and see if there is any problem will let you know. I hope you won't mind. Regards

wajmsu · ‎03-04-2016

Hi PG, Thanks again for guiding me! The second code, with stack…, worked; I wanted the data in this shape. As this datafile, in this case stackmatches 2, contains only IDs and no other information. For analysis when I run SAS code, to which datafile should I apply this code, stachmatches 2 does not have information on other variables.

wajmsu · ‎03-04-2016

Hi PG, I can't run SAS codes for analysis. The final data in the form of matched set contains only the IDs of both cases and controls. Can yo uguide me how to bring all the variables alongwith IDs in the final matchd file? Thanks

wajmsu · ‎02-26-2016

Thanks. Can you give me the code?

wajmsu · ‎02-25-2016

Thanks Reeza! Attached is my sample datasets wtih id numbers from sample and controls as paris; can you guide me how to do stacking with individual paris together? data sample; input id age edu race parity wt ht; datalines; 05 32 9 1 0 90 5.2 12 35 12 1 2 110 5.0 17 40 10 2 1 130 4.9 22 25 14 3 0 110 5.4 29 27 12 2 1 95 5.0 40 28 10 3 2 130 6 ; data controls; input id age edu race parity wt ht; datalines; 10 33 11 2 1 98 5.7 11 35 10 2 2 120 5.9 19 42 11 1 3 139 5.9 26 26 14 0 1 99 5.0 31 27 10 2 1 95 5.5 32 29 12 2 2 125 6.2 37 31 10 2 1 190 7.2 43 35 12 1 1 110 5.0 46 45 10 1 1 130 4.9 51 28 12 3 0 110 5.4 55 22 10 1 1 95 5.0 58 28 10 3 2 130 6 70 32 9 1 0 90 5.2 79 37 11 1 2 110 5.0 85 48 14 2 1 130 4.9 88 29 14 3 0 110 5.4 90 25 14 2 1 95 5.0 93 27 11 3 2 130 6 99 35 10 1 0 90 5.2 101 33 11 1 2 110 5.0 114 38 16 2 1 130 4.9 125 25 13 3 0 110 5.4 129 25 10 2 1 95 5.0 130 24 11 3 2 130 6 ; run; Matched pairs with original IDs Sample Control 1 Control 2 5 70 99 12 43 101 22 125 51

wajmsu · ‎02-25-2016

Hi all, I need to make a sub-dataset out of the main data in a way that two controls are stacked below their respective case. Any opinion or hint! Thanks

wajmsu · ‎02-25-2016

Hi PG, How can I stack each sample with its two matched controls? Thanks

Online Status	Offline
Date Last Visited	‎08-07-2016 04:08 AM

error in the log

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: Class statement reference

Re: Class statement

Re: Class statement

Re: date of birth and age

Re: date of birth and age

Re: date of birth and age

date of birth and age

Re: Matching cases with controls

Re: Refining dataset

Re: Refining dataset

Refining dataset

Re: Matching cases with controls

Re: Matching cases with controls

Re: Matching cases with controls

Re: Stacking matched controls under respective cases

Re: Stacking matched controls under respective cases

Stacking matched controls under respective cases

Re: Matching cases with controls