02-27-2023
Fugue
Quartz | Level 8
Member since
07-25-2012
- 318 Posts
- 29 Likes Given
- 1 Solutions
- 118 Likes Received
-
Latest posts by Fugue
Subject Views Posted 2931 09-22-2021 05:34 PM 3025 09-21-2021 01:45 PM 3129 09-20-2021 06:14 PM 3174 09-20-2021 05:44 PM 3914 10-05-2018 02:49 PM 3919 10-05-2018 02:30 PM 3986 10-04-2018 05:24 PM 4001 10-04-2018 04:32 PM 1879 08-01-2018 03:28 PM 1880 08-01-2018 03:24 PM -
Activity Feed for Fugue
- Got a Like for Re: US county-level map. 01-09-2025 11:32 AM
- Posted Re: replace every value of a variable with another randomly selected variable on SAS Programming. 09-22-2021 05:34 PM
- Liked Re: replace every value of a variable with another randomly selected variable for Kurt_Bremser. 09-22-2021 05:34 PM
- Liked Re: replace every value of a variable with another randomly selected variable for Reeza. 09-22-2021 05:31 PM
- Liked Re: replace every value of a variable with another randomly selected variable for Kurt_Bremser. 09-22-2021 03:09 AM
- Posted Re: replace every value of a variable with another randomly selected variable on SAS Programming. 09-21-2021 01:45 PM
- Liked Re: replace every value of a variable with another randomly selected variable for Reeza. 09-20-2021 06:45 PM
- Posted Re: replace every value of a variable with another randomly selected variable on SAS Programming. 09-20-2021 06:14 PM
- Liked Re: replace every value of a variable with another randomly selected variable for Reeza. 09-20-2021 05:47 PM
- Posted replace every value of a variable with another randomly selected variable on SAS Programming. 09-20-2021 05:44 PM
- Got a Like for Re: character date to Date9.. 11-13-2019 05:56 AM
- Got a Like for Re: character date to Date9.. 12-18-2018 04:12 PM
- Posted Re: SAS 9.4 fails after uninstalling 9.3 on Administration and Deployment. 10-05-2018 02:49 PM
- Posted Re: SAS 9.4 fails after uninstalling 9.3 on Administration and Deployment. 10-05-2018 02:30 PM
- Got a Like for SAS 9.4 fails after uninstalling 9.3. 10-05-2018 10:45 AM
- Posted Re: SAS 9.4 fails after uninstalling 9.3 on Administration and Deployment. 10-04-2018 05:24 PM
- Posted SAS 9.4 fails after uninstalling 9.3 on Administration and Deployment. 10-04-2018 04:32 PM
- Posted Re: SAS and Office interoperability on Microsoft Integration with SAS. 08-01-2018 03:28 PM
- Posted Re: SAS and Office interoperability on Microsoft Integration with SAS. 08-01-2018 03:24 PM
- Posted SAS and Office interoperability on Microsoft Integration with SAS. 07-20-2018 03:18 PM
-
Posts I Liked
Subject Likes Author Latest Post 3 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 01-17-2014 08:32 PM 1 10-04-2018 04:32 PM 1 01-20-2014 04:04 PM 3 06-17-2014 07:18 PM 3 07-26-2013 06:28 PM
09-22-2021
05:34 PM
Hi Reeza. That example would work. I did not try it out as I was under a time crunch. But, thank you for the link and the info. I appreciate the time you've taken. Thought you should know that the forum keeps marking some reply as the "solution" without me doing anything at all. Not sure why the forum is doing that.
... View more
09-21-2021
01:45 PM
Thanks, Reeza. I will take a look at that link. I did not mark any of your replies. Seems the forum is doing that all on its own! As to your earlier questions: I do not need replicability. Nor do I need consistent name matching. Just need to replace actual names with random names. Random names can be reused "infinitely".
... View more
09-20-2021
06:14 PM
The attached workbooks should give an idea of the structure of the data. Assume these are SAS datasets, of course.
... View more
09-20-2021
05:44 PM
I am an experienced SAS coder but apparently I am very dusty and need some quick help. I've searched online and the community forums without finding a tidy solution. I have a dataset with 1000s of variable values (names) that I need to replace with randomly selected names from a second table. The number of rows in each table is different. For example: dataset CLAIMS has a variable called firstname. dataset FIRSTNAMES contains a variable (unique list) called newname. I want to replace each value of firstname with a random selection from newname. Can anyone provide some pseudocode that would accomplish this relatively easily?
... View more
10-05-2018
02:49 PM
ballardw - I apologize if my response seems terse. SAS 9.4 is already installed on the client machines alongside 9.3. I guess I'm perturbed because, in my experience, SAS has never forced us to switch to a new version while also expiring the previous version. Perhaps my memory is bad. In any case, this has resulted in weeks of work that was not on my workplan - in a year that was already overflowing with work demands, To add insult to injury, the final step (uninstalling SAS 9.3) results in 9.4 failure and then more hours of unplanned work. SAS needs to fix their buggy uninstaller, rather than forcing their customers to deal with it.
... View more
10-05-2018
02:30 PM
DJDaniel - in future, would this procedure solve the problem of an uninstall of a previous version of SAS (e.g. 9.3) when a later version is present (e.g 9.4)?
... View more
10-04-2018
05:24 PM
I appreciate the feedback, but you haven't answered my question. Uninstalling 9.3 first means I have to completely configure 9.4 from scratch.
... View more
10-04-2018
04:32 PM
1 Like
After installing, testing and configuring SAS 9.4, EG 7.1, and AMO 7.1 on various Windows 7 x64 Professional machines - with SAS 9.3 previously installed - uninstalling SAS 9.3 causes SAS 9.4 to fail. The only advice SAS Technical Support has provided on this issue is to follow SAS Usage Note 46922 (http://support.sas.com/kb/46/922.html), particularly step 11, regarding uninstall of 9.3, and then to reinstall 9.4 from the depot. This procedure certainly works, but frankly it is quite time-consuming to effectively run the installer 3 times (install 9.4, uninstall 9.3, reinstall 9.4) to perform one installation;and I find this is especially frustrating after 9.4 was already confirmed to be working. I'm wondering if anyone else has figured out how to successfully uninstall 9.3 after 9.4 is installed without 9.4 subsequently blowing up? One final note: Windows always issues a "Program Compatibility Assistant" warning after attempting to uninstall SAS 9.3. SAS error messages (all or part) are provided for reference below: Error Message:
When starting Base SAS 9.4:
"OLE: Object's class is not registered in the registration database . . ." The Enhanced Editor is missing.
When starting EG 7,.1:
"Warning: Required component is missing. The SAS Object Manager (part of the Integration Technologies client) is not installed or
registered on this machine, or the installed version is older than that supplied with Enterprise Guide . . ."
Once started, EG issues: "No SAS servers available: A local SAS server was not found and no metadata profile is being used . . . "
Attempting to connect to a server in AMO 7.1 results in:
"Connection Failed: A connection could not be established to a metadata server . . . Retrieving the COM class factory for component
with CLSI {868CEBF-4D78-43C-96B4-F5B6C0341151} failed due to the following error: 80040154 Class not registered . . . }
... View more
08-01-2018
03:28 PM
Thanks for the reply, Juan. As for AMO, we are using the latest 9.4 standalone installer and it detects and installs the correct version based on Office bitness. My "problem" is that I don't understand what SAS-Office "interoperability" means with respect to Base SAS/EG. As I replied to Patrick, I am able to import/export to/from SAS/Excel regardless of bit match - without any special code, which seems to contradict Chris' blog posts.
... View more
08-01-2018
03:24 PM
Thanks, Patrick. I'm aware of Chris' blog and have read all of his articles (including the one you linked). The "problem" is that I am able to get results (import/export between SAS and Excel to and from 32-bit and 64-bit) without using special code/methods as Chris describes. Still investigating, so stay tuned!
... View more
07-20-2018
03:18 PM
SAS documentation states that the bitness of SAS and Office should match for "interoperability". However, I've installed SAS x64 (without PC Files Server) alongside Office 32-bit and, so far, I cannot find that this creates any difficulties with SAS-Office interaction. I can import and export spreadsheets, view data in Excel spreadsheets, and generally transfer data back and forth between SAS and Excel. Can someone please clarify for me what exactly does SAS-Office "interoperability" mean?
... View more
09-11-2015
07:16 PM
Here's a sample that I've adapted from SAS support examples online. It uses PROC TABULATE with the PRELOADFMT and PRINTMISS options and OUT= to create a table with all possible combinations of class variables. I'm sure you'll get the idea from this code sample. (In your specific case, the FORMAT you should create would be for fiscal year. Obviously, fiscal year isn't in this example. It's just to illustrate how you can solve the problem of having missing classification levels. There are other approaches that could also be used . . . .) data energy; length State $2; input Region Division state $ Type Expenditures; datalines; 1 1 ME 1 708 1 1 ME 2 379 1 1 NH 1 597 1 1 NH 2 301 1 1 VT 1 353 1 1 VT 2 188 1 1 MA 1 3264 1 1 MA 2 2498 1 1 RI 1 531 1 1 RI 2 358 1 1 CT 1 2024 1 1 CT 2 1405 1 2 NY 1 8786 1 2 NY 2 7825 1 2 NJ 1 4115 1 2 NJ 2 3558 1 2 PA 1 6478 1 2 PA 2 3695 4 3 MT 1 322 4 3 MT 2 232 4 3 ID 1 392 4 3 ID 2 298 4 3 WY 1 194 4 3 WY 2 184 4 3 CO 1 1215 4 3 CO 2 1173 4 3 NM 1 545 4 3 NM 2 578 4 3 AZ 1 1694 4 3 AZ 2 1448 4 3 UT 1 621 4 3 UT 2 438 4 3 NV 1 493 4 3 NV 2 378 4 4 WA 1 1680 4 4 WA 2 1122 4 4 OR 1 1014 4 4 OR 2 756 4 4 CA 1 10643 4 4 CA 2 10114 4 4 AK 1 349 4 4 AK 2 329 4 4 HI 1 273 4 4 HI 2 298 ; ;;;; proc format; value regfmt 1='Northeast' 2='South' 3='Midwest' 4='West'; value divfmt 1='New England' 2='Middle Atlantic' 3='Mountain' 4='Pacific'; value usetype 1='Residential Customers' 2='Business Customers'; run; proc tabulate data=energy format=dollar12. out=outtab; class region division type / preloadfmt; var expenditures; table region*division, type*expenditures / rts=25 printmiss; format region regfmt. division divfmt. type usetype.; title 'Energy Expenditures for Each Region'; title2 '(millions of dollars)'; run; . . . . then proc transpose outtab . . . .
... View more
09-11-2015
03:44 PM
A relatively straightforward solution is to ensure that the final dataset you are transposing has all possible levels of the variable, by merging them in prior to the transpose.
... View more
09-11-2015
03:12 PM
With regard to questions 1 & 2, have you looked at ODS Excel XP options? http://support.sas.com/rnd/base/ods/odsmarkup/TipSheet_ods_xl_xp.pdf
... View more
09-11-2015
02:37 PM
If you have a large number of values for "Area" and "Chart_Field_1", you can use a macro to loop through the possible values and output a corresponding Excel workbook for each value of "Area" containing separate spreadsheets for each value of "Chart_Field_1". To give you some ideas, look at this post: https://communities.sas.com/t5/SAS-Procedures/Split-SAS-Output-into-multiple-Sheets/td-p/18996 If the number of variables is small, you could hard-code them.
... View more