Home

Shakti_Sourav

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

BeerSultan

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;

gra_in_aus

Hi, I am wondering if Spark can be made natively available on SAS Viya? As I don't want to push data outside of the Viya environment. Many thanks G

Ronein

Hello The raw data set have till 6 rows for each customer (Each row represent information of a month). It might happen that customer have less than 6 rows. From list of variables (let's say X,Y,Z) I need to calculate for each variable a new calculated variable (called calc_X,Calc_Y,Calc_Z) . The logic how to calculate these 3 variables is as following: 1-If customer have less then 4 rows then each of the variables be null (calc_X,Calc_Y,Calc_Z) 2-If customer have at least 4 rows then need to calculate do this calculation for each of the variables (X,Y,Z). calculate CV(STD/AVG) IF CV<=0.8 then the calculated value equal to average else IF 0.8<CV<=1.5 then calculated value equal to the value of second observation after sort it from low to high else IF CV>1.5 then calculated value equal to the value of First observation after sort it from low to high (note- sort by the variable that we want to calculate. For example: if we calculate calc_X then sort by X) Here is example to raw data set. Please not the request to calculated : Calc_X,Calc_Y,Calc_Z (and not calculate for R and T) In real life I have 100 variables to calculate Data have; Input custID YYYYMM X Y Z R T; cards; 1 202206 10 20 30 40 50 1 202207 15 20 25 30 35 1 202208 30 20 15 10 12 1 202209 15 18 21 27 31 1 202210 19 22 40 15 12 1 202211 40 20 30 10 25 2 202210 25 45 35 15 10 2 202211 20 16 18 24 31 ; Run; What id the recommended way to do it please?

SASuserlot

I have sas 9.4 TS level 1M7 version. I am having a problem using sas. When I increase my display setting on the computer is more than 100%. Sas becomes slow, has a hard time opening the dataset, moving between the tabs, lag, and stickiness of the scroll bar for the editor window. With the 100% setting, the font is very small in all Icons like filenames, folder names in the system, and even the font in the dataset; my eyes really get bad with this kind of setting. What to do?