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: 
Denali
‎10-16-2024
  • 123 Posts
  • 18 Likes Given
  • 0 Solutions
  • 1 Likes Received

How to calculate difference in days between two dates (given in SAS da...

by Quartz | Level 8 in SAS Programming
‎02-19-2019 03:28 PM
‎02-19-2019 03:28 PM
Hi,   Each patient was asked twice to recall their date of first treatment. The dates might be inconsistent because there is recall bias. I would like to create a new variable indicating there is a huge difference between the two dates. The definition of "huge difference"  could be 1 year.   Patient ID                 Recall date1                  Recall date2             Huge Difference (This is what I want) 001                           08/05/2006                     09/2006                   NO 002                           05/24/2006                     05/2007                   YES 003                           02/08/2007                     08/2006                   NO 004                           08/12/2010                     11/2007                   YES   Given the formats were different, how do I do the calculation and create the variable I need? Thanks in advance!  ... View more

Re: How to combine year and month columns into one column

by Quartz | Level 8 in SAS Programming
‎02-18-2019 02:49 PM
‎02-18-2019 02:49 PM
Hi Tom,    Thank you for your code. It worked well when both columns contain data.    However, it will show missing if someone only has either year or month data. Is there a way to keep the information as mush as possible?     ID               YEAR             MONTH         Date (this is what I want) 001             2012                  08               08/2012 002             2000                  10               10/2000 003                                       06               06/0000 004             2010                  99               00/2010 005             2009                  88               00/2009   I used below code:  Date = mdy(Month,1,Year); format Date mmyys7.;     Note: "blank", "88" or "99" are "missing". In the Date variable, I simply wrote "00"  represents those do not have month info and "0000" for those without year info. Does anyone has better way to keep the missing info in the "Date" variable?    Thanks in advance! ... View more

Separate Year and Month Columns Combine into One. How to deal with mis...

by Quartz | Level 8 in SAS Programming
‎02-18-2019 02:38 PM
‎02-18-2019 02:38 PM
Hi,   I have a column contain year information and another column contains month information. I would like to combine these two columns into one.   ID               YEAR             MONTH         Date (this is what I want) 001             2012                  08               08/2012 002             2000                  10               10/2000 003                                       06               06/0000 004             2010                  99               00/2010 005             2009                  88               00/2009   I used below code:  Date = mdy(Month,1,Year); format Date mmyys7.;   It worked well when both columns contain information. However, it will show missing if someone only has either year or month data. Is there a way to keep the information as mush as possible?   Note: "blank", "88" or "99" are "missing". In the Date variable, I simply wrote "00"  represents those do not have month info and "0000" for those without year info. Does anyone has better way to keep the missing info in the "Date" variable?    Thanks in advance! ... View more

Re: How do I change the format and designate length for two conditions...

by Quartz | Level 8 in SAS Programming
‎02-18-2019 01:59 PM
‎02-18-2019 01:59 PM
Hi Patrick,   Thank you for the code. It worked!   I have another question: How do I reorder the ID variable back to the first column. It is now listing in the last column.   Thanks again! ... View more

How do I change the format and designate length for two conditions?

by Quartz | Level 8 in SAS Programming
‎02-15-2019 04:47 PM
‎02-15-2019 04:47 PM
Hi,   I have a ID column is currently numeric, and I would like to change it to character. I have a hundred ID numbers 1-100 needs to be 5 numbers beginning with zero, e.g. 00001, 00002, 00003,.....,00099, 00100. Then another twenty ID numbers just need to be 4 numbers, beginning with two, e.g. 2000, 2001, 2002, 2003, ......2020.    ID 00001 00002 00003   00099 00100 2000 2001 2002   2019 2020   How do I change the format and designate the length for these two conditions? Thank you! ... View more

How to combine year and month columns into one column

by Quartz | Level 8 in SAS Programming
‎02-15-2019 03:36 PM
‎02-15-2019 03:36 PM
Hi,   I have a column that has year and another column has month. How do I combine these two columns and get a YYYY/MM information in one column?    ID           Year              Month          Date (this is what I want) 001         2006             08                2006/08 002         2008             12                2008/12 003         2012             07                2012/07   Thanks in advance!   ... View more

Re: How to merge 19 datasets into one

by Quartz | Level 8 in SAS Programming
‎02-08-2019 11:48 AM
‎02-08-2019 11:48 AM
I added a variable called "Month" so it will be 1-19 month when I stack them. My question is how do I easily stack 19 datasets? Should I use "set" for 18 times? ... View more

How to merge 19 datasets into one

by Quartz | Level 8 in SAS Programming
‎02-08-2019 11:21 AM
‎02-08-2019 11:21 AM
Hi,   I have collected patients demographic characteristics for 19 months (from Dec. 2016-June 2018). Each month has its own dataset and the patients are not likely to be same people. Each dataset contains patient ID, sex, race, each month we approximately have 500-1000 patients.   How do I combine these 19 datasets into one? Writing the merge statement for 10+ times or sql? Any better idea? Thank you! ... View more

Re: Problem with macro with where statement

by Quartz | Level 8 in New SAS User
‎12-04-2018 03:21 PM
‎12-04-2018 03:21 PM
This is the log:   660 options mprint; 661 %macro one(x) (where=(wrat_raw not in (888 999))); ERROR: Expected semicolon not found. The macro will not be compiled. ERROR: A dummy macro will be compiled. 662 proc means n mean std median min max maxdec=1; 663 var &x; 664 class site_id Phase visit_id; 665 run; 666 %mend one; 667 %one (wrat_raw); NOTE: Line generated by the invoked macro "ONE". 1 proc means (where=(wrat_raw not in (888 999))) n mean std median min max maxdec=1; - 22 76 MPRINT(ONE): proc means (where=(wrat_raw not in (888 999))) n mean std median min max maxdec=1; MPRINT(ONE): var wrat_raw; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. MPRINT(ONE): class site_id Phase visit_id; ERROR: No data set open to look up variables. MPRINT(ONE): run; ERROR 22-322: Syntax error, expecting one of the following: ;, ALPHA, CHARTYPE, CLASSDATA, CLM, COMPLETETYPES, CSS, CV, DATA, DESCEND, DESCENDING, DESCENDTYPES, EXCLNPWGT, EXCLNPWGTS, EXCLUSIVE, FW, IDMIN, KURTOSIS, LCLM, MAX, MAXDEC, MEAN, MEDIAN, MIN, MISSING, MODE, N, NDEC, NMISS, NOLABELS, NONOBS, NOPRINT, NOTHREADS, NOTRAP, NWAY, ORDER, P1, P10, P20, P25, P30, P40, P5, P50, P60, P70, P75, P80, P90, P95, P99, PCTLDEF, PRINT, PRINTALL, PRINTALLTYPES, PRINTIDS, PRINTIDVARS, PROBT, Q1, Q3, QMARKERS, QMETHOD, QNTLDEF, QRANGE, RANGE, SKEWNESS, STACKODS, STACKODSOUTPUT, STDDEV, STDERR, SUM, SUMSIZE, SUMWGT, T, THREADS, UCLM, USS, VAR, VARDEF. ERROR 76-322: Syntax error, statement will be ignored. ... View more

How to recode continuous variables

by Quartz | Level 8 in SAS Programming
‎12-04-2018 03:20 PM
‎12-04-2018 03:20 PM
I have 15 continuous variables and the data entry person defined "888" and "999" as missing. I don;t want these two numbers to be calculated in the proc means procedure as they appeared to be the maximum values. Is there a way to recode 888 and 999 as . ?   Could you please coach me how to do the data cleaning step in the data step? Thank you!   Attached is the data and below are the variables I was using.    %macro one(x) (where=(wrat_raw not in (888 999))); proc means n mean std median min max maxdec=1; var &x; class site_id Phase visit_id; run; %mend one; %one (wrat_raw); %one (wrat_ss); %one (wrat_perc); %one (bacs_symbol_raw); %one (bacs_standardized); %one (bacs_percentile); %one (hvlt_trial1); %one (hvlt_trial2); %one (hvlt_trial3); %one (hvlttot); %one (hvlt_standardized); %one (hvlt_percentile); %one (msceit_raw); %one (msceit); %one (msceitpercentile);   ... View more

Re: Problem with macro with where statement

by Quartz | Level 8 in New SAS User
‎12-04-2018 03:13 PM
‎12-04-2018 03:13 PM
I ran blow code and it worked. 888 is no longer the maximum value.   proc means data=nero2 (where=(wrat_raw not in (888 999))) mean std median min max maxdec=1; class site_id Phase visit_id; var wrat_raw; run;   But my Macro seems to be wrong because I am still seeing 888 as maximum. Could you please revise my Macro below? Thank you!   %macro one(x) (where=(wrat_raw not in (888 999))); proc means n mean std median min max maxdec=1; var &x; class site_id Phase visit_id; run; %mend one; %one (wrat_raw); ... View more

Re: Problem with macro with where statement

by Quartz | Level 8 in New SAS User
‎12-04-2018 03:02 PM
‎12-04-2018 03:02 PM
I tried the below code, but 888 still shows up as the maximum value.  proc means data=nero2 (where=(wrat_raw ne 888 or wrat_raw ne 999)) mean std median min max maxdec=1; class site_id Phase visit_id; var wrat_raw; run;   Is there a way to do the data cleaning step in the beginning? 888 and 999 are both missing value, how do I define them as '.'?   Thank you! ... View more

Problem with macro with where statement

by Quartz | Level 8 in New SAS User
‎12-04-2018 02:34 PM
‎12-04-2018 02:34 PM
  Original proc means statement is below, and I wanted to use a macro to run multiple variables, however, my macro did not work when if I included the "where=(wrat_raw ne 888 or 999" statement. Could anyone revise my code? Thank you!   proc means data=nero2 (where=(wrat_raw ne 888 or 999)) mean std median min max ; class site_id Phase visit_id; var wrat_raw; run;   %macro one(x); proc means n mean std median min max maxdec=1; var &x; class site_id Phase visit_id; run; %mend one; %one (wrat_raw); %one (wrat_ss); %one (wrat_perc); ... View more

How to generate the exponentiated odds ratio and 95% confidence interv...

by Quartz | Level 8 in SAS Programming
‎09-26-2018 02:31 PM
‎09-26-2018 02:31 PM
Hi,   This procedure produced the logit of estimate and 95% CI. How do I generate the exponentiated odds ratio and 95% confidence interval for stage, sex and age? Should I use Lsmeans?   Stage: pre, post Sex: male, female and prefer to self-describe age: continuous variable   proc genmod data = test descending; class subjectid stage sex; model result = stage sex age/dist=bin link=logit type3 ; repeated subject=subjectid/type=un; format stage stageF. sex $sexF.; run; ... View more

Re: How to write a macro to dichotomize categories in the data step fo...

by Quartz | Level 8 in SAS Programming
‎09-17-2018 01:10 PM
‎09-17-2018 01:10 PM
I am not familiar with the array code...... right now I am still using less simplified code below and got what I want. But I was hoping to refine it using an easier way........   data Smoke1; set Smoke; if pre_B1_dan_c = 'Definitely yes' then pre_B1_dan_c_D = " Yes"; if pre_B1_dan_c = 'Probably yes' then pre_B1_dan_c_D = " Yes"; if pre_B1_dan_c = 'Probably not' then pre_B1_dan_c_D = "No"; if pre_B1_dan_c = 'Definitely not' then pre_B1_dan_c_D = "No"; if po_B1_dan_c = 'Definitely yes' then po_B1_dan_c_D = " Yes"; if po_B1_dan_c = 'Probably yes' then po_B1_dan_c_D = " Yes"; if po_B1_dan_c = 'Probably not' then po_B1_dan_c_D = "No"; if po_B1_dan_c = 'Definitely not' then po_B1_dan_c_D = "No"; if pre_B2_dan_ec = 'Definitely yes' then pre_B2_dan_ec_D = " Yes"; if pre_B2_dan_ec = 'Probably yes' then pre_B2_dan_ec_D = " Yes"; if pre_B2_dan_ec = 'Probably not' then pre_B2_dan_ec_D = "No"; if pre_B2_dan_ec = 'Definitely not' then pre_B2_dan_ec_D = "No"; if po_B2_dan_ec = 'Definitely yes' then po_B2_dan_ec_D = " Yes"; if po_B2_dan_ec = 'Probably yes' then po_B2_dan_ec_D = " Yes"; if po_B2_dan_ec = 'Probably not' then po_B2_dan_ec_D = "No"; if po_B2_dan_ec = 'Definitely not' then po_B2_dan_ec_D = "No"; if pre_B3_harm_c = 'Definitely yes' then pre_B3_harm_c_D = " Yes"; if pre_B3_harm_c = 'Probably yes' then pre_B3_harm_c_D = " Yes"; if pre_B3_harm_c = 'Probably not' then pre_B3_harm_c_D = "No"; if pre_B3_harm_c = 'Definitely not' then pre_B3_harm_c_D = "No"; if po_B3_harm_c = 'Definitely yes' then po_B3_harm_c_D = " Yes"; if po_B3_harm_c = 'Probably yes' then po_B3_harm_c_D = " Yes"; if po_B3_harm_c = 'Probably not' then po_B3_harm_c_D = "No"; if po_B3_harm_c = 'Definitely not' then po_B3_harm_c_D = "No"; if pre_B4_harm_ec = 'Definitely yes' then pre_B4_harm_ec_D = " Yes"; if pre_B4_harm_ec = 'Probably yes' then pre_B4_harm_ec_D = " Yes"; if pre_B4_harm_ec = 'Probably not' then pre_B4_harm_ec_D = "No"; if pre_B4_harm_ec = 'Definitely not' then pre_B4_harm_ec_D = "No"; if po_B4_harm_ec = 'Definitely yes' then po_B4_harm_ec_D = " Yes"; if po_B4_harm_ec = 'Probably yes' then po_B4_harm_ec_D = " Yes"; if po_B4_harm_ec = 'Probably not' then po_B4_harm_ec_D = "No"; if po_B4_harm_ec = 'Definitely not' then po_B4_harm_ec_D = "No"; if pre_B5_quit_ec = 'Definitely yes' then pre_B5_quit_ec_D = " Yes"; if pre_B5_quit_ec = 'Probably yes' then pre_B5_quit_ec_D = " Yes"; if pre_B5_quit_ec = 'Probably not' then pre_B5_quit_ec_D = "No"; if pre_B5_quit_ec = 'Definitely not' then pre_B5_quit_ec_D = "No"; if po_B5_quit_ec = 'Definitely yes' then po_B5_quit_ec_D = " Yes"; if po_B5_quit_ec = 'Probably yes' then po_B5_quit_ec_D = " Yes"; if po_B5_quit_ec = 'Probably not' then po_B5_quit_ec_D = "No"; if po_B5_quit_ec = 'Definitely not' then po_B5_quit_ec_D = "No"; if pre_B6_addict_c = 'Very likely' then pre_B6_addict_c_D = " Yes"; if pre_B6_addict_c = 'Somewhat likely' then pre_B6_addict_c_D = " Yes"; if pre_B6_addict_c = 'Neither likely or unlikely' then pre_B6_addict_c_D = "No"; if pre_B6_addict_c = 'Somewhat unlikely' then pre_B6_addict_c_D = "No"; if pre_B6_addict_c = 'Very unlikely' then pre_B6_addict_c_D = "No"; if po_B6_addict_c = 'Very likely' then po_B6_addict_c_D = " Yes"; if po_B6_addict_c = 'Somewhat likely' then po_B6_addict_c_D = " Yes"; if po_B6_addict_c = 'Neither likely or unlikely' then po_B6_addict_c_D = "No"; if po_B6_addict_c = 'Somewhat unlikely' then po_B6_addict_c_D = "No"; if po_B6_addict_c = 'Very unlikely' then po_B6_addict_c_D = "No"; if pre_B7_addict_ec = 'Very likely' then pre_B7_addict_ec_D = " Yes"; if pre_B7_addict_ec = 'Somewhat likely' then pre_B7_addict_ec_D = " Yes"; if pre_B7_addict_ec = 'Neither likely or unlikely' then pre_B7_addict_ec_D = "No"; if pre_B7_addict_ec = 'Somewhat unlikely' then pre_B7_addict_ec_D = "No"; if pre_B7_addict_ec = 'Very unlikely' then pre_B7_addict_ec_D = "No"; if po_B7_addict_ec = 'Very likely' then po_B7_addict_ec_D = " Yes"; if po_B7_addict_ec = 'Somewhat likely' then po_B7_addict_ec_D = " Yes"; if po_B7_addict_ec = 'Neither likely or unlikely' then po_B7_addict_ec_D = "No"; if po_B7_addict_ec = 'Somewhat unlikely' then po_B7_addict_ec_D = "No"; if po_B7_addict_ec = 'Very unlikely' then po_B7_addict_ec_D = "No"; if pre_B8_media = 'Very likely' then pre_B8_media_D = " Yes"; if pre_B8_media = 'Somewhat likely' then pre_B8_media_D = " Yes"; if pre_B8_media = 'Neither likely or unlikely' then pre_B8_media_D = "No"; if pre_B8_media = 'Somewhat unlikely' then pre_B8_media_D = "No"; if pre_B8_media = 'Very unlikely' then pre_B8_media_D = "No"; if po_B8_media = 'Very likely' then po_B8_media_D = " Yes"; if po_B8_media = 'Somewhat likely' then po_B8_media_D = " Yes"; if po_B8_media = 'Neither likely or unlikely' then po_B8_media_D = "No"; if po_B8_media = 'Somewhat unlikely' then po_B8_media_D = "No"; if po_B8_media = 'Very unlikely' then po_B8_media_D = "No"; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-16-2024 06:29 PM
Likes given to
Likes from
View All
Quick links