I am trying to create a job in DI Studio that runs an OS command via the X statement. For troubleshooting purposes, I need access to the return value from the OS, or the output from the execution, or something that would indicate if it is failing and why.   For simplicity's sake, suppose I had the following code (in the 'pre-code') tab.    x echo $(date) >>RunLog.txt ;   and there was a permissions issue with the output file.   How would I obtain error information from the 'x' command?  Or hopefully anything that would have gone to the console or error device. I realize that control is passing temporarily out of SAS's control, so maybe nothing is possible, but I figured it's worth asking about.   Also, the command may need to have quotes around it, but in either case, the job runs successfully (I.E. no error from DI Studio's point of view), but the command was never executed. I'm on Studio V4.902 Thanks in advance. ... View more

I have been unsuccessfully struggling with Rank to do what I think should be a simple task. Essentially, I want to group a table (with many columns) by the first 2 columns and select all records where the group number for the second column=1. Picture an auto service center database for a simplified example of what I'm trying to do: The first few columns are : Customer ID / Date of Service / Service Code / etc. So I want all data for each customer regarding their most recent date of service.   The roadblock for me is that Rank produces the observation number instead of the position in the group, or subgroup, leaving me no way to select the most recent date of service.   In practice, even if I set the 'LOW' option for ties, I can't check for Date-Of-Service-Rank = 1 because it's the low observation number, not the position in the group. So, if there were 99 records for the first customer, then for the second customer all of the records I want might have Date-Of-Service-Rank=100.   Am I going about this the wrong way?  I hope my example makes sense. ... View more

I am using the SAS DI expression editor (v4.901 on Windows 7) to build an expression using a function listed in the drop-down menu. It inserts the code into the expression window with placeholders for the parameters (so it's not a function name I made up arbitrarily). When I try to run the code, or validate the expression, I get the following error:      Table Loader    Line 9: ERROR: Function ISNULL could not be located.   isnull(PRC_ABBR, INPUT(PRC_ID,BEST25.)) I also get the same if I use the IF(...) function.     I've searched for similar issues in the Community blog and the ones I found don't seem to apply to this particular situation.   Here is a screenshot of the functions dropdown...     Here is an excerpt from the log of the 'Validate Expression' function: 102        103        data null; 104           set work.W577RVN; 105           where isnull(PRC_ABBR, INPUT(PRC_ID,BEST25.)); ERROR: Function/subroutine ISNULL not found 106        run cancel; -----------   In case it is significant, the expression I'm trying to enter is in the mapping portion of a table-loader transformation. The only guess I have is that perhaps the library that contains those functions needs to be linked-to, or referenced in some way???   Any help would be appreciated.  Thanks in advance. Jere ... View more