This worked, almost.   As the source of the observations changed, the value stayed the same because it is keeyed off the DDNAME.  I need to know for each observation in the data.  This gave the value in only one of the multiple datasets being read. ... View more

I put together some quick code to test.     %MACRO TESTIT ;                                                      DATA ACTX  ;                                                         SET CDTN01.CDTF01                                                 CDTS01.CDTF01                                                CDTU01.CDTF01     INDSNAME=DSN   ;                        KEEP  IDENTITY DATE  SISID  TIME2 CNT    ACTVY_STAT_ID                     DU_TYPE_CD    TECH_FNCTN_ID      ;                FORMAT           SISID $3.                           TECH_FNCTN_ID  $12.                      ;         CNT   = 1       ;                                                   IDENTITY = SCAN(DSN,3,".") ;                                        %MEND TESTIT;                                                      %TESTIT ;                                                           I do not get any errors, but identity is blank.   SASHELP.VLIBNAME will get the name, but I need the IDENTITY on each record. ... View more

I personally do not find it much of a risk, but if the JCL was changed and the dataset name did not match the data source.  Someone could actually view another person or group's data.  I am dealing with application data and not necessiarily computer usage data.   ... View more

I don't have any code yet.  I am trying to figure out if and how to code a program.     From another program using the same data I get the following note:           NOTE: Libref DDP001 was successfully assigned as follows:             Engine:        V9                                               Physical Name: MXGT.BIZ.CDTF.P001.SASDATA              I want to bring the Physical Name into the program so I can retrieve any of the levels of the name as the data is being read.  When one of the datasets finishes, I need the name to change as the next dataset is processed.   ... View more