Hi,
Im fairly new to SAS and learning it, I have a dataset like,
obs ID start_dt end_dt
1 9000010130143072000000 20070801 20070831
2 9000010130143072000000 20070901 20070930
3 9000010130143072000000 20071001 20071031
4 9000010130143072000000 20071101 20071130
5 9000010130143072000000 20071201 20071231
6 9000010130143072000000 20080101 20080131
7 9000010130143072000000 20080201 20080229
8 9000010130143072000000 20080301 20080331
9 9000010130143072000000 20080401 20080430
10 9000010130143072000000 20080501 20080531
How can I convert it in a single record as below,
obs ID start_dt end_dt
1 9000010130143072000000 20070801 20080531
Thanks,