Join this webinar to explore the capabilities of SAS Viya and how to put them to work for you.   You will learn to: Understand the core qualities and basic architecture of SAS Viya. Use the suite of SAS Viya applications to manage and explore data, develop models and deploy insights. Develop code using either SAS or Python in SAS Viya. Use SAS Viya Copilot to accelerate development with AI-assisted code generation, explanations and productivity enhancements. Register Now ... View more

Join this webinar to explore the current capabilities of SAS®9 and plans for the upcoming SAS 9.4 M10 release.   You will learn about: Current SAS®9 capabilities. Product plans for the upcoming SAS 9.4 M10 release. The SAS 9.4 product strategy. Register Now ... View more

I open SAS.   I submit a macro (just submit it, so nothing happens except it puts the macro into memory).  A line in the macro points to a formats library.   I call the macro, so the guts of the macro runs.   When the macro runs it creates a dataset.  After running the macro I do a PROC FREQ on that dataset.  All the formats are applied correctly.   Then I call the macro again.  I do not submit the macro itself again, rather I just call (run) it.  I change nothing and I do nothing else.  All I do is call the macro a second time.   Then I do that same PROC FREQ mentioned above and this time some...not all, but some...of the formats are not applied.   So the 1st time I run the PROC FREQ I see all words (the formatted values) instead of their underlying numbers.   And the 2nd time I run the PROC FREQ I still see mostly words (the formatted values), but for some of them I see their underlying numbers instead.   And every subsequent time I run it I see the mostly words but some underlying numbers instead.   IOW, it works properly after I open a new SAS session and run it for the first time.   And it doesn't work properly every subsequent time I run it.   Any idea? ... View more

Error: ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.   code :   proc sql; connect to pcfiles(path="&path/database/SQL_DB.accdb" dbpassword=sastest); select UserID, Income format=dollar16., State from connection to pcfiles (select top 10, UserID, Income, State from customer order by Income desc); disconnect from pcfiles; quit;   I am learning sas sql 1 essential , currently at lesson 7 , there is an activity s107a01.sas . I don't know the server ! Please help . ... View more

As someone who still happily uses Display Manager, I like that I can configure it to automatically open ODS results using an external application (PowerPoint, Word, Adobe reader, whatever).   Is there a feature like that in VS Code extension / VS Code?  I'm running VS Code locally, and connecting to local SAS 9.   AI suggests I use an X statement to open a file, which sounds like a reasonable approach.  But curious if a human knows a way to configure the output files to open automatically in an external application.   Particularly interested in getting ODS PowerPoint to automatically pop open, at the moment. ... View more