%let runDate=%sysfunc(putn(%sysfunc(date()), yymmddn8.)); %put &runDate; I want to format the date like 3_11_2025 ... View more

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