Hello, So I am reading this comma delimited file and created it into a temporary dataset. Here is my code and the output: %let clinical=P:\SAS\71342_example\Data\Clinical Trial Case Study; libname clinical "&clinical"; filename ClinRaw "&clinical"; data visit_site2; infile ClinRaw("Site 2, Baseline Visit.csv") dsd; length sf_reason $20 p_units $9 pos $12; input Subject sf_reason$ screen Sex$ dov$ notif_date$ sbp dbp bp_units$ pulse p_units$ pos$ temp temp_units$ weight weight_units$ pain ; label sf_reason='Screen Failure Reason' screen='Screening Flag, 0=Failure, 1=Pass' dov='Date of Visit' notif_date='Failure Notification Date' sbp='Systolic Blood Pressure' dbp='Diastolic Blood Pressure' bp_units='Blood Pressure Units' p_units='Pulse Units' pos='Position' temp='Temperature' temp_units='Temperature Units'; run; proc contents data=visit_site2; run; Alphabetic List of Variables and Attributes# Variable Type Len Label6411107821731295113141516 Sex Char 8 Subject Num 8 bp_units Char 8 Blood Pressure Units dbp Num 8 Diastolic Blood Pressure dov Char 8 Date of Visit notif_date Char 8 Failure Notification Date p_units Char 9 Pulse Units pain Num 8 pos Char 12 Position pulse Num 8 sbp Num 8 Systolic Blood Pressure screen Num 8 Screening Flag, 0=Failure, 1=Pass sf_reason Char 20 Screen Failure Reason temp Num 8 Temperature temp_units Char 8 Temperature Units weight Num 8 weight_units Char 8 The problem is that I need the dataset to look like the file I uploaded. What should I do especially in regards of formatting to DATE10. Another issue I'm having is that I'll be combining these two files and I need to include two new variables (age at visit) and (number of days between). I have been looking at youtube videos, but I still do not know how to do that. I put the two files I'll be combining down here. This is the code I used to combine them: %let clinical=P:\SAS\71342_example\Data\Clinical Trial Case Study; libname clinical "&clinical"; filename ClinRaw "&clinical"; data visit_site2; infile ClinRaw("Site 2, Baseline Visit.csv") dsd; length sf_reason $20 p_units $9 pos $12; input Subject sf_reason$ screen Sex$ dov$ notif_date$ sbp dbp bp_units$ pulse p_units$ pos$ temp temp_units$ weight weight_units$ pain ; label sf_reason='Screen Failure Reason' screen='Screening Flag, 0=Failure, 1=Pass' dov='Date of Visit' notif_date='Failure Notification Date' sbp='Systolic Blood Pressure' dbp='Diastolic Blood Pressure' bp_units='Blood Pressure Units' p_units='Pulse Units' pos='Position' temp='Temperature' temp_units='Temperature Units'; run; ods select position; proc contents data=visit_site2 varnum; run; ods select all; data random_site2; infile ClinRaw("randomization_site2") dsd; length sf_reason $20 p_units $9 pos $12; input Subject sf_reason$ screen Sex$ dov$ notif_date$ sbp dbp bp_units$ pulse p_units$ pos$ temp temp_units$ weight weight_units$ pain ; proc contents data=random_site2; run; data site2; set visit_site2 random_site2; length sf_reason $20 p_units $9 pos $12; run; Can someone help refine this code and how to add these new variables (age at demographics visit and number of days between (i.e., excluding the visit days) demographics and randomization visits)?
... View more