12-14-2021
RobP
Quartz | Level 8
Member since
05-24-2012
- 61 Posts
- 67 Likes Given
- 1 Solutions
- 40 Likes Received
-
Latest posts by RobP
Subject Views Posted 1089 08-16-2019 06:44 PM 769 08-02-2019 01:53 PM 1679 05-31-2019 01:47 PM 1691 05-31-2019 12:26 PM 4874 04-09-2019 11:41 AM 4880 04-09-2019 11:24 AM 4972 04-02-2019 12:17 PM 1024 10-30-2018 11:12 AM 1925 10-20-2018 05:00 AM 1753 08-08-2018 09:50 AM -
Activity Feed for RobP
- Got a Like for Re: Download Dataset as csv/xlsx in SAS Studio. 01-30-2023 04:23 PM
- Got a Like for Re: Download Dataset as csv/xlsx in SAS Studio. 01-30-2023 03:59 PM
- Got a Like for Re: Download Dataset as csv/xlsx in SAS Studio. 01-30-2023 03:58 PM
- Liked Re: proc sgmap annotation bug? for GraphGuy. 09-22-2021 10:00 AM
- Liked Re: Add more options to customise how messages are displayed in the LOG. for ChrisNZ. 09-22-2021 09:58 AM
- Liked Re: Add more options to customise how messages are displayed in the LOG. for ChrisNZ. 09-22-2021 09:58 AM
- Posted Add index support when using the 'descending' keyword on SASware Ballot Ideas. 09-22-2021 09:52 AM
- Got a Like for Re: Custom themes for SAS Studio. 09-09-2021 09:49 PM
- Got a Like for Edit non .sas files in SAS Studio editor. 06-18-2021 07:23 AM
- Got a Like for Re: Create new statement STOPROGRAMRIGHTHERE (or similar). 03-24-2021 09:34 AM
- Got a Like for Edit non .sas files in SAS Studio editor. 02-02-2021 02:41 PM
- Got a Like for Edit non .sas files in SAS Studio editor. 01-20-2021 09:18 AM
- Got a Like for SAS Studio 'code' tab focus. 11-14-2020 12:42 PM
- Got a Like for Edit non .sas files in SAS Studio editor. 11-13-2020 03:30 PM
- Got a Like for Re: Create new statement STOPROGRAMRIGHTHERE (or similar). 11-13-2020 12:58 AM
- Posted ip address conversions on SASware Ballot Ideas. 11-11-2020 07:12 PM
- Liked PROC FCMP: Add support for optional parameters (without using arrays) for ChrisNZ. 11-11-2020 06:52 PM
- Liked Create website for SAS or CASL fiddles and pretty formatting of SAS source code. for RichardDeVen. 11-11-2020 06:51 PM
- Got a Like for Edit non .sas files in SAS Studio editor. 11-06-2020 03:48 AM
- Got a Like for SAS Studio 'code' tab focus. 06-10-2020 09:36 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 13 6 -
My Liked Posts
Subject Likes Posted 3 11-28-2018 11:37 AM 1 11-28-2018 11:21 AM 1 11-28-2018 12:09 PM 5 03-04-2020 06:52 PM 1 11-25-2019 02:31 PM
08-16-2019
06:44 PM
I'm trying to place some annotations on a map. I have two sets of annotations, a bubble plot and a text annotation.
If there are more than 500 observations in the annotation dataset, the text plot annotation does not get annotated to the map.
The weird thing is, if I have a bubble plot by itself there doesn't appear to be a limit to how many observations it will annotate, it will happily place down 600 bubble annotations. It's only once I have multiple 'series' being annotated that this shows up.
Code to reproduce (run it twice, once with the obs statement commented, then again with it uncommented):
data annotations_bubble;
do x = -70 to -80 by -.1;
do y = 35 to 39 by 1;
size = 1;
output;
end;
end;
run;
data annotations_text;
x = -75;
y = 37.5;
size = .;
text = 'X';
run;
data annotations_all;
set annotations_text
annotations_bubble(/* obs=499 */) /* <------ UNCOMMENT HERE TO SEE ISSUE */
;
run;
* BUBBLEPLOT;
ods graphics / reset=all imagename="bubble" imagefmt=png width=&img_width height=&img_height border=off;
proc sgmap mapdata=maps.states
plotdata=annotations_all;
;
esrimap url='http://services.arcgisonline.com/arcgis/rest/services/Canvas/World_Light_Gray_Base';
text x=x y=y text=text / textattrs=(size=50pt color=black);
bubble x=x y=y size=size / fillattrs=(color=green);
%runquit;
Does anyone have a workaround for this? I'm currently running 9.4 TS1M5.
... View more
08-02-2019
01:53 PM
I'm trying to make a bubble plot using sgmaps with the group option as seen here: https://blogs.sas.com/content/graphicallyspeaking/2018/11/29/proc-sgmap-series-plot-importing-shapefiles-and-using-proc-gproject/
My code works fine without the group option, but is throwing the following error when I add it:
97 bubble x=x y=y size=areacodes / group=outlier_flag;
_____
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, DATALABEL, DATALABELATTRS, DATALABELPOS, FILL, FILLATTRS,
LEGENDLABEL, NAME, NOFILL, OUTLINE, TRANSPARENCY.
ERROR 76-322: Syntax error, statement will be ignored.
My full code:
data annotations;
set sashelp.zipcode(keep=zip areacodes);
where zip in (89119,00501);
outlier_flag = zip eq 89119;
run;
proc geocode method=zip data=annotations out=annotations_xy lookupcity=sashelp.zipcode nocity attributevar=(state);
run;
proc sql noprint;
select distinct state into :state_list separated by ',' from annotations_xy;
quit;
%put &=state_list;
data map_boundaries;
set maps.states;
where state in (&state_list);
x = -x * 45/atan(1);
y = y * 45/atan(1);
run;
ods graphics / reset=all imagename="map" imagefmt=png width=1024px height=768px border=off;
proc sgmap mapdata=map_boundaries plotdata=annotations_xy;
esrimap url='http://services.arcgisonline.com/arcgis/rest/services/Canvas/World_Light_Gray_Base';
choromap / mapid=state density=2;
bubble x=x y=y size=areacodes / group=outlier_flag;
run;
quit;
Setinit excerpt:
Original site validation data
Current version: 9.04.01M5P091317
Operating System: LIN X64 .
Product expiration dates:
---Base SAS Software
---SAS/STAT
---SAS/GRAPH
---SAS Integration Technologies
---SAS/Secure 168-bit
---SAS Enterprise Guide
---SAS/ACCESS Interface to PC Files
---SAS Workspace Server for Local Access
Is it possible this feature was only just added and doesn't exist in TS1M5? I couldn't find any documentation that clarifies things.
... View more
05-31-2019
01:47 PM
Confirmed that this process does work with self-signed certificates (I just got it working with one).
... View more
05-31-2019
12:26 PM
@alexal Do you know if it's possible to use a self-signed certificate for this process?
... View more
04-09-2019
11:41 AM
@RandyMullis We are using the SAS Office Analytics package. I just tried to see what would happen if I hit the interrupt button but I guess it considered the page to have finished loading as the 'X' was replaced by the 'reload' button.
... View more
04-09-2019
11:24 AM
Hi Randy - yes that is exactly what I'm saying. I can't say I did anything other than use the login page to login, and then during startup it simply gets stuck in the initialization screen.
... View more
04-02-2019
12:17 PM
I am experiencing this issue in Firefox Quantum v66.0.2 (64-bit), with SAS Studio 3.71 (full version details listed below). Studio still works fine in Chrome Version 72.0.3626.119 (Official Build) (64-bit).
I've applied the above hotfix and it did not help.
Looking at the network logs in FF developer mode it appears to be getting stuck on a call to dojo.preventcache (see attached screenshot).
SAS Studio Release: 3.71 (Basic Edition)Build date: Mar 14, 2019 3:04:19 PM SAS Mid-tier release: Mar 14, 2019 2:01:00 PM Java Version: 1.7.0_161 SAS release: 9.04.01M5P09132017 SAS platform: Linux LIN X64 4.14.72-68.55.amzn1.x86_64
... View more
10-30-2018
11:12 AM
My workplace has recently migrated from PC based SAS installations to an Office Analytics environment using EG and SAS Studio. After working with these over the past couple of months we have compiled a list of feedback that we'd like to provide to SAS but I haven't found any 'feedback' specific channels on the site, and I'm unsure of the best channel to use for this. Any thoughts?
... View more
10-20-2018
05:00 AM
I would like to see the results of the autoexec log in SAS Studio. My normal autoexec file in SAS Studio simply looks like this:
%include "/folder/location/my_real_autoexec.sas";
I thought I'd be sneaky and just wrap it in a "proc printto" to redirect the log like this:
proc printto log="~/autoexec.log";
%include "/folder/location/my_real_autoexec.sas";
proc printto;run;
It created the file ~/autoexec.log, but when I open it, it only contains the following:
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
Is there a place I can see the autoexec log somewhere else? A configuration option I can specify somewhere? Or a better way to use proc printto?
EDIT - Just to be clear, I want to see what GLOBAL/AUTOMATIC macro variables are available at the time autoexec runs vs at the time you can submit code manually. So I can't use the 'run' feature that is supplied within SAS Studio.
... View more
08-08-2018
09:50 AM
1 Like
Yes! That was it... thank you so much!
... View more
08-02-2018
02:07 PM
1 Like
I have a simple "Hello World" stored process, and I can successfully call it from my browser and get the results directly by passing in my user/pass credentials as part of the URL request (so the login page never shows).
I'm trying to replicate the above behaviour by passing the same URL to curl, but I keep getting the login screen as a result.
From the browser, the URL looks like:
http://myserver.com:7980/SASStoredProcess/do? _program=my_program&_username=my_user_name&_password=%7BSAS002%7DEFFF...
From curl (running from a Linux64 bash shell), I've tried a multitude of parameters etc, but my latest version is:
curl -v -L -k -d "_program=my_program&_username=my_user_name&_password=%7BSAS002%7DEFFF..."
http://myserver.com:7980/SASStoredProcess/do
As I mentioned, it results in the login screen. I've also tried the /do1 request with the same results.
I believe I have everything configured correctly in SAS Management Console, as the request works fine from the browser URL. Where am I going wrong?
... View more
08-01-2018
02:27 PM
When I originally performed my installation of SAS Office Analytics, there was a step that allowed me to choose between HTTP and HTTPS. As I didn't have a certificate handy at the time I just chose HTTP.
I now have a certificate (self signed if it makes any difference, site is internal use only) and want to reconfigure it. I've tried looking around for some documentation but my google fu is failing me. Is someone able to help me list the steps I should follow to do this?
... View more
07-16-2018
12:33 PM
Turns out the problem was with my code. I had:
proc cport library=source out=dest; run;
... instead of...
proc cport library=source file=dest; run;
Simple mistake to make (difficult to debug) as I previously was trying xport which uses the former convention.
... View more
07-16-2018
11:45 AM
I need to move my files from Windows -> Linux. Same version of SAS (9.4 TS1M5).
When I run proc cport, I am getting the message:
ERROR: The variable name wk_net7_start is illegal for the version 6 file DEST.DATES.DATA. NOTE: Set the VALIDVARNAME=V6 option to enable automatic truncation of long variable names.
How can I prepare the files for transfer without any naming truncation?
... View more