Hi SAS Programming Community,   I’m presenting a live “Ask the Expert” webinar on August 23 rd , 11 AM – Noon ET entitled Using Arrays and DO Loops: Do Over or Do I?   In this introduction to the ARRAYs and DO loops I’ll cover how to use SAS ARRAYs and DO loops in the DATA step to improve programming efficiency. I’ll talk about indexed and non-indexed ARRAYs, iterative and non-iterative DO loops, and DO WHILE and DO UNTIL loops. Bring your questions. I’ll host a live Q&A session at the end of the webinar.   You will learn how to: Use an indexed array and indexed DO loop. Use a non-indexed array and DO over loop. Use DO WHILE and DO UNTIL loops.the advanced features of SAS survey procs. Reserve your spot for the webinar.   Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from this and other SAS Ask the Expert webinars.   Can't join the live event? You can view this and other Ask the Expert sessions on-demand here.    I'm looking forward to sharing the information to increase this tool in your toolbox and answering questions about arrays and do loops for you.   Jennifer ... View more

Not quite sure where to post this so I chose Admin.  I think @ChrisHemedinger has answered some questions on this topic, but I thought the fastest way to get an answer would be on communities.  My current machine (a MacBook Pro manufactured in 2017) is on the "unable to support" list now due to it's age and I need to get a new machine.  My institution is unable to purchase a MacBook Pro with an Intel chip (i9 specifically) that has adequate memory and space needs.  I have looked and they aren't out there.  So I am going to have to purchase a MacBook Pro with an M1 chip.     First, I cannot utilize SAS ODA as many of my datasets are at least a TB in size and that would preclude being able to upload them.     Second, I work for a academic institution that has not (and I have no idea if they plan to) moved to SAS Viya and we are only licensed for SAS for Windows.     Third, I like a Mac and have been using one for nearly my entire career.  I will not go over to what I call the "dark side" and utilize some type of completely windows OS based machine.  Please don't try to convert me.  You like what machine type you like and I like what machine type I like.    Fourth, because of memory and space needs for utilizing SAS, I do need to it under a Windows VM and I have been using VM Fusion running some version of Windows OS (currently version 10), successfully for years (like nearly my entire career) and I work seamlessly between the VM and other apps running on the Mac.  However, I have done some research and found that Fusion isn't quite there yet with running Windows on an M1 chip.  They are getting there.  I am looking into Parallels but I believe that 1) you have to run and ARM of Windows (I am not sure what that means) and 1) I believe the current version of Parallels (version 17) only allows for Windows 11 (people have indicated that they haven't been successful in installing Windows 10).   So my questions are: Has anyone successfully installed and used SAS on a Mac with an M1 chip?  If yes, what VM software did you use? Will SAS run under ARM Windows on a VM? Will SAS run under Windows 11 on a VM? Checked support.sas.com and this note indicated it was being tested (https://support.sas.com/kb/68/554.html), but I am wondering what the time frame for this is. Jenn ... View more

If you're copying and pasting code over and over to perform the same operation on multiple variables in a SAS DATA step, you need to learn about arrays and DO loops. Arrays and DO loops are efficient and powerful data manipulation tools that belong in your programmer’s toolbox. In this 20-minute workshop, you'll learn how to create an array and use DO loops to perform operations on the elements in an array, create new variables, and change a short and wide data structure to a long and skinny one.           Video highlights 00:40 - What is an array? 01:22 - What is a DO loop? 04:47 - Syntax of an array 05:34 - For indexed array, indicate number of elements in curly brackets 05:49 - Character variables? Designate array with dollar sign 06:00 - Other options for variables 08:12 - Start with array statement, end with semicolon 11:46 - How to reference an array in an interative DO loop or indexed DO loop 15:19 - Example of a do-over loop with a non-indexed array   Read the Paper Related resources GitHub materials How to Restructure Your Data Using Arrays and DO Loops (YouTube tutorial)   ... View more

  The SGUG is currently accepting applications for the SASGF 2021 Conference Chair.  You can find more information about what it takes on the sascommunity.org Conference Leadership page (http://www.sascommunity.org/wiki/Conference_Leadership), read the blog (https://blogs.sas.com/content/sgf/2018/01/12/interested-in-being-the-sas-global-forum-2021-conference-chair-apply-now/), or by contacting me (Jennifer Waller).     We also have different opportunities for getting more involved that can also be found on the Conference Leadership page listed above.   I would love to start a conversation with you if you have questions.  As well, feel free to share this with those you feel want to get more involved as well.   Jennifer ... View more