Hello,   I am using call scan to substring a variable to remove the last number from the string. I am receiving the Note: Invalid error to substring, although it seems to be working.   Have:     Want:     here is my code:   call scan(_egtpt, -1, pos, length) ; egtpt= upcase(substr(_egtpt,1, pos-2));   LOG: Any help with clearing the note would be appreciated. Thank you! ... View more

Hello,   Does anyone understand why my format is is returning a value of 01/01/1960?  Thanks in advanced!   My code is below and my unformatted data is as follows:    - collection_date: date11. (i.e., 19-JUL-2017)  - pctim = character (i.e., 10:55, 10:10, 11:55 etc.)     if nmiss (collection_date)= 0 then do ; pcdt = collection_date; pcdtc = put(collection_date + input(pctim, time5.),e8601dt.) ; end;     ... View more

Hello!   I need to extract a medication class that is between two delimiters that are the same. In this case, it is a semi-colon (;).   have (oldvar) = ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES; ATC|R03A|ADRENERGICS, INHALANTS; ...   want (newvar) = ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES   can you suggest an effective way to do this?   Thank you!   ... View more

Hello, I need to create a new variable based on an existing one that contains a value such as: "SV01 – Study visit out of window"   I need to keep everything after the â€“ and remove the leading space so that the new variable contains "Study visit out of window"   the lengths of the input variable are not the same.   Thanks for your help! ... View more

Hello, I am trying to calculate an age variable.   The input format of brth_date (birth date) and scrn_date (screening date) is datetime 22.3. the output format is numeric best12.   I am receiving the error: "Invalid character data" (Log below)  Any help would be appreciated.   Thank you!!     brth_date = datepart (brthdat); if recorddate > . then scrn_date = datepart (recorddate); else scrn_date = datepart (icdat); age = floor(yrdif (brth_date, scrn_date,'age')); ... View more

Hello,   I need to determine if the lab collection method for each subject in my data set was collected consistently throughout the study.   To Illustrate, the variables I will use are "Lab Location" and "Subject ID." Each subject has multiple observations in the data set.   I need to determine if the value of "Lab Location" (Character) is the same for all observations per Subject ID. if not, I need to output to view the result.    Example Data: SubjectID  LabLocation Visit Subj123     Lab                     1 Subj123     Lab                     2 Subj123     Point of Care      3   Can you recommend the best method for doing this?   Thank you! ... View more