Hello. I would like to add some values to one of the variables (Va).  I would like to add some code, but the first problem I encounter is how to read the data, given that all the variables (in row B in the attached file) have the same name for different individuals (in row A). Attached is a simplified version of my dataset, what I have in the first 11 rows, and what I would like to have. Could you please help me with this? ... View more

Windows 10 Pro machine -- new install of SAS 9.4.  Installation proceeds normally (I simply accepted the defaults to confirm that wasn't going to be a problem), until I get to      Click next, and....installer throws the following error, and upon 'clicking OK' exits.      The log it refers to is filled with lines like the following:         INFO: ExeProc::ReadFromPipe=Standard output       java.nio.file.NoSuchFileException: C:\Users\egc\Desktop\sas.installer\hot_fix\M2K007pt.zip       at java.base/sun.nio.fs.WindowsException.translateToIOException(Unknown Source)       at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source) A recent JRE is already on the machine     java version "1.8.0_451" Java(TM) SE Runtime Environment (build 1.8.0_451-b10) Java HotSpot(TM) 64-Bit Server VM (build 25.451-b10, mixed mode) but since 9.4 is in theory bundled with a private JRE, I'm puzzled as to what the error log is telling me -- no Java? incompatible Java? Something else?   Suggestions/pointers to the obvious most welcome.  ... View more

Is Your Marketing Technology Keeping Up with Today’s Consumers?     Today’s customers expect more—more personalization, more immediacy, and more control over how they receive messages. If your marketing technology isn’t keeping up, you could be missing critical opportunities to drive revenue, build trust, and grow lasting loyalty.   Think about it: Social media is now a dominant marketing channel. Can your current system easily connect with consumers across platforms like Instagram, Facebook, and TikTok?   Traditional methods like email and direct mail still play a role, but they’ve been overtaken by the demand for real-time, cross-channel communication. Can your martech stack deliver the right message, at the right time, in the right place?   Is your data working hard enough for you? Are your campaigns performing as they should? If you’re wrestling with these questions and more, we invite you to find answers in a fun and interactive way.     Join Digital Alchemy and SAS for the Escape Room Webinar     June 26 | 11 AM EST | 90 Minutes   This isn’t your typical webinar. It’s a gamified, team-based experience where you'll solve marketing challenges to advance through a series of “rooms.” Each stage dives into a critical area of modern marketing: Data, Automation, Performance, and Personalization. You’ll hear real-world insights, explore success stories, and discover the latest technologies from SAS and Digital Alchemy that can help future-proof your marketing strategy.   This event is designed by marketers, for marketers—and it’s anything but boring.     Ready to Escape the Limits of Outdated Technology?   Register now and get ready for a unique, hands-on learning experience that just might change the way you think about marketing.     About Digital Alchemy   Digital Alchemy is a global marketing consultancy and SAS Gold-certified Customer Intelligence partner that helps clients unlock their marketing potential by developing data and communication strategies that build customer loyalty. By leveraging our innovative Automation by Design framework, clients benefit from 20 years of marketing expertise, resulting in faster ROI with proven martech tools and strategies that marketers love. With experts in data, marketing operations, optimization, and more, our Alchemists can improve, scale, and re-imagine your marketing.         Dave Gribbin Presales and Consulting Lead Digital Alchemy (North America) LLC       ... View more

Hi,    I have dataset that looks like this:    Locker ID Locations Person A Person B Person C Person A Code Person B Code Person C Code 101 Hampersmith, Silvershine Sam Copewell Amy Baker John Aston 123A 234B 345C 102 Coleridge, Brisbake Claude Tremaine Marissa Carter   567D 678E   103 Waterloop, Sturrey Brian Amble Charlie Springwater Mandy Smith 012G 134H 245J   I want to split this data set into multiple rows by the persons like so:   Locker ID Locations Person Person Code 101 Hampersmith, Silvershine Sam Copewell 123A 101  Hampersmith, Silvershine Amy Baker 234B 101 Hampersmith, Silvershine John Aston 345C 102 Coleridge, Brisbake Claude Tremaine 567D 102 Coleridge, Brisbake Marissa Carter 678E 103 Waterloop, Sturrey Brian Amble 012G 103 Waterloop, Sturrey Charlie Springwater 134H 103 Waterloop, Sturrey Mandy Smith 245J   Please can you help, all numbers/letters are just placeholders so avoiding code that specifies any of that.   Appreciate your help! ... View more

Hi everyone, I’m accessing Snowflake tables through SAS Data Integration Studio using the Snowflake connector. When I register  table from Snowflake in SAS DI, I noticed that VARCHAR(n) columns are automatically assigned LENGTH=3n in SAS metadata. For example: VARCHAR(2) becomes LENGTH=6. Why does this happen, even though both systems use UTF-8? Thanks in advance! ... View more