Hi, I am using this code for pulling the birthdate >17years FLOOR(intck('MONTH',datepart(pt.BIRTH_DATE), date())/12)> 17   But the person who has DOB of 06/29/2006 is considered as 18years and pulling that person. i tried not to use FLOOR and it still gives me the same 18years.   Can I fix this. ... View more

17JUL2015:16:10:00.000   I want to format to 07-17-2015 HH:MM ... View more

Dataset A: ID       Episode 1          1000 2         3000 3        4000 4       5000   Dataset B: ID  Episode 1      1000 2      2000 3      7000 5     9000   Proc Sql; create table check as select a.*,b.* from datasetA as a on a.ID=b.ID and a.Episode=b.Episode where b.ID-NULL and b.Episode=NULL ; quit;   Please let me know the result and how it works. thank you in advance. ... View more

I have the code in SQL. But  its not working in SAS procsql. Is there anyway that I could work it in SAS proc SQL? select * when code like '43[0-8]%' then 'A' when code like '582.%' then 'B' when code like '58[56]%' then 'C' from table ; quit;   I want this is SAS. I am not getting the result of % ... View more

I have the dataset A which has Numeric Date   20120321 20130823 20220914 20200813 I want to change the format like below. And want to be the same numeric. 2012-03-21 2013-08-23 2022-09-14 2020-08-13   thanks in Advance ... View more

I have a dataset with 20170306 20180306 I want to change to  2017-03-06 2018-03-06 with dashes.     ... View more

ID        Type       Date                              visit 1          New        01/23/2023                314566 1          New          03/23/2023              102345 1          New          02/12/2022                314566 1         return         04/05/2023             102345 1       return            05/01/2023            102345     the above data should have only one New. I want to select only one New from the visit number which is similar to return visit number. And delete the rest of New which has different visit number. I want to do the code for the large dataset. output example: ID           Type                          Date                            visit 1              New                    03/23/2023                  102345 1              return                 04/05/2023                  102345 1              return                 05/01/2023                   102345 ... View more

Hi, I have a dataset of 3000 ID's. I need to flag specific 200ID's as "Not sure". Since it is huge number of ID's, I am not sure how to flag the specific 200 ID's. this should be done everyweek.       ... View more

ID                   Car                    Date                                                                                                                                1                     MB     20MAR2023:06:01:27.967                                                                                                        2                     EC     12FEB2022:06:01:27.967                                                                                                          3                     DE     14APR2022:06:01:27.967                                                                                                          1                     MB     29MAR2023:06:01:27.967                                                                                                        2                     EC     29MAR2023:06:01:27.967   I want the dataset which has only todays date  29MAR2023:06:01:27.967        1                     MB     29MAR2023:06:01:27.967                                                                                                        2                     EC     29MAR2023:06:01:27.967 ... View more

Hi, How I will check the duplicates with the below dataset daily? ID     Car                    Date 1       MB    20MAR2023:06:01:27.967 2        EC   12FEB2022:06:01:27.967 3        DE    14APR2022:06:01:27.967 1       MB     23MAR2023:06:01:27.967 2        EC    23MAR2023:06:01:27.967   I want to check the duplicates which created today and email  daily based on the everyday's date.   1       MB     23MAR2023:06:01:27.967 1       MB    20MAR2023:06:01:27.967 2        EC    23MAR2023:06:01:27.967 2        EC    12FEB2022:06:01:27.967   these are the duplicates which created today. I want this to come to my email.    thank you in advance   ... View more

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