topic have first year and last year in one row. how do i make a panel? in SAS Procedures

have first year and last year in one row. how do i make a panel?

aarony — Thu, 01 Dec 2016 19:47:45 GMT

hi i have a data

company name first year last year

ibm 2002 2005

apple 2004 2007

how do i make this as below?

ibm 2002

ibm 2003

ibm 2004

ibm 2005

apple 2004

apple 2005

apple 2006

apple 2007

thanks so much in advance

Reeza — Thu, 01 Dec 2016 19:56:36 GMT

Data want;

set have;

Do year = first_year to last_year;

output;

end;

Run;

aarony — Thu, 01 Dec 2016 19:59:08 GMT

thank you so much Reeza!