Friday
hartwell
Fluorite | Level 6
Member since
08-28-2024
- 12 Posts
- 2 Likes Given
- 1 Solutions
- 1 Likes Received
-
Latest posts by hartwell
Subject Views Posted 218 3 weeks ago 464 02-26-2025 12:41 PM 512 02-26-2025 11:27 AM 834 01-09-2025 10:41 AM 957 01-09-2025 10:15 AM 1426 12-04-2024 04:29 PM 1470 12-04-2024 03:19 PM 1531 12-04-2024 01:59 PM 883 11-19-2024 02:26 PM 1024 11-15-2024 02:45 PM -
Activity Feed for hartwell
- Posted Rescale pictures inserted in PROC REPORT columns on SAS Programming. 3 weeks ago
- Liked Re: Calling a macro inside SAS/CONNECT for Tom. 02-26-2025 12:42 PM
- Posted Re: Calling a macro inside SAS/CONNECT on SAS Programming. 02-26-2025 12:41 PM
- Posted Calling a macro inside SAS/CONNECT on SAS Programming. 02-26-2025 11:27 AM
- Posted Re: Passing local formats to SAS/CONNECT subtasks on SAS Programming. 01-09-2025 10:41 AM
- Liked Re: Passing local formats to SAS/CONNECT subtasks for Tom. 01-09-2025 10:40 AM
- Posted Passing local formats to SAS/CONNECT subtasks on SAS Programming. 01-09-2025 10:15 AM
- Got a Like for Re: sashelp for ods select all ?. 12-04-2024 04:49 PM
- Posted Re: sashelp for ods select all ? on ODS and Base Reporting. 12-04-2024 04:29 PM
- Posted Re: sashelp for ods select all ? on ODS and Base Reporting. 12-04-2024 03:19 PM
- Posted sashelp for ods select all ? on ODS and Base Reporting. 12-04-2024 01:59 PM
- Posted Re: tickdisplaylist with dynamic variable on Graphics Programming. 11-19-2024 02:26 PM
- Posted tickdisplaylist with dynamic variable on Graphics Programming. 11-15-2024 02:45 PM
- Posted Re: Graph Template Language: Get Rid of Tick Marks on Graphics Programming. 11-04-2024 08:43 AM
- Posted Graph Template Language: Get Rid of Tick Marks on Graphics Programming. 10-31-2024 03:15 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 3 -
My Liked Posts
Subject Likes Posted 1 12-04-2024 04:29 PM
3 weeks ago
I am trying to insert pictures within a PROC REPORT. I believe I understand the basic mechanics, but would like the picture to shrink to fit if the cellwidth is not as wide as the picture. Is this something that can be done? proc report data=dsn nowd;
column image;
define image / "TITLE" computed style(column)=[cellwidth=4in];
compute image / char;
call define(_col_,'style',"style=[preimage='/path/SGPlot1.png']");
endcomp;
run; The code above is what I used to produce the PROC REPORT to insert a single image. It cuts off the right-hand side of the image because the image is just a little bit wider than the 4in cellwidth I declared. I would like it to instead shrink the image.
... View more
02-26-2025
12:41 PM
Fantastic! The %do was absolutely the issue. Thank you so much for catching that 😃 It's working beautifully now To your other questions: - The RX1 macro was created outside of the code snippet I included (it gets assigned in the autoexec) - I definitely don't need to send all macro variables--I usually just start that way as I develop/troubleshoot. - I've not had any issue sending macro variables to rsubmit sessions not yet created
... View more
02-26-2025
11:27 AM
I am having trouble calling a macro inside a SAS/CONNECT subsession with input parameters that are macro variables. I have %included the macro inside the subsession and confirm that it is being found when called. The issue comes with my use of macro variables inside the macro call (the &FILEIN and &FILEOUT parameters). I have created these inside the subsession and used put statements to confirm that they are resolving exactly as they should be. However, in the %winratio macro, I get an error that "Apparent symbolic reference to FILEIN not resolved" and the macro attempts to locate the dataset work.FILEIN. Is there a way to get this to work or am I going to have to hard code my macro calls? %macro doover (REMRUN=,tm= ) ;
%syslput _all_ / remote=task&REMRUN;
/* Initialize child session */
rsubmit task&REMRUN wait=no inheritlib = (work=share);
options symbolgen mprint mlogic;
%include "/home/programs/macros/winratio.sas" ;
%local T;
%do T = %scan(&tm,1) %to %scan(&tm,-1) ;
%put ERROR: &T;
%let FILEIN = derived.adttwinratio_tm&T.;
%let FILEOUT = share.unstratified&T.;
%put &FILEIN;
%winratio( idsn=&FILEIN , byvar=timen , tgrp=&RX1 , odsn = &FILEOUT ) ;
%end ;
/* End child session */
endrsubmit;
%mend doover;
... View more
01-09-2025
10:15 AM
I'm just starting to work with SAS/CONNECT to parallelize some of our programming tasks. I've work out how to pass a lot of things from the parent session to the subtasks (e.g. work library, macro variables, etc), but I can't find a way to pass locally-defined formats (meaning formats that are defined inside the parent code and are not stored anywhere). Is there a way to do this or am I going to need to create a format library to store these local formats so they can be accessed?
... View more
12-04-2024
04:29 PM
1 Like
I managed to find a way to get the info I needed from ods show. proc printto log="/dest/test.txt";
run;
ods show;
proc printto;
run;
data _null_;
infile "/dest/test.txt";
input ;
lines=_infile_;
if _n_ = 8 then do;
call symputx('ODS_SHOW',_infile_);
end;
run;
%let ODS_SHOW = %sysfunc(prxchange(s!Current OVERALL select list is: !!,1,&ODS_SHOW));
... View more
12-04-2024
03:19 PM
Here's the table produced by printing sashelp.vdest, which I don't think is enough info for me to restore their defaults after I exclude everything.
... View more
12-04-2024
01:59 PM
I'm working on a macro that has to suppress some of its output using ods rtf exclude all; Under the assumption that the user was outputting to rtf (default user behavior for us), once this piece of the macro is done, it turns output back on using ods rtf select all; However, there are some use cases where the user was suppressing the printout of my macro outputs. In this case, I'd like my code to determine what ods output the user had selected and return to that after the excluded portion of macro code runs. Is there a sashelp/dictionary table that contains this information? I've already looked through vstyle, voption, vallopt, vrememb and didn't see anything specific that told me which state to revert to.
... View more
11-15-2024
02:45 PM
I'm trying to use proc template to create a template with a bunch of dynamic variables. Those variables work fine when I use them in most places, but when I try to use one in tickdisplaylist=(<DYNAMIC VARIABLE HERE>), it errors out and tells me it's expected a quoted string. In my sgrender call, I've tried quoting, not-quoting, embedding all of my quoted labels inside one big set of quotes, etc, but have not had success getting proc template to use my dynamic variable inside this option. Does anyone have any thoughts? define statgraph GRPHNM;
dynamic PLOT1_VISITS PLOT_UNIT PLOT1_YVAL PLOT1_XVAL PLOT2_YVAL PLOT_GROUPS;
begingraph / datacolors = (&CLRSCALE) datacontrastcolors = (&CLRSCALE_CON.);
/*entrytitle "Test plot for &PARMTOPLOT";*/
layout lattice / rows = 1 columns = 2 rowgutter = 0 columngutter = 2 columnweights = (0.66 0.34);
/*** Standard plot ***/
layout overlay / xaxisopts=(linearopts=( viewmin = -2.5 viewmax = 26.5
tickvaluelist=(0 24) tickdisplaylist=("Baseline" "Week 24")
)
display=(LINE TICKVALUES)
)
yaxisopts=(label = PLOT_UNIT labelattrs=(size = 8pt) labelposition = TOP);
scatterplot y=PLOT1_YVAL x= PLOT1_XVAL / group = PLOT_GROUPS jitter = AUTO
groupdisplay = CLUSTER grouporder = &GORDER clusterwidth = 0.75
markerattrs=(size = 4 symbol = CIRCLEFILLED)
datatransparency = 0.3
;
...MORE PLOTS HERE...
endlayout; ....CONTINUED...
... View more
11-04-2024
08:43 AM
perfect! thank you
... View more
10-31-2024
03:15 PM
Is there a way to get rid of tick marks entirely in GTL? As part of my layout, I'm overlaying a scatter and a boxplot for my two different treatment groups. I don't want tickmarks at all, which I can do in proc sgplot with a display=(noticks) option, but I can't seem to find a similar option in GTL. Is there a way to get this done? EXAMPLE CODE layout overlay / xaxisopts=(label=("Change") tickvalueattrs=(size=0 color=white)) yaxisopts=(label=" " labelposition=top);
scatterplot y=CHG x= TRT / group=TRT groupdisplay = cluster clusterwidth=1 markerattrs=(size=5 symbol=circlefilled);
boxplot y=CHG x=TRT / group=TRT grouporder=data groupdisplay=cluster fillattrs=(transparency=0.6) boxwidth = 1;
endlayout;
... View more