BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello,

The Fact Table Lookup node to lookup is generating different source codes for different target tables. Sometimes it doesn't generate the following code :

/*---- Create the xref table ----*/
/* Remove any existing temporary cross reference file */
proc datasets lib = work nolist nowarn memtype = (data view);
delete tempXrefTable;
quit;

/* Sort target table */
proc sort data = pmd.FINANCIAL_ACCOUNT_DIM
out = work.tempXrefTable;
by ACCOUNT_RK VALID_TO_DTTM;
run;

%rcSet(&syserr);

/* Get the last key variable in each set of keys */
data work.tempXrefTable;
set work.tempXrefTable;
by ACCOUNT_RK;
if last.ACCOUNT_RK;
output;
run;

Does anyone know why this happens or what should I do to have my lookup target table ordered by ACCOUNT_RK VALID_TO_DTTM?
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
Are you sure you are working with Enterprise Guide? "Fact Table Lookup" is not a construct in EGuide.
deleted_user
Not applicable
I was working on Data Integration Studio. Sorry for placing the post in a wrong place.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 614 views
  • 0 likes
  • 2 in conversation