SAS Tutorial | SAS Date Functions FAQs

[@gulammohiddin5747]

I always had doubts regarding date and datetime formats. This tutorial explains so elegantly. Thanks.

[@SASUsers]

Thanks for sharing!

[@woodyclermont1157]

Using that input function to convert from character to an actual SAS date to be used to find out the number of days or years passed, is very helpful! data _NULL_; tday = today(); begin = input('18DEC2018',anydtdte12.); Method1 = tday-begin; Method2 = intck('days', begin, tday); put 'As of' tday WORDDATE18. ', number of days difference is ' Method1 Method2; run;

[@muwongejosephjunior6131]

Perfect! Thank you very much for the time invested!

[@SASUsers]

So glad you found it helpful! 🙂

[@swatts0813]

Thanks for the clear tutorial - this saved me so much time!

[@SASUsers]

Awesome! Thanks for sharing the feedback!

[@ashwinbhaskar8945]

Thank you for the fantastic explanation. Please do more videos.. Keep it up

[@sunnylk6991]

Thank you so much. You saved me time trying to figure out this.

[@SASUsers]

Rose, Awesome! So glad you found it helpful!

[@melindaschultz3717]

This is SO HELPFUL!

[@SASUsers]

So glad you found it useful! 🙂

[@emfl4437]

Excellent video, thanks for the straightforward explanations and tutorial

[@SASUsers]

We're glad you liked it!

[@EderbalFilho]

Very Good!

[@vijaymore8433]

You are amazing teacher

[@SASUsers]

Vijay, thank you so much for the positive feedback!

[@srividhya1107]

Thanks for the great video ! Just have one question at the very last, where the time part wasnot shown correctly. Everything is created as 12 AM(00:00:00). Seems the time part wasn't read correctly. Please check the reason and post solution for it.

[@SASUsers]

Thanks for the question, Sri. We are looking into this for you.

[@SASUsers]

Great question, Sri. You are correct. There is a technical support note that discusses what you are seeing. You can read more in the Problem Note 46142: 2.sas.com/6054Kc4cI Sorry for the inconvenience. Take a look at the Usage Note 37309 for more information: 2.sas.com/6055Kc4cL Please let us know if you have any additional questions.

[@ToOpen6seven]

Excellent training! Do you have any training on programming of tables, listings and figures?

[@SASUsers]

Thank you for your feedback! We will research this for you!

[@SASUsers]

Hi: Typically, the phrase, "tables, listings and figures" relates to the Clinical Trials process because tables, listings and figures are required as part of a clinical study. We do not generally have videos on industry-specific reports like this. Each pharmaceutical company will have their own methods for complying with the regulatory requirements around producing tables, listings and figures. Many pharmaceutical companies will use a combination of PROC REPORT, PROC TABULATE and DATA step programming, along with SAS Macro Language programming in order to produce the tables, listings and figures needed for a study. Our web site for the Clinical Trials Programmer certification, here 2.sas.com/6056J5mi2 lists classes and books that are recommended to people who are preparing for this exam. The classes and books there might give you a place to start specifically in regard to Clinical Trials. For more general reporting needs, here are some books by Lisa Fine: 2.sas.com/6058J5mi4 , and by Jane Eslinger: 2.sas.com/6050J5miA to help you get started with PROC REPORT.

[@RajatMadaanmaddy]

Dear Proff ,, Can you please create a playlist topic vise or like lecture 1 2 and so on ,, so it will be easy for sas users like me to understand things better. I checked your channe and in the videos section , ,, there are over 100+ videos from different teachers and i am not getting from where i can begin.

[@SASUsers]

Hello, Rajat, and thank you for your feedback! We already have several helpful playlists on our SAS Users KZbin channel. You can find them by clicking on the Playlists tab (the third tab) from our main channel site, or you can click this link: 2.sas.com/6053H9iC5 We have other excellent resources to help you learn SAS on our own website too, including free e-Learning courses, free learning versions of SAS software, and other helpful things like our free online documentation and online SAS Support Communities! You can learn about all of those from our #SAS Starter Kit, your one-stop-shop for resources, connecting with other SAS users, and product information! 2.sas.com/6054H9iCg If you are a university or college student please let us know, and we will share our information for #Academic #SASLearners too!

[@RajatMadaanmaddy]

@@SASUsers I saw playlist section but I didn't want any topic related videos. Yes I am a college student and I have just started learning it for future jobs

[@SASUsers]

Thanks, Rajat! Our KZbin videos are intended to be for specific topics, while our #SASTraining courses are designed to teach skills like #SAS Programming and how to use SAS software. As a student, you get access to over 20 of those e-Learning courses and #SASCertification prep material #Free in our SAS Academic Hub! *Note: you'll need to use your college email address to get access. 2.sas.com/6054Hi8WE We have lots of other great resources for students too, like free learning versions of SAS! 2.sas.com/6055Hi8W1 We hope those help, and we wish you much success with SAS!

[@wenpengdi5807]

hi, this video is really clear and helpful, just a quick question, what if I want to keep some decimals of the age but not the integer part

[@SASUsers]

We're looking into this for you. Stay tuned, we'll have a reply for you shortly!

[@SASUsers]

The program below represents one approach to obtaining the decimal portion of a calculated age value. “ Let us know if this helps! data testcalc; /* in an assigment statement, use a date constant to */ /* populate a new numeric variable with a birth date */ Bday='01JAN1999'd; /* calculate age using the yrdif() and today() functions */ AgeDecimalYRDIF = yrdif(Bday, today(), 'AGE'); /* truncate off the decimal with the int() function */ AgeIntegerYRDIF = int(yrdif(Bday, today(), 'AGE')); /* to capture the decimal portion from the age calculation you only */ /* need to subtract the integer portion (AgeIntegerYRDIF) from the */ /* calculated age value (AgeDecimalYRDIF) as is done with the */ /* assignment statement below producing the AgeDecimalOnly variable */ AgeDecimalOnly = AgeDecimalYRDIF - AgeIntegerYRDIF; /* to reduce the number of decimal places (i.e. less precision) you can */ /* use the round() function - its use below rounds to 3 decimal places */ AgeDecOnlyReduce = round(AgeDecimalOnly, .001); run;

[@wenpengdi5807]

SAS Users never thought u could really reply to me, that's very helpful. Appreciate!

[@SASUsers]

Absolutely! The SAS Communities 2.sas.com/60561Yd6g is a great resource for programming/content-related questions. Experts always ready and willing to help! Good luck and let us know if you have any other questions we can assist you with!

[@anu6227-k2n]

how to read these values 01, 02, 12, 14, 09 as month in mdy function?

[@SASUsers]

Thanks for the question, Anuradha. We are looking into this for you.

[@SASUsers]

Please email [e-mail] for additional assistance with this question.

[@ahmedalnajar1155]

so helpful, especially since the timestamps are available

[@SASUsers]

Ahmed, thank you for your feedback! So glad you found the video helpful!

[@chittalavenkatesh5975]

Any Proc SQL Videos??

[@SASUsers]

Yes, you can go to the SAS Users KZbin page and do search on various topics. See SAS Tutorial Merging Data Sets in SAS using SQL 2.sas.com/6051ECMT5

[@auroraliu2541]

The last lesson of the Free SAS Programming 1 self-pace e-learning has content on proc sql. There are short videos and demos www.sas.com/en_us/training/courses/learning-formats/e-learning.html

[@rimalmahesh]

not comprehensible. very rudimentary

[@SASUsers]

We're sorry to hear that, Mahesh. What specific questions or concerns do you have regarding the content? We're happy to share feedback with our content development team