Hello Everyone,
I have been trained to use SAS EG 6.1, but am still relativity new. My boss is an old time programmer, and sometimes we have difficulty communicating about what I need to change or do in my programs. She is convinced there is a way to open and modify code from an EG query. Apparently this is easily done in other programs.
She want's to be able to open up a code like this:
PROC SQL;
CREATE TABLE WORK."MAJORGROUPS3"n AS
SELECT t1.ACADEMIC_PERIOD_GRADUATION,
t1.MIN_of_ACADEMIC_PERIOD,
t1.ID,
t2.Major_Grouping,
FROM WORK.MAJORGROUPS2 t1
LEFT JOIN WORK.QUERY (t1.MIN_of_ACADEMIC_PERIOD = t2.ACADEMIC_PERIOD) AND (t1.ID = t2.ID);
QUIT;
- Then be able to modify code without leaving the query builder to add DISTINCT or whatever needs to be added. Not copy the code then edit it. Thus I'll be able to still make changes in the query builder after we have changed whatever it is in the code she wants to change.
PROC SQL;
CREATE TABLE WORK."MAJORGROUPS3"n AS
SELECT DISTINCT t1.ACADEMIC_PERIOD_GRADUATION,
t1.MIN_of_ACADEMIC_PERIOD,
t1.ID,
t2.Major_Grouping,
FROM WORK.MAJORGROUPS2 t1
LEFT JOIN WORK.QUERY (t1.MIN_of_ACADEMIC_PERIOD = t2.ACADEMIC_PERIOD) AND (t1.ID = t2.ID);
QUIT;
Is there a way that this can be done?
Thank you,
Renee
