I have a longituidnal data (Called as SBP & DBP which are contineous variables)- which is collected on different dates and the date variable looks like 10SEP2010. I have sample ID for each patient.
I would like to classify first measurement of SBP, DBP of each observation into one dataset and last measurement of SBP, DBP of each observation into another dataset.
How can I do this?
Browse source dataset by patient_ID and sampling_date. Output first record of a group to one dataset and the last to another. something like code below.
data destination_dataset1 destination_dataset2;
set source_dataset;
by patient_id sampling_date;
if first.patient_id then output destination_dataset1;
if last.patient_id then output destination_dataset2;
run;
I'm trying to computete the difference between first and last observations. Can someone tell me why I have the following note?
Thanks
"first" / "last" refer to a subgroup which means ordering. Your code does not browse the data set in an ordered manner (you should have a "by ... " clause in it.
I'd suggest you should read a little bit the basics to understand the mechanisms behind:
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/viewer.htm#a001302699.htm
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.