topic Re: How to find all observations after first. in SAS Programming

How to find all observations after first.

jude1 — Wed, 24 Feb 2021 00:39:26 GMT

I'm new to sas, and trying to learn. In an exercise I'm doing, I'm given ID, date, suger level in my data. i am asked to Output all observations after the first for each person to a dataset. Do i use an if then else statement?

Also, how do i output all observations for patients with only one record to a dataset

Here is my code for first which i figured. I just can not figure out the code for observations after the first:

proc import
datafile='patient2.xlsx'
dbms=xlsx replace out=patients;
sheet="Sheet1"; getnames=yes;
proc sort data=patients; by patient date;
run;

data patientsObs;
set patients; by patient Date;
if first.patient then output;
rename suger = firstobs;

proc print data=patientsObs;
run;

Re: How to find all observations after first.

qoit — Wed, 24 Feb 2021 01:38:31 GMT

Hope the below helps:

/* Read the object spawner log */
data have;
	input patient $ date date9. s_level;
	format date date9.;
	datalines;
01 01jan2021 7
01 05jan2021 8
01 14jan2021 7
02 01jan2021 7
02 04jan2021 6
02 28jan2021 10
02 29jan2021 12
03 01feb2021 2
03 02feb2021 6
;
run;

proc sort data=have;
	by patient date;
run;

data want;
	set have;
	by patient date;

	if ^first.patient then
		output;
run;

Re: How to find all observations after first.

jude1 — Wed, 24 Feb 2021 01:57:49 GMT

Thank you so much. I tried so many if then statements, and could not figure it out. It is way simpler than i imagined. Much appreciated.