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

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

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

I have a dataset  Id system1 system2 system3 system4 1 0001 0001 0001 0002 2 0002 0001 0002 0003 3 0003 0002 0002 0004 4 missing 0001 missing missing   I want to the new data set to include a new column which is the most frequent value across these systems. Id system1 system2 system3 system4 mostfrequent countofmostfrequent 1 0001 0001 0001 0002 0001 3 2 0002 0001 0002 0003 0002 2 3 0003 0002 0002 0004 0002 2  4 missing 0001 missing missing 0001 1   Any help you can provide would be greatly appreciated!   ... View more

Few business units using customized workspace folders instead of default work spaces (like /saswork, /tmp). Is there any way to check customized workspace configuration in SAS 9.4 M7? ... View more