cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tsjwolf
‎05-16-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Error/Bug in VA with visualization and crosstab

by Fluorite | Level 6 in SAS Visual Analytics
‎02-28-2017 04:44 AM
‎02-28-2017 04:44 AM
Good day.   I have bug in VA with visualization and crosstab.   This is gameplay.   I use file "INSIGHT_TOY_COMPANY_2012", which is sample file with VA.   I have added data from Customer to "Facility Hierarchy" that I can see which "Customers" are working with Single Facility.   I copy Category "Customer"  to "Customer Geo".   I chose "Category" for "Customer Geo" from  "Geography" -> "Custom", "Latitude" -> "xyCustomer Lat", "Longitude" -> "xyCustomer Lon", " Coordinate Space "->" World Geodetic System (WGS84) "   Then in "Facility Hierarchy" I added CustomerGeo.   In the visualization "Facility Analysis" in "Facility Hierarchy" I have chosen "North America" -> "United States" -> "Montana" -> Billings and I see that there's in Billings various "FacilityEfficiency" Different "bubble size".   Foto in file VA1.png.    With Button „Export Data“ wir get Excel-CSV-Data:   Customer Geo Facility Age Facility Efficiency USBILLIN000190392 11 84.9999999999997300000000000000000% USBILLIN000190391 11 84.9999999999997600000000000000000% USBILLIN000190162 11 84.9999999999998400000000000000000% USBILLIN000186984 11 84.9999999999998600000000000000000% USBILLIN000186983 11 84.9999999999999100000000000000000% USBILLIN000186988 11 84.9999999999999300000000000000000% USBILLIN000186987 11 84.9999999999999700000000000000000% USBILLIN000190161 11 84.9999999999999700000000000000000% USBILLIN000191072 11 84.9999999999999700000000000000000% USBILLIN000186990 11 85.0000000000000000000000000000000% USBILLIN000190159 11 85.0000000000000000000000000000000% USBILLIN000190163 11 85.0000000000000000000000000000000% USBILLIN000191074 11 85.0000000000000100000000000000000% USBILLIN000191070 11 85.0000000000000400000000000000000% USBILLIN000191071 11 85.0000000000000700000000000000000% USBILLIN000191073 11 85.0000000000000700000000000000000%   With „Cross Table“ I get Data:   Foto in file VA2.png.    But I have tested original file of "INSIGHT_TOY_COMPANY_2012" with SAS.   PROC SQL;    CREATE TABLE WORK.QUERY_FOR_INSIGHT_TOY_COMPA_0002 AS    SELECT t1.Customer,             (AVG(t1.FacilityAge)) FORMAT=NLNUMI3. AS AVG_of_FacilityAge,             (AVG(t1.FacilityEfficiency)) FORMAT=PERCENT32.31 AS AVG_of_FacilityEfficiency,             (MIN(t1.FacilityEfficiency)) FORMAT=PERCENT32.31 AS MIN_of_FacilityEfficiency,             (MAX(t1.FacilityEfficiency)) FORMAT=PERCENT32.31 AS MAX_of_FacilityEfficiency,             (COUNT(t1.Customer)) AS COUNT_of_Customer       FROM DPPUBLIC.INSIGHT_TOY_COMPANY_2012 t1       WHERE t1.Customer IN            ( 'USBILLIN000190391', 'USBILLIN000190392', 'USBILLIN000186984', 'USBILLIN000190162', 'USBILLIN000186983', 'USBILLIN000186987', 'USBILLIN000186988', 'USBILLIN000190161', 'USBILLIN000191072', 'USBILLIN000186990', 'USBILLIN000190159', 'USBILLIN000190163', 'USBILLIN000191070', 'USBILLIN000191071', 'USBILLIN000191073', 'USBILLIN000191074'           )       GROUP BY t1.Customer                   ORDER BY t1.Customer ; QUIT;   All these facilities have the same "Facility Efficiency", which is 85%   Customer AVG_of_FacilityAge AVG_of_FacilityEfficiency MIN_of_FacilityEfficiency MAX_of_FacilityEfficiency COUNT_of_Customer USBILLIN000186983 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 534 USBILLIN000186984 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 523 USBILLIN000186987 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 409 USBILLIN000186988 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 488 USBILLIN000186990 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 400 USBILLIN000190159 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 23 USBILLIN000190161 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 16 USBILLIN000190162 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 121 USBILLIN000190163 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 22 USBILLIN000190391 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 442 USBILLIN000190392 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 519 USBILLIN000191070 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 81 USBILLIN000191071 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 58 USBILLIN000191072 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 12 USBILLIN000191073 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 58 USBILLIN000191074 11 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 85,0000000000000000000000000000000% 25   VA3.png and VA4.png is the photos, how to make "CustomerGeo".   I think maybe there's error or problem or bug in the calculation in VA.   I do not know how to find solution.     ... View more

more examples

by Fluorite | Level 6 in SAS Programming
‎02-21-2017 05:01 AM
‎02-21-2017 05:01 AM
data tmp2; format str_inp str_out $50.; str_inp='äöüßÄÖÜ'; *in Unicode; str_out = kpropdata(str_inp,"UESC", "wlatin1", "ASCII") ; put /str_inp= /str_out= /str_inp= $hex10.  /str_out= $hex10. ; *from Unicode; str_inp2 = UPCASE(str_out); str_out2= kpropdata(str_inp2,"UESC", "ASCII", "wlatin1") ; put /str_inp2= /str_out2= /str_inp2= $hex10. /str_out2= $hex10.; str_inp3 = LOWCASE(str_out); str_out3= kpropdata(str_inp3,"UESC", "ASCII", "wlatin1") ; put /str_inp3= /str_out3= /str_inp3= $hex10. /str_out3= $hex10.; str_inp4 = TRANWRD(UPCASE(str_out), '\U', '\u'); str_out4= kpropdata(str_inp3,"UESC", "ASCII", "wlatin1") ; put /str_inp4= /str_out4= /str_inp4= $hex10. /str_out4= $hex10.; run; /*+b*/ data tmp3; format str_inp str_out $50.; str_inp='äböbübßbÄbÖbÜb'; *in Unicode; str_out = kpropdata(str_inp,"UESC", "wlatin1", "ASCII") ; put /str_inp= /str_out= /str_inp= $hex10.  /str_out= $hex10. ; *from Unicode; str_inp2 = UPCASE(str_out); str_out2= kpropdata(str_inp2,"UESC", "ASCII", "wlatin1") ; put /str_inp2= /str_out2= /str_inp2= $hex10. /str_out2= $hex10.; str_inp3 = LOWCASE(str_out); str_out3= kpropdata(str_inp3,"UESC", "ASCII", "wlatin1") ; put /str_inp3= /str_out3= /str_inp3= $hex10. /str_out3= $hex10.; str_inp4 = TRANWRD(UPCASE(str_out), '\U', '\u'); str_out4= kpropdata(str_inp3,"UESC", "ASCII", "wlatin1") ; put /str_inp4= /str_out4= /str_inp4= $hex10. /str_out4= $hex10.; run; /*+tb*/ data tmp4; format str_inp str_out $70.; str_inp='ätbötbütbßtbÄtbÖtbÜtb'; *in Unicode; *broke all; str_out = kpropdata(str_inp,"UESC", "wlatin1", "ASCII") ; put /str_inp= /str_out= /str_inp= $hex10.  /str_out= $hex10. ; run; ... View more

Re: Error in Function "kpropdata"

by Fluorite | Level 6 in SAS Programming
‎02-17-2017 11:44 AM
‎02-17-2017 11:44 AM
Thank you. It is interesting, why code works on my computer wrong... ... View more

Error in Function "kpropdata"

by Fluorite | Level 6 in SAS Programming
‎02-17-2017 10:37 AM
‎02-17-2017 10:37 AM
Guten Tag. Können Sie mir helfen ? Warum in SAS Code unten  wir bekommen „str_out=T\u0fcbingen Tü-bingen Baden-Württemberg“ und nicht „str_out=Tübingen Tü-bingen Baden-Württemberg“ ?     data tmp; str_inp='T\u00FCbingen T\u00FC-bingen Baden-W\u00FCrttemberg'; str_out =  kpropdata(str_inp,"UESC", "ASCII", "wlatin1") ; put /str_inp= /str_out= /str_inp= $hex120. /str_out= $hex120. ; run;     49         data tmp; 50         str_inp='T\u00FCbingen T\u00FC-bingen Baden-W\u00FCrttemberg'; 51         str_out =  kpropdata(str_inp,"UESC", "ASCII", "wlatin1") ; 52         put /str_inp= /str_out= /str_inp= $hex120. /str_out= $hex120. ; 53         run;     str_inp=T\u00FCbingen T\u00FC-bingen Baden-W\u00FCrttemberg str_out=T\u0fcbingen Tü-bingen Baden-Württemberg str_inp=545C753030464362696E67656E20545C75303046432D62696E67656E20426164656E2D575C7530304643727474656D62657267 str_out=545C7530666362696E67656E2054FC2D62696E67656E20426164656E2D57FC727474656D626572672020202020202020202020202020202020202020 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-16-2019 12:43 PM
Group Hubs for tsjwolf
View All
Quick links