Date:         Mon, 14 Apr 2008 12:29:30 -0400
Reply-To:     Jack Clark <JClark@CHPDM.UMBC.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Clark <JClark@CHPDM.UMBC.EDU>
Subject:      Preventing PROC TRANSPOSE from generating an output record when
              input data set is empty
Content-Type: text/plain; charset="us-ascii"

Hello,

 

Is it possible to prevent PROC TRANSPOSE from generating an output
observation when the input data set to the transpose contains no
observations?

 

I am using a transpose with a BY statement, and when I have an input
data set that is empty, a single observation is being created as output.
The only variable in the output data set is the BY variable and it
obviously has a missing value.

 

Thanks for any suggestions.

 

Jack Clark

Research Analyst

Center for Health Program Development and Management

University of Maryland, Baltimore County