About bnawrocki

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

bnawrocki · ‎10-26-2021

I've been writing code in Base SAS like this for years, and seemed to do what I wanted - to send the results of the 2nd PROC PRINT to a PDF, and send results for the 1st and 3rd PROC PRINTs to the Results screen within SAS (not to an external HTML file): proc print data=sashelp.cars(obs=1); run; ods html close; ods pdf file='c:\temp\temp.pdf'; proc print data=sashelp.cars(obs=2); run; ods pdf close; ods html; proc print data=sashelp.cars(obs=3); run; But when I test this within SAS EG, the "ods html close" statement seems to have no effect - the 2nd PROC PRINT is also written to the Results screen within SAS EG. So, my solution will be to remove the "ods html close" statement, which means I don't need an "ods html" statement, so the error in SAS EG for the "ods html" statement will be averted.

bnawrocki · ‎10-12-2021

I don't have a SAS server -- everything's on my PC. I don't think I should have to change my SAS code and specify a directory for the HTML output to go. So this SAS statement works differently in Base 9.4 SAS and SAS EG? I've been running this code in Base SAS without any issues for years: ods html; I only write that line after I've closed the ods html output with this statement, along with opening up, say, an ODS output to a PDF, and then later want to reset output to html -- ods html close; ods pdf file=.....; I suppose one option is to NEVER close HTML output. Is there another option? If SAS EG is requiring the ODS HTML statement to specify the work library directory, is there a macro or system option or function I could point to rather than writing the entire path each time like the following. This won't work if multiple people run this SAS EG code because it has my name in the path: ods html "C:\Users\BruceNawrocki\AppData\Local\Temp\SAS Temporary Files....";

bnawrocki · ‎10-12-2021

I should have made it clear - Base SAS and SAS EG are both running standalone on my local PC. We don't have a SAS server, so although I'd like to blame my SAS admin, that person doesn't exist.

Online Status	Offline
Date Last Visited	‎11-17-2023 05:09 PM

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: 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: 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

Re: Insufficient Authorization to Access

Re: Insufficient Authorization to Access

Re: Insufficient Authorization to Access

SUGA

SAS Analytics Explorers