BookmarkSubscribeRSS Feed
mantubiradar19
Quartz | Level 8

I have a time series data or repeated measurements collected over a time period. I have got the DATE variable. I would like to know how I can I subset this dataset into another dataset containing only the first and last series data based on the DATE variable?

4 REPLIES 4
Reeza
Super User

Please post some sample data and your expected output. 

ballardw
Super User

I have to assume that your date values are SAS date values for this to work AND assumng you have a cutoff date such that all value before  the date go to one set and after to the other.

Assume that the cutoff date is January 1 1016.

 

data FirstSeries LastSeries;

   set Have;

   if Date < '01JAN2016'd then output FirstSeries;

   else output LastSeries;

run;

 

If you have not used SAS date literal note that you have to express the date as 'ddMONyyyy'd. You can use single or double quotes but the quotes are required and the D at the end is what tells SAS to use the value as a date and not a simple string.

mantubiradar19
Quartz | Level 8

Hi there! Thank you. Say for example I have multiple observations for the year 2013. How I can I retain or make a separate dataset with the last observation from year 2012. My data varaible is in this form "22MARCH2013". 

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1045 views
  • 0 likes
  • 3 in conversation