Recently in the SAS Community Library: Your often contains the information you need, but not sequenced in the order required for processing. @SASJedi shows you how to properly sequence data so you can compare the data in one table to the data in another, conduct merges or joins and more.
Dear all, I am investigating subjective stress levels during a psychosocial stress test. I ran into problems with a more complex model, and started with simplifying my model to figure out the source of the issues. I am already running into trouble by adding a quadratic term of time. My code is as follows: proc mixed data=MAST_long_VAS; class PPID Time; model BC_stress = Time Time*Time / solution residual influence; repeated Time / subject=PPID type=ar(1); run; This model runs without any problems or warnings, but does not give me the output for the fixed effect of Time*Time (only the fixed effect of Time). I tried removing "Time" from the class statement, but then I get the warning that only class variables are allowed in the repeated statement. Can anyone help me with this? Thanks in advance!
... View more
When we created the manual AML/CDD alert we debugged the JSON response and did not find enrichment fields, Hence we cannot separate manual alerts
for employees and non-employees (Enrichment field.employee_ind).
... View more
Dear Team,
We have so many ETL jobs ( SAS DI ) in our project and I am not able to examine all the etl jobs to discover the source table that utilizes it
Kindly suggest, how to find the ETL Job that is using a particular source table in a quickest way ?
Thanks
Shakti Sourav Mohapatra
... View more
Brand new to SAS. I'm doing something that I expect is relatively easy, but I'm struggling to get it right. The requirement is basic - I'm reading in a long file with many rows, if a record matches a criteria I want it to be shipped to a different "bypass" file that I'll work on in a later process, but it should be removed from the original read-in file. Environment is zOS - input file is defined and passed in via JCL (all working). I get the following errors if I remove my actual logic - if I leave the FILENAME statement in without referencing it there's no errors. ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Invalid file, BYPASS_FILE. FILENAME BYPASS_FILE BYPASS1;
/***********************************************************/
/* READ FILE */
/***********************************************************/
DATA DATAIN;
INFILE DATAIN;
INPUT
@ 00001 RECORD_NUMBER $CHAR8.
@ 01769 COMPONENT_STATUS $CHAR1.
;
/*******************************************************************/
/* CREATE BYPASS FILE - USED TO STORE RECORDS WHICH HAVE AN */
/* INACTIVE COMPONENT: COMPONENT_STATUS = I */
/*******************************************************************/
IF COMPONENT_STATUS = 'I' THEN DO;
FILE BYPASS_FILE;
PUT;
DELETE;
END;
... View more