About shellp55

shellp55 · ‎08-13-2012

Hi Reeza Sorry but when I copied into the actual data, it's not working for cases where there is no procedure including for after there is data. What I mean by that is if there are procedures in px1, px2 and px3, then the code will still insert an episode number in episode for px4 though it doesn't exist. Are you able to help with that? Thanks.

shellp55 · ‎08-13-2012

Thank you so much, Reeza. I'll check this out and let you know how I do!

shellp55 · ‎08-13-2012

Hi Reeza data test_grp; input @1 regno $3. @4 PxStDate1 yymmdd8. @12 Px1 $7. @19 PxStDate2 yymmdd8. @27 Px2 $7. @34 PxStDate3 yymmdd8. @42 Px3 $7. @49 PxStDate4 yymmdd8. @57 Px4 $7.; format PxStDate1-PxStDate4 yymmdd10.; cards; 001201203291RB89LA 1RB87LA 2OT71LA 002201204171RM89LA 1RD89LA201204203OT20WE 003201204201VA53LA201204251VC55LA201204303OT20WE 004201205131RM89LA 1RD89LA 2OT71LA201205253OT20WE 005201206021VA53LA 1VC55LA 2OT20WE201206233OT20WE 006201203291RB89LA 1RB87LA 2OT71LA run; What should occur from above is: regno 001 should have all 3 procedures as episode 1 regno 002 should have procedures 1 and 2 be episode 1 and procedure 3 is episode 2 regno 003 should have all 3 procedures be their own episode so episodes 1, 2 and 3 regno 004 should have procedures 1 and 2 be episode 1 and procedure 3 is episode 2 regno 005 should have procedures 1 and 2 be episode 1 and procedure 3 is episode 2 regno 006 should have all 3 procedures as episode 1 Thanks for your help, Reeza!

shellp55 · ‎08-13-2012

Hi Reeza Thanks for responding....sorry but I'm unsure what you mean about posting data in a data step. Please clarify and I'll do it. Thanks.

shellp55 · ‎08-13-2012

Hi I figured out that I really don't want to loop through but I want to keep checking one to the others to see what episode it is. It's not bad for the first few but by procedure 20 I will have to singularly compare to all the other dates....or do I? Below is the code I've got thus far (up to procedure 3) which works but I'm just trying to figure out if there is an easier/cleaner way to write it:

shellp55 · ‎08-13-2012

Hello I have base SAS and I'm using version 9.3. I have patient visit data where one line of data is one visit. There are 20 potential interventions coded though this varies per visit and in fact some patients will have zero interventions. There is also the possibility that a patient can have interventions on different dates with each date being a separate episode. The way the data is structured is that I have a procedure start date and procedure code for the 20 potential spots. So px1-px20 and pxstartdt1-pxstartdt20. The data is entered such that if there is a px2 and pxstartdt2 is null then px2 is still part of episode 1. If pxstartdt2 <> pxstartdt1 then it's a new episode. Adding another wrinkle is that pxstartdt2 could have a date that matches pxstartdt1 which means it is still part of episode 1. What I'm trying to do is loop through all 20 intervention spots and indicate episode number and also intervention occurrence number. Example: px1=5MD60AA pxstartdt1=Apr 1, 2012 px2=1RB89LA pxstartdt2= px3=1YM91LA pxstartdt3= px4=3OD70CA pxstartdt4=April 5, 2012 In the example above px1 would be episode 1, occurrence 1; px2 would be episode 1, occurrence 2; px3 would be episode 1, occurrence 3; px4 would be episode 2, occurrence 1. Can someone start me on what code I would use to accomplish this? Thanks very much.

shellp55 · ‎04-15-2012

Hi PG Thanks for the quick response. What I actually did, but I don't know if it is correct, was to include the sample size per PatServ (as it would be in ascending order): procsort data=&import_result; by PatServ; run; procsurveyselect data= &import_result out= &sample_list seed=12345678 sampsize=(285, 11,20, 0,14, 3,0, 11,4, 0,0); strata PatServ; run; This appears to have worked correctly in giving me the number of charts per patient service that I requested. Conversely, I assume I could indicate samprate() and provide the rates per PatServ.

shellp55 · ‎04-15-2012

Hi Since posting this I've upgraded to SAS 9.3. The following code is working in that it provides a 2% sampling per PatServ but what if I want to have different values per PatServ value? For instance, what I usually do is use a Survey Sample Calculator online to come up with how many charts need to be reviewed for a 95% confidence level and 5% confidence interval. So I know how many charts I want the total to be but I want to be able to indicate how many per PatServ (either by % or number). For example, if the sample for a database is 348 charts, I want to be able to indicate 285 (81.9%) of charts are if PatServ 10; 11 (3.2%) if PatServ = 20; 20 (5.7%) if PatServ = 30; etc. procsort data=&import_result; by PatServ; run; procsurveyselect data = &import_result method=sys rate=.02 seed=1234 out= &sample_list; strata PatServ; run; Thanks for any assistance.

shellp55 · ‎03-09-2012

Hi Maybe I was bug eyed from working on this for so long but I thought my version worked. Anyway, when I ran it again it wasn't working but in looking at your suggestion it isn't working either and produced the error message " Macro keyword IF appears as text. A semicolon or other delimiter may be missing." I'm stumped on this so any assistance greatly appreciated. Thanks.

shellp55 · ‎03-09-2012

Hi I should have advised that I was using version 9.1 where the IN statement in macros was deactivated (which I only found out while searching the web to fix my code). So I had to do the following: %macro test; %if &dxlist eq I43 or &dxlist eq F00 or &dxlist eq F02 %then %let dxtypelista= '1' 'W' 'X' 'Y' '3'; %else %let dxtypelista= '1' 'W' 'X' 'Y'; %mend test; This is rather bulky but until I install 9.3 it will have to do. Thanks Reeza and Haikuo for your assistance.

shellp55 · ‎03-09-2012

HI Reeza Thanks for continuing to help! What I'm trying to do with the &dxlist in 'I420' 'I425' 'I426' is that if the list of codes being reviewed in the code below are from this list of diagnoses then dxtypelista needs to include type 3 but if not then don't look for where type 3. do i=1 to 25 while (diagcde{i} ne ' '); do j=1 to 25 while (diagcde{j} ne ' '); if flag_type6 ne 1 and dx_type(i) in (&dxtypelista) and diagcde(i) in: (&dxlist) then do; if diagcde(i)=diagcde(j) and dx_type(j) in (&dxtypelistb) then diagcde(i)=" "; end; How would it make more sense to do? Thanks.

shellp55 · ‎03-09-2012

Hi Reeza Thanks for responding. Please note that taking out the %then causes the error of where is %then so it must be required. Also, the reason I've included the diagnosis codes for look up is because a diagnosis could be present on the chart more than once and I'm only interested in comorbid conditions. So I have to apply the filter of certain diagnoses not both types of 1, w, x, y and M or type 2. So the program throws out all of the scenarios as described and then I'm only evaluating based on what remains and can say if code in ('I420' 'I425' 'I426') then chf=1.

shellp55 · ‎03-09-2012

Hi Sorry but I'm confused: you indicated you took the "do" statement out so I assumed you wanted me to use: %macro test; %if &dxlist in 'I420' 'I425' 'I426' then %then %let dxtypelista='1' 'W' 'X' 'Y' '3'; %else %let dxtypelista='1' 'W' 'X' 'Y'; %mend; %test; Doing that produces the error " A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &dxlist in 'I420' 'I425' 'I426'". Please note that the list is actually longer than the 3 codes used in the example so could moving the next line without a comma or anything be an issue? Thanks so much for helping me.

shellp55 · ‎03-09-2012

Super, thanks so much. I apologize but in my example, I didn't include the "else" statement for the macro. Based on your response, I currently have it written as: %macro test; %if &dxlist in 'I420' 'I425' 'I426' then %then %do; %let dxtypelista='1' 'W' 'X' 'Y' '3'; %else %let dxtypelista='1' 'W' 'X' 'Y'; %mend; %test; But I get the error message "there is no matching %if statement for the %else. A dummy macro will be compiled." What should it be? Thanks.

shellp55 · ‎03-09-2012

Hi Wow, thanks for the super speedy reply! Sorry, but I should have explained that I am very new to macros so I'm not understanding what you've provided....can you please explain? Thanks so much.

Online Status	Offline
Date Last Visited	‎11-26-2023 11:40 PM

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Exporting SAS dataset to MS-Access

Re: Memo Field in First Row of Excel Export?

Memo Field in First Row of Excel Export?

Re: Creating Export Name from Variables?

Re: Creating Export Name from Variables?

Re: Exporting Data to Acess - Error

Re: Exporting Data to Acess - Error

Re: Rename Macro Do Loop Where Value is 1 Less than Current Occurence

Re: ODS Excel tagattr not working for data types/formats

Re: Adding Procedure Episode Numbers

Re: Adding Procedure Episode Numbers

Re: Adding Procedure Episode Numbers

Re: Adding Procedure Episode Numbers

Re: Adding Procedure Episode Numbers

Adding Procedure Episode Numbers

Re: Non-Randomized Randomization

Re: Non-Randomized Randomization

% If statement not valid in open code

% If statement not valid in open code

% If statement not valid in open code

% If statement not valid in open code

% If statement not valid in open code

% If statement not valid in open code

% If statement not valid in open code