About Katie

Katie · ‎12-27-2016

Hello. Here is what I have: PT_ID date result criteria_met x 1/1/2015 500 yes x 2/1/2015 470 no x 3/1/2015 525 yes z 2/2/2015 450 no z 3/32015 575 yes k 5/4/2015 650 yes basically, what I want is all the data for a particular patient up through their first 'Yes' in the criteria_met column. So patient x will have 1 observation, patient z will have 2 and patient k will have 1 observation. Any help is appreicated! Thank you!

Katie · ‎04-04-2016

So I believe I created what you are looking for. I turned it into a macro just in case if you have more diagnoses spots than you originally specified. Let me know if you have any questions. DATA HAVE; INPUT patientid 1-2 dx1 3-5 dx2 7-9 dx3 11-13 dx4 15-17 date mmddyy10.; datalines; 1 250 223 224 444 5/5/2009 1 555 666 120 250 5/6/2008 2 120 666 1/2/2007 2 120 666 1/1/2007 3 250 2/2/2004 3 240 250 3/3/2004 3 250 1/1/2004 ; run; PROC SORT DATA = HAVE; BY PatientID; RUN; %MACRO FREQ (END = ); %DO i = 1 %TO &END; PROC FREQ DATA = HAVE NOPRINT; TABLES PATIENTID*DX&i / OUT = FREQ_DX&i; RUN; DATA FREQ_DX&i; SET FREQ_DX&i(RENAME = (COUNT = COUNT&i DX&i = DX)); DROP PERCENT; RUN; PROC SORT DATA = FREQ_DX&i; BY PatientID DX; RUN; %END; DATA ALMOST; MERGE FREQ_DX1-FREQ_DX&END; BY PatientID DX; RUN; PROC FREQ DATA = ALMOST; TABLES DX / OUT = WANT; RUN; %MEND; %FREQ(END=4);

Katie · ‎04-04-2016

This isn't the most elegant solution but I believe it gets you what you want. I also assumed that you wanted it BY subject. So that piece is in there as well. I also worked around the date (the second HAVE dataset due to my SAS not being able to read the dates you provided). DATA Have; INPUT SUBJ 1-3 EXSTDTC $5-14 DOSE 16-18; DATALINES; 111 2015-04-01 100 111 2015-04-09 111 2015-04-15 100 111 2015-04-22 100 222 2015-04-01 100 222 2015-04-09 100 333 2015-04-01 100 333 2015-04-09 444 2015-04-10 100 444 100 444 2015-04-20 100 ; RUN; DATA HAVE; SET HAVE (RENAME = (EXSTDTC = EXSTDTC_OLD)); YEAR = SUBSTR(EXSTDTC_OLD,1,4); MONTH = SUBSTR(EXSTDTC_OLD,6,2); DAY = SUBSTR(EXSTDTC_OLD,9,2); EXSTDTC = MDY(MONTH,DAY,YEAR); FORMAT EXSTDTC MMDDYY10.; DROP YEAR MONTH DAY EXSTDTC_OLD; RUN; PROC SORT DATA = HAVE; BY SUBJ; RUN; DATA HAVE2 WANT; SET HAVE; BY SUBJ; LAG_DT = LAG(EXSTDTC); IF FIRST.SUBJ THEN LAG_DT = .; DIFF = EXSTDTC- LAG_DT; IF DOSE NE . AND DIFF >= 7 THEN FLAG = 'Y'; ELSE FLAG = 'N'; OUTPUT HAVE2; IF FLAG = 'Y' THEN OUTPUT WANT; FORMAT LAG_DT MMDDYY10.; RUN;

Katie · ‎01-30-2016

Thank you! I looked at it differently and did make it much easier. Thank you :).

Katie · ‎01-30-2016

Hello! I'm working on creating a label for variables that are being created, but I'd like them to have the old names as their labels. I keep gettin an error message saying there is a syntax error on the LABEL line. Any help is greatly appreciated!! DATA %SCAN(&DATA,&i); SET %SCAN(&DATA,&i); ARRAY %SCAN(&DATA,&i) [&Count] &List; ARRAY BIN_%SCAN(&DATA,&i)[&Count] BIN_%SCAN(&DATA,&i)1 - BIN_%SCAN(&DATA,&i)&Count; DO j = 1 TO &Count; IF %SCAN(&DATA,&i)(j) = '' THEN BIN_%SCAN(&DATA,&i)(j) = 0; ELSE BIN_%SCAN(&DATA,&i)(j) = 1; LABEL BIN_%SCAN(&DATA,&i)(j) = %SCAN(&DATA,&i)(j); END; FORMAT BIN_%SCAN(&DATA,&i)1 - BIN_%SCAN(&DATA,&i)&Count Issues.; RUN;

Katie · ‎01-29-2016

In the macro this is what I have: DATA %SCAN(&DATA,&i); SET %SCAN(&DATA,&i); ARRAY %SCAN(&DATA,&i)[*] &&List_Social; ARRAY BIN_%SCAN(&DATA,&i)[*] BIN_%SCAN(&DATA,&i)1 - BIN_%SCAN(&DATA,&i)&&Count%SCAN(&DATA,&i); DO i = 1 TO &&Count%SCAN(&DATA,&i); IF %SCAN(&DATA,&i)(i) = '' THEN BIN_%SCAN(&DATA,&i)(i) = 0; ELSE BIN_%SCAN(&DATA,&i)(i) = 1; END; RUN; Outside of the macro the code resolves to this: DATA Social; SET Social; ARRAY Social[&CountSocial] &List_Social; ARRAY BIN_Social[&CountSocial] BIN_Social1 - BIN_Social&CountSocial; DO i = 1 TO &CountSocial; IF Social(i) = '' THEN BIN_Social(i) = 0; ELSE BIN_Social(i) = 1; END; RUN; When it runs in the macro, SAS freaks out when it gets to the '&' symbols and does not treat them as macro variables. Any help is appreciated. Thanks!

Katie · ‎01-29-2016

THANK YOU!

Katie · ‎01-29-2016

I have the following code: %MACRO DATAPREP(DATA); %DO i = 1 %TO 1; PROC SORT DATA = FIMR.Sleep_Logistic; BY Case_ID__; RUN; PROC SORT DATA = FIMR.%SCAN(&DATA,&i); BY Case_Number; RUN; DATA %SCAN(&DATA,&i); MERGE FIMR.Sleep_Logistic (IN = A KEEP = Case_ID__ RENAME = (Case_ID__ = Case_Number)) FIMR.%SCAN(&DATA,&i) (IN = B); BY Case_Number; IF A and B; RUN; PROC CONTENTS DATA = %SCAN(&DATA,&i) NOPRINT OUT = Contents_%SCAN(&DATA,&i); RUN; DATA Contents_%SCAN(&DATA,&i); SET Contents_%SCAN(&DATA,&i); IF Length NE 1 THEN DELETE; IF Name = 'Fetal__F__Infant__I_' THEN DELETE; KEEP Name VarNum; RUN; PROC SQL; SELECT DISTINCT Name INTO :List_%SCAN(&DATA,&i) SEPARATED BY ' ' FROM Contents_%SCAN(&DATA,&i) ORDER BY VarNum; QUIT; %END; %MEND; %DATAPREP(DATA = Environment); When I then type the following: %PUT &List_Environment; I get an error that states that the symbolic reference List_Environment is not resolved. Please HELP.

Katie · ‎03-12-2015

I have data that looks like this: Patient ProgramDate FinanceDate A 1/1/2012 2/3/2012 A 2/5/2012 4/6/2012 A . 5/25/2012 B 2/1/2012 4/1/2012 B . 4/5/2012 The data needs to look like this: Patient VisitDates A 1/1/2012 A 2/5/2012 A 4/6/2012 A 5/25/2012 B 2/1/2012 B 4/1/2012 B 4/5/2012 Basically I need the Finance Date to match up to a Program Date. No Finance Dates are allowed to Match up to the earliest ProgramDate. The finance date can be counted for in the Program Date if it occurs prior to a singular date. This is why Patient A does not have a VisitDate for 2/3/2012. This one is 'counted' twice and we only need to show one date.

Katie · ‎04-18-2014

Thank you all so much for your help. I believe I've gotten it to work! Thanks again!

Katie · ‎04-18-2014

Here is an example of what my data looks like: Data Have - CPI EnrollDate VisitDate BP1 Race Gender 123 1/1/2001 1/1/2001 120/80 White Female 123 1/1/2001 2/1/2001 119/85 123 9/9/2009 9/9/2009 115/75 White 123 9/9/2009 10/9/2009 456 2/2/2002 2/2/2002 118/85 Black Male 456 2/2/2002 3/2/2002 110/82 Black Male 789 3/3/2003 3/3/2003 135/81 Hispanic 789 3/3/2003 4/3/2003 132/83 Hispanic Male 789 3/3/2003 5/3/2003 Male 789 3/3/2003 6/3/2003 128/81 Data Want - CPI EnrollDate VisitDate BP1 Race Gender 123 1/1/2001 1/1/2001 120/80 White Female 123 1/1/2001 2/1/2001 119/85 White Female 123 9/9/2009 9/9/2009 115/75 White Female 123 9/9/2009 10/9/2009 White Female 456 2/2/2002 2/2/2002 118/85 Black Male 456 2/2/2002 3/2/2002 110/82 Black Male 789 3/3/2003 3/3/2003 135/81 Hispanic Male 789 3/3/2003 4/3/2003 132/83 Hispanic Male 789 3/3/2003 5/3/2003 Hispanic Male 789 3/3/2003 6/3/2003 128/81 Hispanic Male

Katie · ‎04-17-2014

Thank you so much for your reply. What I'm finding is the variables in the Call statement are the ones NOT getting filled, while the others are. Is there a way to specify only the ones you want to be filled?

Katie · ‎04-17-2014

I am trying to adapt the code you have previously shown me to only fill down a couple of variables, however I cannot figure out how to make it work. Can you help? This is what I have so far: data down; update try(obs=0) try; by CPI; array f[2] Race Gender first:; if f[dim(f)] then index = 0; indext+1; ouput; run; The rest of the code I can do, it is just setting up the array to only update those two variables. Thanks! Katie

Katie · ‎03-07-2014

For some reason this code is not working on my computer. I can not get the color scheme I want to show up. Can someone else run it and let me know if they experience the same problem? data work.bp; infile datalines; input dias losys hisys grp $ 13-33 refx refy; datalines; 75 110 190 Severe Hypertension 75 140 115 110 190 Severe Hypertension 90 140 75 110 180 Moderate Hypertension 90 190 110 110 180 Moderate Hypertension . . 75 110 160 Mild Hypertension . . 100 110 160 Mild Hypertension . . 75 110 140 High/Normal . . 90 110 140 High/Normal . . 75 110 130 Normal . . 85 110 130 Normal . . 75 110 120 Optimal . . 80 110 120 Optimal . . ; run; proc template; define style styles.bp; parent=styles.listing; style graphcolors from graphcolors / 'gdata6'=CXFFFFFF 'gdata5'=CXF5D9D8 'gdata4'=CXEBB3B1 'gdata3'=CXE18D8A 'gdata2'=CXD76763 'gdata1'=CXBF1810; end; run; ods listing style=bp; title 'Stages of Hypertension'; proc sgplot data=bp; band x=dias lower=losys upper=hisys / group=grp name="bp"; series x=refx y=refy / lineattrs=(thickness=2); xaxis values=(75 to 115 by 5) label='Diastolic Pressure (mmHg)'; yaxis values=(110 to 190 by 10) label='Systolic Pressure (mmHg)'; keylegend "bp" / position=right across=1 title='Stage'; inset "Isolated" "Systolic" "Hypertension" / position=left textattrs=graphlabeltext; run;

Katie · ‎02-13-2014

Thank you for your help. I ran the code I already had today and it seemed to work fine. I have no idea what happened.

Online Status	Offline
Date Last Visited	‎12-27-2016 03:54 PM

Outputting Obvservations until a criteria is met

Re: summarize diagnosis multiple columns and multiple per patients

Re: data logic

Re: Labeling Variables based on other variable names

Labeling Variables based on other variable names

Utilizing Macro References in An Array

Re: Macro List

Macro List

Ordering Data

Re: Filling up and Down Efficiently

Re: Labeling Variables based on other variable names

Re: Utilizing Macro References in An Array

Re: Utilizing Macro References in An Array

Re: Macro List

Re: Using Arrays

Re: summarize diagnosis multiple columns and multiple per patients

Outputting Obvservations until a criteria is met

Re: summarize diagnosis multiple columns and multiple per patients

Re: data logic

Re: Labeling Variables based on other variable names

Labeling Variables based on other variable names

Utilizing Macro References in An Array

Re: Macro List

Macro List

Ordering Data

Re: Filling up and Down Efficiently

Re: Filling up and Down Efficiently

Re: Filling up and Down Efficiently

Re: Filling up and Down Efficiently

Modifying Colors in PROC SGPLOT

Re: Using Arrays