About paulkaefer

paulkaefer · ‎02-09-2018

Hi @AaronTram. Great question. Yes, I do cite whatever I reference - some examples you can see in my MWSUG paper. If I use someone else's macro, or write something inspired by what they do, I also include a link to their paper/website in my code. Typically in the comments, and perhaps in the header information.

paulkaefer · ‎02-06-2018

Hmm, this is a tricky one! Maybe @Astounding, who posted the original code snippet, can weigh in?

paulkaefer · ‎02-05-2018

I haven't used the ?? modifiers in the input statement. Here they show examples with space after the ??. You might also just try replacing ??32. with something like best8., just to try it.

paulkaefer · ‎02-05-2018

@tnaveen80150, the format needs a period (.) at the end, so: ??32.

paulkaefer · ‎02-05-2018

I just wanted to loop back on this. As @Tom suggested, I opened a track with SAS tech support. The specialist responded that this has been fixed in the 9.4m5 release.

paulkaefer · ‎02-01-2018

Thanks for the example of htmldecode, @Ksharp. Another option would be to do the following: select tranwrd(A, "&", "&") as A_new I submitted a track with tech support as @Tom suggests, and marked that comment as solution. I agree, the workarounds are not a fix for directly reading such an Excel file, but they can help in a pinch.

paulkaefer · ‎01-31-2018

Thanks, @ballardw. Not an ideal solution, but that could work in a pinch. We know the origin to be Excel. As my example shows, this only appears if you import a sheet where cells pull their value from another sheet. Both examples have the same human-readable value, but something in the import is converting one of the ampersands to &.

paulkaefer · ‎01-31-2018

Thanks for the quick response @utrocketeng. I'm still seeing & in this variable (note that I don't want this to be a variable name but a value). I tried with validvarname=any; and still am seeing & appear.

paulkaefer · ‎01-31-2018

See test code and Excel file, attached. In sheet test1, cell A1 is "S&P 500" (without quotes). Proc import reads this fine. In sheet test2, cell A1 links to another sheet, which has the value "S&P 500" (once again, no quotes in the cell itself). Proc import reads this as "S&P 500". I recognize this as a character encoding for & used in HTML, etc. Is there a way to force SAS to not do this? Some option for import? Let me know if this would be more appropriate to post in the General SAS Programming forum.

paulkaefer · ‎01-17-2018

I believe what you want is to disable autocomplete. Go to Program >> Editor Options >> Autocomplete, and uncheck "Enable Autocomplete" and "Enable integrated syntax help" if they are checked. Let me know if that isn't enough. Autocomplete is super useful if you are used to it (and can handle all the "helpful" popups). It's definitely widely-used in software development, and can [in theory] enable faster code writing. That said, I also find it annoying - I'm happy to make mistakes and use Google the "old-fashioned way" to develop my own skills at coding & debugging 🙂

paulkaefer · ‎01-08-2018

Thanks for the great post, @Reeza! I hadn't know about Computer Science Illuminated, so I'll have to check that out. The Art of Computer Programming is also a fantastic reference by one of the greats of computer science. I'd also like to through in a shout-out to sasCommunity.org. Daily tips are worth at least a quick read, and there are many advantages of a wiki, including links between pages, categories, and the fact that all the content is contributed by the community. While it's in the process of being decommissioned, it seems likely that the site will still be available for perusal for some time (and is preserved in the Internet Archive's Wayback Machine). Plus, sasCommunity.org/planet is an excellent blog aggregator that has helped me find some great things to read.

paulkaefer · ‎12-07-2017

@sweroz: is the KSA something I can get access to as a non-SAS employee? Or is it a specific product that would depend on what my organization has purchased?

paulkaefer · ‎12-07-2017

@sweroz, I'm not able to access that link... I tried switching "sww" to "www". I feel like this may have happened before. Is this an internal SAS link?

paulkaefer · ‎12-06-2017

Thanks, @sweroz. Can you share a link to the plugin/KSA? I can't seem to find one.

paulkaefer · ‎11-30-2017

I'm just seeing this now. I would be interested in listening in/participating in the future... when will the next one be scheduled?

Online Status	Offline
Date Last Visited	‎05-11-2020 01:18 PM

Re: Can SAS filter multiple possible LIKE conditions, without an OR?

Can SAS filter multiple possible LIKE conditions, without an OR?

Re: what's the tips for learning SAS quickly?

Re: A different kind of “3 things” for SAS admins: November 2018

Re: using asterisk in system commands?

using asterisk in system commands?

Re: Sharing in SAS Drive (part 1)

Re: Reading gzip files

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

Re: Do you use best practices for writing and sharing code? Do you wan...

Re: Multiple Cursors

SAS Packages - Live Demo / Workshop - the User point of view

Re: SAS Packages - Live Demo / Workshop - the User point of view

SAS Global Forum 2020 on GitHub!

Re: SAS Global Forum 2020 on GitHub!

add any_value window function to SAS SQL

Re: EG: Remember ‘old’ where clauses

Re: Allow definition and use of a named group of variables

Re: A different kind of “3 things” for SAS admins: November 2018

SAS Enterprise Guide: add word wrap as option for editor & log

Code Like It Matters: Best Practices from Software Engineering, Applie...

Re: Citing a SAS Global Forum Paper

Re: Convert column type from character to numeric in SAS enterprise mi...

Re: Convert column type from character to numeric in SAS enterprise mi...

Re: Convert column type from character to numeric in SAS enterprise mi...

Re: proc import formatting "linked" cell with '&' character

Re: proc import formatting "linked" cell with '&' character

Re: proc import formatting "linked" cell with '&' character

Re: proc import formatting "linked" cell with '&' character

proc import formatting "linked" cell with '&' character

Re: Any Way to Suppress all the Onscreen Help?

Re: Free SAS Learning Resources

Re: Anyone using Git for version control of SAS Data Integration Studi...

Re: Anyone using Git for version control of SAS Data Integration Studi...

Re: Anyone using Git for version control of SAS Data Integration Studi...

Re: Jam starting in just a bit! Today at 10 am ET

SAS Global Forum 2018