
11-26-2024
art297
Opal | Level 21
Member since
06-23-2011
- 8,552 Posts
- 118 Likes Given
- 476 Solutions
- 3,808 Likes Received
About
While trained as an Educational Psychologist, Dr. Tabachneck has spent his entire career designing and overseeing the development of unique database and analytical applications. These have included computing systems for managing state-wide academic programs, major industry outplacement, employee training and tuition assistance efforts, and setting national automobile insurance rates.
Arthur holds a Ph.D from Michigan State University, a master’s degree from Marshall University, and a bachelor’s degree from Bethany College. He has been a SAS user since 1974, was the 2009 SAS Customer Value Award winner and, in 2011, was inducted into the SAS-L Hall of Fame.
Psychology, Statistics, Education, automobile insurance rate setting, database development and management, and web site development
-
Latest posts by art297
Subject Views Posted 254 11-26-2024 01:24 PM 1320 04-30-2024 10:24 AM 2413 04-29-2024 08:20 AM 1381 04-29-2024 07:57 AM 2409 10-08-2020 11:49 AM 2432 10-08-2020 11:14 AM 1823 10-05-2020 07:25 PM 743 10-02-2020 03:33 PM 1493 09-25-2020 01:21 PM 1516 09-25-2020 12:35 PM -
Activity Feed for art297
- Got a Like for Re: PROC SQL QUESTION. How to add a row number to a table observation created using SQL.. 12-12-2024 06:58 AM
- Posted Re: Dummy SAS project for learning. on SAS Programming. 11-26-2024 01:24 PM
- Got a Like for Re: Tip: How to compute percentiles (quantiles). 06-14-2024 03:06 AM
- Got a Like for Re: capitalize first letter of first word. 06-07-2024 01:27 PM
- Got a Like for Combine multiple observations with missing values into one. 05-30-2024 08:23 AM
- Got a Like for Creating Macro variables based on min max of id field. 05-02-2024 12:39 PM
- Got a Like for Re: How to "Split Data" (By Group Processing). 04-30-2024 10:22 PM
- Posted Re: How to "Split Data" (By Group Processing) on Statistical Procedures. 04-30-2024 10:24 AM
- Posted Re: How to "Split Data" (By Group Processing) on Statistical Procedures. 04-29-2024 08:20 AM
- Posted Re: How to "Split Data" (By Group Processing) on Statistical Procedures. 04-29-2024 07:57 AM
- Got a Like for Re: How to "Split Data" (By Group Processing). 04-29-2024 02:19 AM
- Got a Like for Re: Keep only certain rows in a variable. 04-03-2024 02:10 AM
- Got a Like for Re: How to convert character format yyyymmdd to a date format ?. 03-05-2024 04:25 PM
- Got a Like for Re: Challenge for SAS Nerds: Build a SAS Valentine. 02-14-2024 11:09 AM
- Got a Like for Re: Exclude columns using proc SQL. 02-13-2024 03:34 AM
- Got a Like for Re: Exclude columns using proc SQL. 02-13-2024 03:33 AM
- Got a Like for Re: Number of Decimal Places. 02-07-2024 12:53 AM
- Got a Like for Re: Who has a good basic macro program structure (specifically for data checking/cleaning). 02-06-2024 09:40 AM
- Got a Like for Re: Adding Months to a Date. 12-19-2023 06:21 AM
- Got a Like for Re: Import only specified columns from excel sheet. 11-08-2023 07:39 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 5 1 1 -
My Liked Posts
Subject Likes Posted 1 01-27-2017 02:29 PM 1 01-23-2012 05:10 PM 1 08-04-2011 10:40 AM 2 04-30-2024 10:24 AM 1 03-14-2017 02:50 PM -
My Library Contributions
Subject Likes Author Latest Post 5 5 0 0 0
11-26-2024
01:24 PM
I noticed that the link to the presentation was broken. Thanks to Chris Hemedinger I was able to find the original pdf on the Wayback Machine. Here is the link it provided: Link to my MWSUG 2013 expert panel solution presentation
... View more
04-30-2024
10:24 AM
2 Likes
KSharp, Long time no see or hear. I also have not seen or been in contact with Peter for some years now. If you want, you could always try to reach him via his LinkedIn page, namely:https://www.linkedin.com/in/petereberhardt/?originalSubdomain=ca
... View more
04-29-2024
08:20 AM
Paul, Nice to hear from you but, while my name is attached to it, I don't think I wrote the post to which you were replying. I never got into incorporating hash into my code like you, Don, Richard and Kilovolt did. However, as I mentioned in response to another post in this thread, I haven't used SAS in years and am simply enjoying retirement. On a different note, I think that Montreal was the first global forum I ever attended. You bring back a bunch of memories.
... View more
04-29-2024
07:57 AM
Sorry, I haven't used SAS in years and I no longer own the domain (or company) AnalystFinder.com. In fact, I don't even recall participating in the post that you're asking about. It looks like someone else used my logon to participate. However, at my age, memory is no longer as good as it used to be, so I may have participated and simply forgotten.
... View more
10-08-2020
11:49 AM
I don't think the macro will work with Enterprise Guide. If you have access to a copy of SAS, on either a Windows-based machine or Windows-based server, the macro would do what you want. It's intended to submit code, like your proc export code, but that uses vb script to (1) copy and paste your data to a range that you specify (i.e., not a predefined range); (2) not alter existing formats; and/or (3) use an existing workbook or template as a template to paste data into a range.
Yes, it can be run as a totally hands-off approach.
... View more
10-08-2020
11:14 AM
If you're on Windows then the following macro might be what you need:
https://github.com/FriedEgg/Papers/tree/master/Excelling_to_Another_Level_with_SAS/doc
HTH,
Art
... View more
10-05-2020
07:25 PM
If you're going to do what you asked, take a look at the hash method as shown in the following presentation: https://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/Tabachneck-SASTips-2011.pdf
HTH,
Art
... View more
10-02-2020
03:33 PM
2 Likes
@MiraKr_ ,
You could do this using proc transpose, but I find the transpose macro makes it easier when you are transposing more than one variable.
The following code will accomplish what you want:
data need;
set have;
if variable='INTERCEPT' then order=1;
else if variable eq 'PRIOR_CSA' then order=2;
else if variable eq 'MALE' then order=3;
else if variable eq 'EASI0141' then order=4;
else if variable eq 'AAGE' then order=5;
else if variable eq 'EASI0142' then order=6;
run;
proc sort data=need;
by order step;
run;
filename tr url 'https://raw.githubusercontent.com/art297/transpose/master/transpose.sas';
%include tr ;
%transpose(data=need, out=want, by=variable, id=step,
delimiter=_, var=Estimate Odd_Ratio)
HTH,
Art
... View more
09-25-2020
01:21 PM
I was apparently wrong about that dbms=xlsx can use a range option. I was also wrong about the semi-colon, as I was actually thinking exclamation point, but that wouldn't have helped. Other than getting the macro to work, or DDE or writing your own vb code, I can only think that you might be able to use ODS and proc report. However, I can't be of much/any help there.
... View more
09-25-2020
12:35 PM
Try with the same code, but
1) remove the sheet option and
2) add a semicolon, after the sheet name, in the range option
... View more
09-25-2020
11:40 AM
You can use range= with proc export if you use dbms=xlsx. However, as I recall, that will allow you to write to a range but not an existing range. I.e., you can't modify an existing worksheet that way.
I did notice a possible difference between your running proc export and running the macro. With proc export you enclosed the outfile with double quotes. You don't appear to have done that with the macro. Definitely worth a try .. i.e., enclosing the name supplied to the outfile parameter with double quotes.
You could always try a dde approach but that, of course, comes with all of the problems that has caused everyone to stop using dde.
... View more
09-25-2020
08:17 AM
A first step would be to find out where you can actually create a file. Can you use proc export to create an Excel file of sashelp.class? If so, what specifically did you use as the path and name of the file?
... View more
09-24-2020
01:54 PM
I suggest you check with your IT department. They can configure your environment so that the server will recognize c: (or some other drive) that exists on your computer and which you can write to.
Once that is done, you should be able to use the macro.
... View more
09-24-2020
01:17 PM
In your call to the macro you are setting the outfile to be:
c:\temp\class.xlsx
Does your server know what c:\temp is? I don't think so because it is trying to write to:
"',"\\laxxxx.com\LMPAPROD\USINE_PRIIPS\5. RETRAITEMENTS MANUELS\Chaine
Profils\4. Analyse\Marie_TEST\class1.xlsx",'"
As an outfile the macro needs to be supplied with a file that it can create.
... View more
09-24-2020
09:49 AM
In order to know what is happening, I'd need to know what is written to your log. Do you know why you're not getting anything written to your log?
Out of curiosity, what version of SAS are you running?
... View more