Hello community We are attempting to update a our user metadata  and upon making the final call to insert we get the following error. This process works perfectly in a sister environment.    %if "&submit" = "1" %then %do; proc metadata in=_outxml out=_respons; run; %end; %else %do; %put Note: Metadata request not submitted do to a submit parameter value of &submit..;       SYMBOLGEN: Macro variable SUBMIT resolves to 1 MLOGIC(MDUCHGL): %IF condition "&submit" = "1" is TRUE MPRINT(MDUCHGL): proc metadata in=_outxml out=_respons; MPRINT(MDUCHGL): run; ERROR: Repository is not registered. NOTE: PROCEDURE METADATA used (Total process time): real time 6.03 seconds cpu time 0.20 seconds NOTE: The SAS System stopped processing this step because of errors.     ... View more

Hello Community,  I am having an issue where a Data null step witin a macro is not resolving...   Here is the abridged code i am building..   %MACRO BLDTERM(TBL_BUILD,COHORT_YEAR,PRELIM,TERM_ID); data _null_; if "&TBL_BUILD" = "Summer_Table" then do; CALL SYMPUT('TERMV','1'); end; run; Proc SQl; Creat table TEST as SELECT ..... [extra columns removed for clarity] /*Summer*Flags*/ CASE WHEN &TERMV = '1' THEN 1 ELSE 0 END format=8. AS SUMMER_ALL, CASE WHEN &TERMV = '1' AND &DSNAME..CF_FPTIME_IND = 'F' THEN 1 ELSE 0 END format=8. AS SUMMER_FULL_TIME, CASE WHEN &TERMV = '1' AND &DSNAME..CF_FPTIME_IND = 'P' THEN 1 ELSE 0 END format=8. AS SUMMER_PART_TIME, ..... [extra columns removed for clarity] QUIT; %MEND BLDTERM; The Log Says my submitted code looks as follows...   CASE WHEN &TERMV = '1' THEN 1 ELSE 0 END format=8. AS SUMMER_ALL, CASE WHEN &TERMV = '1' AND PRELIM_DATA_DIM.CF_FPTIME_IND = 'F' THEN 1 ELSE 0 END format=8. AS UMMER_FULL_TIME, CASE WHEN &TERMV = '1' AND PRELIM_DATA_DIM.CF_FPTIME_IND = 'P' THEN 1 ELSE 0 END format=8. AS SUMMER_PART_TIME,     The &TERMV variable neverver resolves to the integer so all my Cases resolve to 0   Any assistance is greatly apreciated. ... View more

Hello Community,  I have hit a wall trying to implement something i do all day long in EG.  We are using DI studio 4.901. I am attempting to build a job that requires the data to be max effectie dated before loading to its final destination.   I am lost on how to make this happen in the subquery transformation. I have attempted multiple ways and am unable to make it happen sucessfully.   Any assitance on simply where i need to put the Subquery code and build the job links would be greatly apreciated. ... View more

Hello community, I am not sure what the problem here is. I am trying to perform an update on a dataset based off of another data set. ERROR 1 pre change. 19 Proc SQL; 20 Update RO.CH_HIST_MASTER as t1 21 set ACAD_ORG = (Select NewOrg from RO.CAH_CONV as t2 22 where t2.Subject = t1.Subject 23 and t2.Catalog = CATALOG_NBR 24 and t2.Group = t1.ACAD_GROUP) 25 where t1.Subject = t2.Subject 26 and t1.CATALOG_NBR = t2.Catalog 27 and t1.ACAD_GROUP = t2.Group 28 and t1.STRM = "1390"; ERROR: Unresolved reference to table/correlation name t2. ERROR: Unresolved reference to table/correlation name t2. ERROR: Unresolved reference to table/correlation name t2. When i change the t2 reference in the second WHERE clause it returns another error. Both errors shown below, any assistance pointing me in the right direction would be help full. ERROR 2 Post change 19 Proc SQL; 20 Update RO.CH_HIST_MASTER as t1 21 set ACAD_ORG = (Select NewOrg from RO.CAH_CONV as t2 22 where t2.Subject = t1.Subject 23 and t2.Catalog = CATALOG_NBR 24 and t2.Group = t1.ACAD_GROUP) 25 where t1.Subject = CAH_CONV.Subject 26 and t1.CATALOG_NBR = CAH_CONV.Catalog 27 and t1.ACAD_GROUP = CAH_CONV.Group 28 and t1.STRM = "1390"; ERROR: Unresolved reference to table/correlation name CAH_CONV. ERROR: Unresolved reference to table/correlation name CAH_CONV. ERROR: Unresolved reference to table/correlation name CAH_CONV. Message was edited by: smilbuta ... View more

Hello community, I am using EG4.1 , I am producing a report for output in HTML. My question centers around how to use the summarize command but not summarize ALL Columns. My data example is as follows (periods simply for spacing in post) Name... value1..value2..Difference ---------------------------------------------------- Name1.....10.....20.....-50% Name2.....15.....10..... 33% Name3.....10.....0.....100% --------------------------------------------------- Totals.....35.....30..... XXXXXX <-----------problem. When using the summarize option on a break statement it summarizes all columns , even the percentages. I wish to evaluate the percentage based on the totals of value1 and value2 not the values of the difference. Is there a way to do this? ... View more