I’ve posted a new idea for the SASware Ballot about how to avoid locking SAS data sets when browsing them in Enterprise Guide (EG). Anyone who uses EG now will have discovered this at some point! However, I will need your help to get this idea into the real SASware Ballot for users to vote for it, which is why I need my idea to be voted up in the SASware Ballot Ideas Community at “Browsing SAS data sets in Enterprise Guide without locking“.
If you think this is a good idea, then please vote for it and tell your colleagues to vote for it too!
Just click on the blue voting button after logging into SAS Communities.
Many thanks in advance……….Phil
PS. The idea above is not the only SASware Ballot Idea I have submitted:
We all know that SAS develops its software in separate teams, but it can be really annoying when it becomes apparent that several associated teams haven’t planned together how a SAS procedure will work.
I’m going to take as an example PROC IMPORT, which is part of Base SAS, but is also included in SAS/ACCESS. When you run the following program all the variables created begin with VAR, i.e. VAR1, VAR2, VAR3, VAR4, VAR5, etc., and this would also be true for DBMS=TAB and DLM:
However, using similar PROC IMPORT code for DBMS=EXCEL, in SAS/ACCESS for PC Files, will create variables beginning with F, i.e. F1, F2, F3, F4, F5, etc.:
More shocking though is using PROC IMPORT code for DBMS=XLS or XLSX in UNIX or Windows, in SAS/ACCESS for PC Files, as this will create variables with no prefix at all, i.e. A, B, C, D, E, etc.:
This inconsistency even extends to using GETNAMES = YES too when there are multiple columns with the same label.
If you want to import a CSV file, instead of an Excel file, or indeed import an Excel file in UNIX, then the subsequent processing step will have to be updated to use the new variable names (annoying!). Why can’t the procedure be consistent, or, at least, have a parameter, like PREFIX=, that allows users to choose the prefix?
Back in SAS 6 there were monumental problems caused by each SAS procedure having to manage their own output destinations, and each one doing it in a slightly different way, so ODS (Output Delivery System) was introduced in SAS 7 to make the output interface separate from the procedures. SAS now need to develop standards for parameters and defaults, just like they did for output!
To vote for this to be included in the next SASware Ballot just click here and vote up the idea!
Warning: you may need to use a desktop browser to vote up the idea! 🙁
Do you have any examples of similar inconsistencies in SAS?
If you think this is a good idea, then please vote for it and tell your colleagues to vote for it too!
You must be logged in to post a comment.