topic Re: Creating a new variable with the Query Builder in SAS Enterprise Guide

Creating a new variable with the Query Builder

deleted_user — Wed, 23 May 2007 19:00:31 GMT

Hi,

I'm trying to create a lagged variable (the difference between two rows) with the query builder... with no success. In SAS, I would use the lag or dif functions, but with EG I get an error message.

Is there a function that would do this in EG? How would you define this variable?

Thanks,
D.

Re: Creating a new variable with the Query Builder

Cynthia_sas — Wed, 23 May 2007 19:12:44 GMT

Hi:
You cannot use the LAG function with PROC SQL: http://support.sas.com/techsup/unotes/SN/014/014659.html
Since the EG query builder is building SQL, that is probably the source of the error message you are getting.

But, you can open a code node and use your DATA step code with the LAG function, per these examples:
http://support.sas.com/ctx/samples/index.jsp?sid=1498&tab=code
http://support.sas.com/ctx/samples/index.jsp?sid=108&tab=code

cynthia

Re: Creating a new variable with the Query Builder

deleted_user — Wed, 23 May 2007 20:08:32 GMT

Thank you,

It did solve my small problem,

D.