Kick-start Your Data Exploration Journey with SAS Information Catalog
Recent Library Articles
Recently in the SAS Community Library: @smanoj introduces you to the SAS Information Catalog, which provides a powerful search engine to find needed data assets.
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
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
... 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
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?
... View more
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?
... View more