Hi!  I am trying to figure out how to trim the values of  variables that contain a space.  I do not want to compress or concatenate the value but rather completely delete any characters that follow a blank space in the value field.  For example, I have several Procedure codes:  Proc1-Proc4.   PROC1         PROC2       PROC3         PROC4 7501 D01     0193 D01    90411 D02    80411 D02   I want to completly delete any characters that follow the space.  How might I accomplis this?   Thanks!     ... View more

Hi!  I'm haveing some difficulty correclty joining two tables.  TableA contains all the SSNs that I need REMOVED from TableB.  TableB has the remaining obervations and all the variables I need to keep.  The problem is when I run this syntax, the values in SSN disapear...I'm assuming something to do with my null statement.  But when I remove the Null statement, the join (checking oservation numbers) is not correct.  Is there a way to correctly write this code where my SSNs to not disappear?  Thanks!   proc sql; create table outpatient_1 as select a.ssn, b.* from ssn_drop as a right join ssn_complete as b on a.ssn = b.ssn where a.ssn is null; quit; ... View more

Hi!  Want to create a table that counts the total days weteen first and last patient visit (ENCDATE)..variable 'Diff_Enc'  and also a variable that counts total encounters 'Tot_Enc'  (one observation per encounter).   data asthma.difference_vist; set asthma.op_exclusion; by patssn; if first.patssn=1 and last.patssn=1 then delete; Diff_Enc=Encdate-LAG(encdate); if not (first.patssn=1) then output; Tot_Enc=encdate+1; run;   The DIFF_ENC gives forrect information, but the Tot_Enc jsut gives '.' in all values.  Can someone please let me know how to properly count the encounters?   Thanks!! ... View more

Hi!  I'd like to know if there is a way to do an array / do loop checking for multiple values.   I have this code, but I'd like to check is any DX1-DX10 start with  these values:  7707, 748, 505   data OP_Exlusion5; set asthma.OPssn_JoinFY14nd; array dx(*) DX1-DX10; do i= 1 to dim(dx); if dx(i)=: '7707' then do; output; end; end; run;   When I include all the values in the if statement, I am getting an error.  Do I need multiple IF statements?   Thanks!     ... View more

Hi!  I have the following syntax, but the PATAGE variable I created is just spitting out "." in all value slots.  Can someone please tell me where my error is?  Thanks!!   data want; set have; keep admdate admdx DX1-DX20 marital pasth bencatx patdob dds dispdate dmisbenf dmissex ethnic pasth patcat patname paygrade prvadm race patage recage; format dispdate mmddyy10.; format admdate mmddyy10.; format birtdate mmddyy10.; patdob =birtdate; format patdob mmddyy10.; patage= Int(yrdif(N_patdob,N_admdate,'actual')); run; ... View more

Hi!  I merged two data sets by Patient ID, but realized two variables (PatDOB, PatDOB1) were named differently but both serve as birthddate.  So, now half values are under PATDOB1 and others under PATDOB.  They are both formatted same (mmddyy10.), so is there a way to move all values in PATDOB1 to PATDOB and then delete the variable PATDOB1?   Thanks!! ... View more

Hi!  I am trying to figure out the proper way to complete an array do loop.  I have 10 variables within a larger table that start with DX  (DX1, DX2, DX3...to DX10).   I need to know if any values that start with '493' are in the DX5-DX10 variable range.  If yes, then output the observation.   Here is what I have so far (but it may all be wrong!).   I can't figure out how to output the observation...    data test_dxcheck; set have; array dx(*) DX5-DX10; do i= 5-10; if dx(i)=: '493' then do; ????     Thanks!   ... View more