Help using Base SAS procedures

Proc Expand for Groups within Dataset

Reply
Learner
Posts: 1

Proc Expand for Groups within Dataset

Hi All,

 

So I'm running a program to inset empty values for all variables except date values between two observations that have a gap in their date interval. For example, an observation that has 1999Q1 and the next one has 2000Q3.

 

Also I want to do this across bygroups in my dataset--I have a set of quarterly observations for a given individual.

 

I'll impute the date that goes missing after "expansion" later, but right now my main concern is getting the additional observations with the missing dates.

 

Thank you for the help and suggestions!

Trusted Advisor
Posts: 1,137

Re: Proc Expand for Groups within Dataset

Posted in reply to tahaahsin
Could you please provide sample data and expected output
Thanks,
Jag
Respected Advisor
Posts: 4,919

Re: Proc Expand for Groups within Dataset

Posted in reply to tahaahsin

Here is how to do this with proc expand:

 

data have;
input id qtr :yyq6. x;
format qtr yyq6.;
datalines;
1 2009Q1 1
1 2009Q3 2
2 2010Q1 3
2 2011Q1 4
2 2011Q2 5
;

proc expand data=have out=want to=qtr method=none;
by id;
id qtr;
run;

proc print data=want noobs; run;
PG
Ask a Question
Discussion stats
  • 2 replies
  • 244 views
  • 0 likes
  • 3 in conversation