I have a dataset A which has temporary studyID: ID  studyID    Fit      Grow   Date 1    T2345       10      22       02232022 2    T4568       12      23       04162021 3    T5674       10        .        04172022   daily the above dataset gets updated. If the ID, FIT and GROW is same then the StudyID gets permanent studyID ID    studyID       Fit    Grow          Date 1       34567        10      22         03292023 2       45678        12      23         03292023 3       T5674        10        .          03292023 3       45673         10      21        03292023   I see there are duplicates in todays update. this happened because Grow variable is different now. Whenever I get these kind duplicates I need to automate the code on how to check this daily and receive an email if there are duplicates in daily run Can I do this in SAS?     thanks in advance. ... View more

Hi, I have a datset which has 5digit numbers that ends with 2 or 4. I want to delete the entire row if the last digit is 4. example: ID         Sample 1        00012 2        00034 3        00032 4         00124 5         00432   I want to delete the row which has the last digit 4. In the above example, I want to delete 00034 and 00124. Can I do this in SAS to remove if the 5th digit is 4.   thanks in advance.     ... View more

Hi, I have a dataset A ID      date 1      12/13/2022 1            .        1      12/13/2022 1             . 2       03/26/1978 2             . 2             . 3        07/29/1980 4        10/02/1982 4                 .   I want the dataset B to fill the Date based on the ID's Example:   ID      date 1      12/13/2022 1      12/13/2022        1      12/13/2022 1      12/13/2022 2       03/26/1978 2       03/26/1978 2       03/26/1978       3       07/29/1980 4       10/02/1982 4       10/02/1982           data b; set a;   could you let me know how to do this in SAS?   thanks in advance ... View more

Hi, I have dataset a ID         Version        Session_A     SetA           SetB 1            2234            2234             1 1            2234            2236                                 1 2            3345            3345             1 2            3345            3367                                  1 3            4456            4456                                  1 4            5568            5568                                   1 5            5568            5523                                   1 I would like to delete all the setB which has SetA=1 with same Version output dataset B: ID         Version        Session_A     SetA           SetB 3            4456            4456                                  1 4            5568            5568                                   1 5            5568            5523                                   1   thanks in advance   ... View more

Hi, I need a dataset from  07/29/2022 to 08/31/2022 in SAS.   thanks in advance.     ... View more

Hi, I have a character variables and I want to make it to 5digits by filling with zero at the starting. ID 11 21 31 451 5671   Want: 00011 00021 00031 00451 05671 thank you in advance ... View more

Hi, I have a dataset ID                 vin                   zip              11221         7896            43567 11221         7654             43567 13456         5433              41323 13456         5433              41323 16754          6432              51678 16754         6432               51678   I want to remove the duplicates and want to save what I removed. in a separate dataset. Removed_duplicates ID               vin                     zip 13456        5433               41323 16754        6432                51678   thanks in advance.   ... View more

Hi, I have a dataset DOB (character) 07/1980 03/1978 10/1982 I want this to change to numeric. And a separate month and year column added. DOB(numeric)           Month                 Year 07/1980                     July                    1980 03/1978                     March                1978 10/1982                    October              1982   thanks in advance     ... View more

Hi, I want to decidentify the dates which is mm/dd/yyyy format. Example: 07/29/1980 09/27/2008 06/23/2003 01/25/2006 And also want to retrieve the original dates when needed in future. Thanks in advance. ... View more

I have an excel file and needs to import into SAS. Somehow this is not working. any tricks here?   proc import datafile="folder\file.xlsx" dbms=xlsx replace out=a; guessingrows=3000;/*guessingrows helps not to truncate the observations*/ run; I am doing something wrong here? the log says "DBMS type xlsx is not valid to import"   thanks in advance. ... View more