About antonbcristina

antonbcristina

Join us for this 11-week series to prepare to take a Base Programming Certification exam. We'll cover the SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques courses, as well as general exam preparation. We’re excited to kick-off our series this week. We’ll meet every Wednesday from Jan 22 – Apr 2, 2025, 4:30 – 6:00 p.m. EST. Our weekly live online sessions will include demos, Q&A, and discussions. On your own schedule, complete e-learning videos and exercises. Attend at least eight live sessions and complete the e-learning to receive a FREE certification voucher! As you navigate through the series, we encourage you to use this post to ask any questions and collaborate with other attendees.

antonbcristina

Hi @Yury2, that's right in SAS Studio there is wrapper code included with every run. It includes a global OPTIONS statement with DATE and NUMBER (among other things). You can view this wrapper code in SAS Studio by navigating to More Options (three dot menu at the top right of the editor window) > Open in a browser tab > Log. My LOG for the program above has this statement at line 14: 14 options dtreset date number;

antonbcristina

Hi @Yury2, you're on the right track, those are indeed the options you'd want to use to remove the date and page number. I don't see the options in the sample code provided so I'm not sure where they were inserted. However, keep in mind that these options have to be set before the PDF is produced. Here is an example I tested that worked: option nonumber nodate; ods pdf file="~/class.pdf"; proc print data=sashelp.class; run; ods pdf close;

antonbcristina

Thank you, I'm delighted to join this wonderful group of helpful SUPER FREQs!!

antonbcristina · ‎12-06-2024

Hi @TH0098, could you provide more information? What Coursera course are you taking and which SAS platform are you using? Is the work for the course done in SAS Studio by any chance?

antonbcristina · ‎12-02-2024

Hi @NewUsrStat, a simple sort will work here, making sure to sort by all columns and descending values for variable1/2: proc sort data=have out=want; by id admission discharge descending variable1 descending variable2; run;

antonbcristina · ‎11-29-2024

Hi @NewUsrStat, here's a quick solution: 1. Create flags which capture the index for the duplicate dates which have Variable1=. and Variable2 =. and Index = 1 data have_flags; set have; by id admission discharge; if variable1 =. and variable2 =. and index^=. then flag=index; if flag=1; keep id admission discharge flag; run; 2. Merge have_flags back in with the original dataset by id, admission and discharge dates. Using the logic you described, assign index=. or index=flag: data want; merge have have_flags; by id admission discharge; if variable1=. and variable2=. and flag=1 then index=.; else if variable1^=. and variable2^=. and index=0 and flag^=. then index=flag; drop flag; run; Hope this helps!

antonbcristina · ‎11-13-2024

Today, in our second last class, we will be answering any remaining questions from your assigned homework from the SAS Programming 2 course: Lesson 5.3 - 7 | practices, activities We will also discuss the structure of the exams and how best to review. See you in class!

antonbcristina · ‎11-06-2024

Welcome back everyone! In preparation for today’s class, your homework is the following from the SAS Programming 2 course: Lesson 3.4 - 5.2 | practices, activities Lesson 5.3 - 7 | e-learning We’ll see you shortly!

antonbcristina · ‎10-30-2024

So glad to have you back for another week! Please review the following from the SAS Programming 2 course: Lesson 2.2 - 3.3 | practices, activities Lesson 3.4 - 5.2 | e-learning Please let us know if any questions come up during your review and we’ll see you all soon in class!

antonbcristina · ‎10-29-2024

Hi @josem, you'll need to add the following statement before you run the macro: options mcompilenote=all; This will write the message to the LOG that your macro definition compiled successfully.

antonbcristina · ‎10-28-2024

Hi @duckduckgo, according to the documentation on the ROUND function, it rounds the first argument to the nearest multiple of the second argument. The nearest multiple of 1.2 is 3.6 (I believe this was a typo in your original message) and the nearest multiple of 1.5 is indeed 3.

antonbcristina · ‎10-23-2024

Welcome back for Week 8! As a reminder, please review the following from the SAS Programming 2: Data Manipulation Techniques course: Lesson 1 - 2.1 | practices, activities Lesson 2.2 - 3.3 | e-learning We’re happy to answer any questions you might have, please post them here or bring them to class. See you all very soon!

antonbcristina · ‎10-22-2024

Hi @NewUsrStat, try using the SUBSTR function without a length provided to read until the end of the string. Here's the test dataset I used and adjusted code: data mydb; input var $6.; datalines; 20213 202212 ; run; data db; set mydb; year=substr(var,1,4); month=substr(var,5); run; Notice that to read in the year, you'll want to start at position 1 and read for a length of 4 characters. For the month, you'll start reading at position 5 and without the last argument provided (length), continue reading until the end of the string. This should capture both single and double digit month numbers.

antonbcristina · ‎10-18-2024

Hi @Eric_P_Elkin, in SAS Studio the wrapper code includes a null TITLE and FOOTNOTE statement (among other things) to clear all titles and footnotes. The wrapper code is included with every run. You can view this wrapper code in SAS Studio by navigating to More Options (three dot menu at the top right of the editor window) > Open in a browser tab > Log. My program has this at lines 10-11. This means that when I run (a version) of your program all together (i.e. both steps together), I get the following: However, if I run them separately I'll see the titles as you described. and

Online Status	Offline
Date Last Visited	yesterday

Attention Educators and Students in the Americas - FREE Programming Ce...

Re: How to remove date and page number from the PDF destination?

Re: How to remove date and page number from the PDF destination?

Re: Meet the Super FREQs

Re: Server Files and Folders panel

Re: Swap rows with missing values with the ones without missing

Re: Move values of a variable when missing values of another variable(...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: register

Los Tonotos - Team Profile

Too Good To Be True (TGTBT) - Data for Good | Climate Change + Vulnera...

Purdue ORSOL - Team Profile

Clarkulators - Data for Good | Climate Change + Vulnerable Populations

Attention Educators and Students in the Americas - FREE Programming Ce...

Re: Meet the Super FREQs

Re: Swap rows with missing values with the ones without missing

Re: Move values of a variable when missing values of another variable(...

Re: Advanced Certification Practice Exam stored compiled macro, cars18

Attention Educators and Students in the Americas - FREE Programming Ce...

Re: How to remove date and page number from the PDF destination?

Re: How to remove date and page number from the PDF destination?

Re: Meet the Super FREQs

Re: Server Files and Folders panel

Re: Swap rows with missing values with the ones without missing

Re: Move values of a variable when missing values of another variable(...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Advanced Certification Practice Exam stored compiled macro, cars18

Re: round(3.1415, 1.5) = 3

Re: Attention Educators and Students in the Americas - Free Programmin...

Re: Subset from dates

Re: TITLE statements in SAS Studio - are they global statements?

SAS Analytics Explorers