So I came across an issue with some data and I need to figure out a way for SAS to scan the dataset and replace with certain criteria.   The dataset is roughly 1mil rows so that adds to my complexity with trying to work this out.   So what I am looking for is that everytime the row meets the following criteria: Name in ('Matt') Segment in ('Tall') Number in ('20') Color in ('Blue')   I would need it to replace with: Name in ('John') Segment in ('Short') Number in ('40') Color in ('Green')     I am just not sure how to do this replacing data with very specific row criteria like this.  I was thinking about a If/then statement in proc sql, but again I am not 100% sure of the syntax needed.   Thank you for anyone who can help. ... View more

So I have two fields, name and type and I am trying to figure how to break this out into more distinct columns.   Name has just different names of users   Type has different colors.   So what I am trying to do is: Name Count of Red Count of Blue Count of Green Matt                4                    1                     2   Ben                 2                    3                    0 Frank              6                    4                    1 ... View more

So I have a file that has the following data: User, Session   What I want to happen is I want to list a user and then for each of the three sessions have a "Y" or "N" if they attended.  So something like this:   User Session 1 Session 2 Session 3 Harry Crumb Y N Y   I have tried this code, however I am getting three separate lines generated.  So I am trying to figure out how to put everything on the 1 line.   CASE when Session in ('Session_1') then ('Y) else ('N') end as Session_1, CASE when Session in ('Wave_2') then ('Y') else ('N') end as WAVE_2, CASE when Session in ('Session_3') then ('Y') else ('N') end as Session_3   I was trying to search for the answer, but I am not sure what this type of syntax is called. ... View more

So in our user group meeting someone asked the following:   When you schedule a process flow, can you tell Enterprise Guide that you want to schedule daily, but only on business days.  Being new to Enterprise Guide I was unsure, though I am pretty sure they use Microsoft's scheduler somehow, so I thought since Outlook lets you do this with their calander, you should be able to do it in Enterprise Guide.  Any ideas? ... View more

So I am trying to understand how best to do this using Perl.  I have some sample data which I want to read in as a data step.   So    Data work.test; set work.PerlData; run; However I want to use the following prxparse('/spa/'); I am just not sure how to use this Perl script to show me all hotel names with Spa within it.   Excel file looks like: (all fictious data) Just trying to understand Perl before I try it with real data.   Hotel_Name Company Phone Manager Email Ivory Courtyard Resort Ac Metus Vitae LLC (140) 462-6599 Felicia Hutchinson blandit.Nam.nulla@commodoauctor.edu Sunrise Mirror Resort Quisque Tincidunt Company (544) 574-0753 Hollee Clayton lacinia.at@interdumlibero.edu Crimson Shore Hotel Et Netus Et Consulting (931) 720-2951 Pascale Bell sapien@vulputate.co.uk Pleasant Circus Resort & Spa Ut Sem LLP (262) 723-5866 Leonard Middleton elementum.at.egestas@infelisNulla.com Lord's Plains Hotel Et Netus Corporation (673) 576-3366 Zeus Chan sagittis.felis.Donec@lobortistellus.edu Noble Refuge Hotel Donec Corporation (110) 924-8302 Leilani Shelton rhoncus@interdum.com Revelation Hotel & Spa Aliquam Tincidunt Nunc Corp. (559) 588-0513 Armand Bishop eros.Nam.consequat@Aliquameratvolutpat.org Countryside Hotel Purus Company (241) 761-4967 Seth Slater Duis.elementum.dui@eu.net Panorama Hotel & Spa Adipiscing Incorporated (113) 803-4658 Tamekah Conrad ligula.Donec@Nunccommodo.com Stellar Hotel & Spa Magnis Dis Parturient Associates (515) 575-5373 Forrest Haley eu.elit.Nulla@ultriciesdignissimlacus.com Northern Obelisk Hotel Nec Associates (320) 680-9409 Kim Malone cursus.et@ametmetusAliquam.ca Western Thicket Resort & Spa Felis Orci Adipiscing Corporation (713) 874-6161 Wang Melendez leo.in@Uttinciduntorci.net Noble Heritage Hotel Nostra Per LLC (918) 899-8305 Ira Thompson Sed@Proinsed.edu Ruby Mansion Resort Eu Dui Associates (110) 805-0328 Tobias Britt enim@orcitincidunt.edu ... View more