About bnawrocki

bnawrocki · ‎02-24-2025

You're right. The full connection string contains a lot more options, like this example: Provider=SAOLEDB.1; Data Source=your_server_name; Initial Catalog=your_database_name; User ID=your_username; Password=your_password; But I'm connecting to SAS 9.4 running local on my Windows PC, so the only REQUIRED option is "Provider=". The other options are needed when you are connecting to SAS Viya or SAS 9.4 on a remote server. I have to admit, the Power BI OLE DB connection tool did ask for my userid and password the first time I tried the connection - so I entered my Windows domain ID and password into some textboxes that popped up, but after that, it didn't ask for userid or password again.

bnawrocki · ‎02-18-2025

Thanks that worked! IT has restricted my access to SASV9.CFG file, so I created an AUTOEXEC.SAS file containing the LIBNAME statements in a different folder: C:\Users\my-UserID. Then, I had to go to Windows Settings, Environment Variables, and add that folder to my PATH, so SAS would search for AUTOEXEC.SAS there.

bnawrocki · ‎02-12-2025

Like some others here, I am trying to use Power BI Desktop to connect to some SAS files that I have stored on my local laptop. My laptop is running Windows 10. On it, I have SAS 9.4 M7 and Power BI Desktop installed. Following some suggestions, I had luck connecting Power BI to SAS by choosing: Get Data --> Other --> OLE DB And using this Connection String: provider=sas.IOMProvider.9.47 (First time i do this, it asks me for my userid and password - I just entered my Windows userid and password for my laptop) And it works (sort of)! I can see a list of SAS built-in libraries and datasets - MAPS and SASHELP libraries. How do I add additional libraries to this list? For example, I'd like to see the SAS datasets stored on "C:\mySASFiles" which I usually submit a SAS statement in SAS Enterprise Guide like this: LIBNAME MYFILES "C:\mySASFiles";

bnawrocki · ‎11-17-2023

@ChrisHemedinger - thanks for the quick response. After reading your comments, I looked at SAS Enterprise Guide HTML option (via Tools --> Options-->HTML) and saw it uses HTMLBlue style. I was able to reproduce SAS EG's HTML style by adding this code to top of my SAS code in Visual Studio Code: ods html5 style=htmlblue; As a side note: I first saw Visual Studio Code and its SAS extension at SESUG2023 in Charlotte in October, so yes, a regional SAS conference is worth attending!

bnawrocki · ‎11-17-2023

Just started using this with my SAS 9.4 local PC Windows install, and first let me say, it looks awesome! I'm trying to get my whole dept to consider it as alternative to native PC 9.4 editor. I have two questions, though: 1) How do you get the LIBRARIES pane - as shown at 5:13 in the video. Is LIBRARIES pane only visible if you connect to SAS Viya? Is it visible for those of us using SAS 9.4 on our local Windows PC, with no SAS Viya server? I see the Libraries header, but when I expand it, it contains no library names, not even SASHELP. 2) Even though he is using SAS Dark theme, at 9:40 in the video, his SAS output shows with white background - similar to how it appears in SAS Enterprise Guide. But when I use SAS Dark theme, SAS output is also dark theme (dark background, etc.). How did he get output to appear with light background?

bnawrocki · ‎04-03-2023

I know this is a really old thread, but I finally have a use for this - I've got a SAS dataset with hundreds of hospital diagnosis codes, and I only want to keep the code fields that have at least one non-blank value (to save space). I was going to use Sridharma's %DROPMISS macro mentioned above (it's hundreds of lines of SAS code, but it works well). However, this option using the NLEVELS option (which I've never heard of) also works well, and it's MUCH shorter. I think I'll use that. Thanks!

bnawrocki · ‎03-13-2023

I can't roll back Windows updates, as they are mandated by my workplace IT group. Luckily, my IT support person remembered during SAS Enterprise Guide installation there was a suggestion of installing the 32-bit version of SAS EG (even though I have a 64-bit Windows 10 laptop). She installed that version, and the 32-bit version works! So I'm OK for now. Based on your experience - Connie_McManus - it does seem that SAS Enterprise Guide 64-bit was negatively affected by a Windows update.

bnawrocki · ‎01-19-2023

One day recently, SAS Enterprise Guide 8.3 stopped working. That is, I would select SAS Enterprise Guide 8.3 in the Windows Start menu (as I always did) and nothing happened - no splash/opening screen, nothing. I checked Windows Event Viewer, and it shows the error below. Our IT group couldn't figure out what's going on (others in my group have no problem running SAS EG). So, they gave me a new laptop and SAS EG was working when I left their office. But working at home (via VPN) a few days later, my new laptop (which still runs base SAS 9.4 OK) won't open SAS EG 8.3. Instead, I see this same error on Windows Event Viewer. I haven't installed anything on the new laptop since I left our IT office last week. Has anyone seen this error before? Any ideas what might be happening? ------------------------------------------------------------------------------------------------- Faulting application name: seguide.exe, version: 8.3.0.103, time stamp: 0x5f297a62 Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc0000005 Fault offset: 0x000000005dfe6c4e Faulting process id: 0x295c Faulting application start time: 0x01d92b4b650097e8 Faulting application path: C:\Program Files\SASHome\SASEnterpriseGuide\8\seguide.exe Faulting module path: unknown Report Id: 87c2585a-aa94-414b-9796-c49eaeeff7ed Faulting package full name: Faulting package-relative application ID:

bnawrocki · ‎10-04-2022

Trying to migrate completely from Base SAS 9.4 to Enterprise Guide (EG) .3, but EG's editor can't seem to do some things I got used to in Base SAS 9.4's editor. And there are some weird issues. For example: 1) When you highlight a word in EG editor, which might happen in a text search, ALL the text in editor becomes green - which makes it difficult to determine if the text you are searching for is within a commented-out section or not. Seems like a bug. 2) Many times I want to check number of observations in a dataset without writing SAS code. I can easily do this in Base SAS 9.4 (in Explorer window click Libraries, navigate to dataset, right-click, choose Properties, view Number of Rows). I cannot do that in EG - if I right-click a dataset name within the Servers pane, then choose Properties, I don't see Number of Rows. 3) When I open Properties box for a dataset in EG, that pop-up box prevents me from changing focus to another window - such as the editor window. That is, I cannot type any SAS code in editor without closing Properties pop-up box. Is there a place I can send "wish-list" items to EG development team?

bnawrocki · ‎07-08-2022

Here's something that worked for me. Part of your issue was that you weren't putting your code inside a %macro/%mend. I created a macro I called "doSomething" within %macro/%mend statements. I only used 2 variable values: Var1 and Var2, but I think you get the general idea, I hope. data ExEXc; input Variable $ Mean SD; datalines; Var1 2 0.67 Var2 3 0.43 ; run; %macro doSomething(); %let Var1 = Var1; %let Var2 = Var2; %let Pic1 = c:\temp\pic1.jpg; %let Pic2 = c:\temp\pic2.jpg; ods pdf file="C:\temp\Test.pdf" notoc startpage=no; %do i=1 %to 2; ods layout start width = 19cm height = 28cm ; ods region y=3cm x=0.4cm; proc report data=ExEXc; where variable = "&&Var&i"; run; ods region y=6cm x=3cm width=13cm height=8cm style={backgroundimage="&&Pic&i" }; ods text= " "; ods layout end; ods startpage=now; %end; ods pdf close; %mend; %doSomething();

bnawrocki · ‎04-18-2022

I think I figured this out. Sorry, but I'm a SAS Viya and SAS Studio noob. I could not see Task pane because I had somehow set my “perspective” to Interactive. Under the Options menu, I changed Perspective to Standard, and the Task pane (I yellow-highlighted it below) appears!

bnawrocki · ‎04-18-2022

I'm trying to write my first Task in SAS Studio 5.1, running SAS Viya on Linux. For some reason, we have two SAS Studio versions - 4.4 and 5.1. I'd like to create a Task in SAS Studio 5.1 , but when I click New menu, I only see these options -- and Task isn't one of them. Do I need special authorization to create a New Task, and if so, what permission do I ask my SAS admin for? As a bonus question, when I run SAS Studio 4.4, I can see the New Task option, and I can create a new task... ... but after saving it as .ctm file, I couldn’t edit the template code again. Instead, it opens as .ctk file in Studio, and I can't figure out how to view/edit template code again. Even after saving it to My Tasks, I don’t have Edit option. Is that another permission issue? Thanks!

bnawrocki · ‎04-12-2022

Thought I'd try my question here, before I pose a new question to SAS Community board. I've been stuck trying to modify a task template I created. I'm using SAS Studio 4.4, and I've saved my own task as .ctm file. But when I open it again, it opens as .ctk file, which is uneditable. I tried the steps you describe above, but I'm stuck at Step 1. I saved the task to My Tasks, but when I right-click it in My Tasks, I don't see Edit. The only options I see are: Open Task, Copy Task to Explorer, Add to My Favorites, Hide, Delete, Properties. Any idea why? Is there a permission or autorization I need to request from our SAS Admin?

bnawrocki · ‎01-24-2022

@FreelanceReinh Thanks for checking into this! Yes, that's what I had to do - I had originally typed Alt-0185 into both strings to get the superscript 1 to display in my Windows SAS reports. But when I copied that SAS code from Windows to Linux and opened the SAS code in SAS Studio there, the 1's had been replaced by a weird "question-mark-in-black-diamond" character. To fix that, in SAS Studio, I typed Alt-0185 over that weird character, and the SAS code now works in Linux SAS. I'll just have to remember to not copy SAS code between Windows and Linux with these special characters. I was hoping either the {SUPER} or {UNICODE} trick would work on both Windows and Linux, but no such luck, at least in this case.

bnawrocki · ‎01-24-2022

This code used to work in Windows SAS 9.4 - that is, I saw a superscript 1 in both title and data. But running this in Linux SAS Viya, it doesn't. The TITLE statement works OK - I see the Superscript 1. But in the "Age" column, if age < 14, I don't see Superscript 1 - I see a Superscript with a generic-looking degree (zero?) sign. How can I conditionally add Superscript 1 to end of Age? Note: I also tried {Unicode '00B9'x} -- but same results. proc format; picture myPic low -< 14 = "000,009.9(*ESC*){super 1}" other = '000,009.9'; run; title "Title containing a superscript(*ESC*){super 1}"; proc print data=sashelp.class; format age myPic.; run; Here is the output from Results window. Note Age in Obs 2 has wrong superscript! Title containing a superscript1 Obs Name Sex Age Height Weight Alfred M 14.0 69.0 112.5 Alice F 13.00 56.5 84.0

Online Status	Offline
Date Last Visited	‎02-24-2025 12:30 PM

Re: Reading SAS Data on my Windows laptop in Microsoft Power BI

Re: Reading SAS Data on my Windows laptop in Microsoft Power BI

Reading SAS Data on my Windows laptop in Microsoft Power BI

Re: SAS Extension for Visual Studio Code

Re: SAS Extension for Visual Studio Code

Re: Is there a way to select all non-empty values from table?

Re: SAS Enterprise Guide won't open

SAS Enterprise Guide won't open

Enterprise Guide Editor - features missing compared to Base SAS 9.4 Ed...

Re: Iterative DO Loop for multiple pages in pdf

Re: Display number of rows in SAS dataset - SAS Enterprise Guide (EG)

Re: How do I suppress Title and Footnote outside a graph in PowerPoint...

Re: Check numeric values in alphanumeric variables

Re: ods pdf contents and sgplot creates overprinting

Re: Date format changing in SQL database from datetime to date. How t...

Re: Iterative DO Loop for multiple pages in pdf

Re: Superscript in picture format

Superscript in picture format

Re: Avoid line breaks when exporting long text to Excel

Re: Display number of rows in SAS dataset - SAS Enterprise Guide (EG)

Re: Reading SAS Data on my Windows laptop in Microsoft Power BI

Re: Reading SAS Data on my Windows laptop in Microsoft Power BI

Reading SAS Data on my Windows laptop in Microsoft Power BI

Re: SAS Extension for Visual Studio Code

Re: SAS Extension for Visual Studio Code

Re: Is there a way to select all non-empty values from table?

Re: SAS Enterprise Guide won't open

SAS Enterprise Guide won't open

Enterprise Guide Editor - features missing compared to Base SAS 9.4 Ed...

Re: Iterative DO Loop for multiple pages in pdf

Re: How to create Task in SAS Studio 5.1

How to create Task in SAS Studio 5.1

Re: SAS Studio Custom Task Tuesday: How to Modify an Existing Task

Re: Superscript in picture format

Superscript in picture format

SAS Inner Circle Panel

SUGA

SAS Analytics Explorers