About bendsteel6

bendsteel6 · ‎11-10-2017

Hi, The link provided seems to point me to the MAPSGFK library, and to the WORLD_CITIES table. This works for a lot of my data but I have many cities that don't show up in the WRLD_CITIES table, not sure why: AJAX ON AYR ON DARTMOUTH NS DELTA BC DORVAL QC ETOBICOKE ON HANWELL NB LEVIS QC LIVELY ON MAIDSTONE ON MISSISSAUGA ON PEACERIVER AB SAINT-HYACINTHE QC SAINT-PRIME QC SAINT-REMI QC SOUTHGLENGARRY ON STONEYCREEK ON

bendsteel6 · ‎11-07-2017

Hi, Unfortunately it has company sensitive data in it and changing this data for the graph would take longer than it may be worth. I'll just go with it for now. There have been some good suggestions. Thanks 🙂

bendsteel6 · ‎11-07-2017

Hi, I'm using the MAPSGSFK one. Still didn't see a table that had the Canadian cities. Is there one? Thanks.

bendsteel6 · ‎11-07-2017

Hi, I'm a novice with GMAPs and I'm trying to create a Us/Canada chart with bars (values to be determined by the data) for particular cities in both US and Canada. I'm finding the USCITY_ALL dataset in the MAPSGFK library works well for mapping to US cities. Is there a similar map for Canadian cities? ...Or is there another way to do it for Canada that I'm not aware of? Thanks!

bendsteel6 · ‎11-07-2017

Hi, thanks. That's certainly an idea. (And yes, I did mean x tick mark values :)) My only drawback to that is that this a combination of a bar chart and a series plot. Maybe I can work something out on that. Thanks for the idea!

bendsteel6 · ‎11-07-2017

Thanks for your response. The reason I'm wanting this is because my xaxis labels are quite long, and when they are angled 45 degrees, it makes the whole graph look like it's shifted to the left. Yes, I could mess with the fitpolicy and the fonts size with LABELATTRS but that still doesn't accomplish what I'm looking for. I thought there'd be a way to change the angle, but I guess not. Appreciate it! Thanks

bendsteel6 · ‎11-06-2017

Using SGPLOT, is there a way to change to rotation angle to a specified angle? It appears that the default is 45 degrees. I'm using a VBARPARM and a SERIES line on the chart. I've looked into the documentation and maybe I'm just not seeing something. I should think that should be easy? Thanks!

bendsteel6 · ‎10-27-2017

Ahhhhhhh...yes! Duhhh!!! I should've seen that. Works like a charm, saves me so much code writing. THANK YOU!!!

bendsteel6 · ‎10-27-2017

Hi. Thanks for your input. I'm trying this but I just keep getting the same value in the new field as in the old...Here's the code (with some variable name changes to suit my actual data). I must be doing something wrong... Data: PART_NAME CLAIM_CAT EGR COOLER, REPLACEMENT KIT EXT EGR COOLER, REPLACEMENT KIT STD EGR COOLER, REPLACEMENT KIT PURCH Code: data testdave1; set testdave; retain PART_NAME; by PART_NAME; length concat $30.; if first.PART_NAME then concat=""; concat=catx('/',trim(concat),trim(claim_cat)); if last.PART_NAME then output; run; Results: PART_NAME CLAIM_CAT concat EGR COOLER, REPLACEMENT KIT PURCH PURCH

bendsteel6 · ‎10-27-2017

Hi All, This should be pretty simple but I'm having difficulty figuring it out. I'm trying to combine values from multiple observations into one field. From the first table below to the 2nd. Note that in some instances 'PART1' could have only one record, sometimes 2 and sometimes 3 so the code would have to be written to accommodate this. I've shown it with PART1 having 3 records below. PART_NAME CLAIM_CAT PART1 EXT PART1 STD PART1 PURCH To this: PART_NAME CLAIM_CAT PART1 EXT/STD/PURCH Any help would be appreciated!!! Thanks!

bendsteel6 · ‎09-01-2017

even simpler! Thank you!!!

bendsteel6 · ‎09-01-2017

WOW!!! So simple and works great! Thank you!!!

bendsteel6 · ‎09-01-2017

For the life of me, I can't figure this out! Using PROC TRANSPOSE, I'm trying to get from this (hopefully these tables show up correctly): MAIN_CITY_NM GEO_OPEN_TO_RO_OPEN_HRS_Median RO_OPEN_TO_RO_START_HRS_Median RO_START_TO_RO_FINISH_H_Median RO_FINISH_TO_GEO_END_HR_Median GEO_OPEN_DAYS_Median CONSHOHOCKEN 1.3 2.3 50.8 30.5 5.5 PENNSAUKEN 1.8 6.3 27.3 2.5 1.3 VINELAND 1.7 0.1 128.4 1.5 3.1 TRENTON 2.5 0.3 47.3 14.7 3.1 NEW CASTLE 2 5.5 29.4 3 5 SOUDERTON -2 2.9 2.8 0.3 0.2 to this: MAIN_CITY_NM Analysis_Variable Value CONSHOHOCKEN GEO_OPEN_TO_RO_OPEN_HRS_Median 1.3 CONSHOHOCKEN RO_OPEN_TO_RO_START_HRS_Median 2.3 CONSHOHOCKEN RO_START_TO_RO_FINISH_H_Median 50.8 CONSHOHOCKEN RO_FINISH_TO_GEO_END_HR_Median 30.5 CONSHOHOCKEN GEO_OPEN_DAYS_Median 5.5 PENNSAUKEN GEO_OPEN_TO_RO_OPEN_HRS_Median 1.8 PENNSAUKEN RO_OPEN_TO_RO_START_HRS_Median 6.3 PENNSAUKEN RO_START_TO_RO_FINISH_H_Median 27.3 PENNSAUKEN RO_FINISH_TO_GEO_END_HR_Median 2.5 PENNSAUKEN GEO_OPEN_DAYS_Median 1.3 VINELAND GEO_OPEN_TO_RO_OPEN_HRS_Median 1.7 VINELAND RO_OPEN_TO_RO_START_HRS_Median 0.1 VINELAND RO_START_TO_RO_FINISH_H_Median 128.4 VINELAND RO_FINISH_TO_GEO_END_HR_Median 1.5 VINELAND GEO_OPEN_DAYS_Median 3.1 TRENTON GEO_OPEN_TO_RO_OPEN_HRS_Median 2.5 TRENTON RO_OPEN_TO_RO_START_HRS_Median 0.3 TRENTON RO_START_TO_RO_FINISH_H_Median 47.3 TRENTON RO_FINISH_TO_GEO_END_HR_Median 14.7 TRENTON GEO_OPEN_DAYS_Median 3.1 NEW CASTLE GEO_OPEN_TO_RO_OPEN_HRS_Median 2 NEW CASTLE RO_OPEN_TO_RO_START_HRS_Median 5.5 NEW CASTLE RO_START_TO_RO_FINISH_H_Median 29.4 NEW CASTLE RO_FINISH_TO_GEO_END_HR_Median 3 NEW CASTLE GEO_OPEN_DAYS_Median 5 SOUDERTON GEO_OPEN_TO_RO_OPEN_HRS_Median -2 SOUDERTON RO_OPEN_TO_RO_START_HRS_Median 2.9 SOUDERTON RO_START_TO_RO_FINISH_H_Median 2.8 SOUDERTON RO_FINISH_TO_GEO_END_HR_Median 0.3 SOUDERTON GEO_OPEN_DAYS_Median 0.2 For some reason, I just can't figure it out. Is there anyone out there who's REALLY GOOD with PROC TRANSPOSE who could have a stab at this? THANKS!!!

bendsteel6 · ‎08-17-2016

Glad to know that it's not only happening to me (no offense :)). Since it's relatively intermittent, I'll have to deal with it for now but maybe note certain 'situational circumstances' when it starts to happen again.

bendsteel6 · ‎08-17-2016

Ok, thanks. Guess I'm going to have to get with the CITRIX helpdesk when it happens again. I don't have acces to modify any settings on my CITRIX page either. 😞

Online Status	Offline
Date Last Visited	‎04-11-2023 07:36 PM

Need Code to Export EG Project To An External File

Re: Concatenation Subsequent Column Values (Lag function?)

Re: Concatenation Subsequent Column Values (Lag function?)

Concatenation Subsequent Column Values (Lag function?)

Re: Dynamically Concatenate Columns

Re: Dynamically Concatenate Columns

Dynamically Concatenate Columns

Re: PROC TRANSPOSE Multiple Columns

Re: PROC TRANSPOSE Multiple Columns

PROC TRANSPOSE Multiple Columns

Re: Concatenation Subsequent Column Values (Lag function?)

Re: PROC TRANSPOSE Multiple Columns

Re: PRXCHANGE Simple Pattern Change

Re: PROC SGPLOT Series - Gridlines For Minor Ticks

Re: What am I doing Wrong

Create Macro Variable using Query Builder (computed column)

Re: GMAPs With Canada City Information

Re: SGPLOT - Change Angle of Rotation for XAXIS Values

Re: GMAPs With Canada City Information

GMAPs With Canada City Information

Re: SGPLOT - Change Angle of Rotation for XAXIS Values

Re: SGPLOT - Change Angle of Rotation for XAXIS Values

SGPLOT - Change Angle of Rotation for XAXIS Values

Re: Combine Multiple Rows' Values into One Field

Re: Combine Multiple Rows' Values into One Field

Combine Multiple Rows' Values into One Field

Re: Trouble with PROC TRANSPOSE

Re: Trouble with PROC TRANSPOSE

Trouble with PROC TRANSPOSE

Re: Cannot Copy and Paste To or From Enterprise Guide

Re: Cannot Copy and Paste To or From Enterprise Guide