Using The SAS VS Code Extension to Check Prime Distribution
Recent Library Articles
Recently in the SAS Community Library: @RyanKing showcases features in the SAS Visual Studio Code extension, including data exploration using SAS, SQL and Python in one SAS notebook file.
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