Home

Abdus-Salaam

Dear SAS community, i want to unbold the title of a SGPANEL graphic but i haven't found a working solution for it. here is my code: data Gesamt_Pflanzen_TM_NStufe_MT1; ... /* Presettings */ ods html5 style=analysis path="D:\Masterthesis\Statistik\2024\Grafiken" file="Gesamt-Pflanzen-TM_25-4-24_NStufe.html"; ods graphics / reset; ods graphics / width=3.5in height=3.0in; ods escapechar='^'; * ods text="^S={font_face='Arial' font_weight=normal font_size=11pt color=black}Mischungsverhältnis Erbse : Gerste (%)"; /* hasn't worked */ title height=11pt "Mischungsverhältnis Erbse : Gerste (%)"; /* Data preparation */ data Gesamt_Pflanzen_TM_NStufe_MT1; set Gesamt_Pflanzen_TM_NStufe_MT1; Low = Mittelwert - Standardfehler; /* Untere Grenze Fehlerbalken*/ High = Mittelwert + Standardfehler; /* Obere Grenze Fehlerbalken */ LabelPos = High + 10.0; /* Position der Buchstaben */ run; proc format; value NStufeFmt 0 = "0 kg N ha(*ESC*){unicode '207B'x}^{unicode '00B9'x}" 1 = "96 kg N ha(*ESC*){unicode '207B'x}^{unicode '00B9'x}"; run; proc format; value BehandlungFmt 1 = "0:100" 2 = "100:0" 3 = "90:10" 4 = "70:30" 5 = "80:40" 6 = "80:30" 7 = "50:50" 8 = "Brache"; run; /* Creating bar chart*/ proc sgpanel data=Gesamt_Pflanzen_TM_NStufe_MT1 noautolegend/* Legende wird nicht automatisch erstellt */; format Behandlung Behandlungfmt.; panelby Behandlung / noheaderborder headerattrs=(size=11pt weight=normal) columns=5 rows=1 novarname; format Duengerstufe NStufefmt.; vbarparm category=Duengerstufe response=Mittelwert / group=Duengerstufe groupdisplay=cluster; highlow x=Duengerstufe low=Low high=High / group=Duengerstufe lineattrs=(color=black thickness=1 pattern=solid) /* Schwarze, durchgezogene Linie */ highcap=serif lowcap=serif; /* vertikale Striche an den Enden */ scatter x=Duengerstufe y=LabelPos / datalabel=Buchstabe /* Buchstaben für Fehlerbalken */ datalabelattrs=(size=10pt weight=bold color=black) datalabelpos=center /* Zentrierung der Buchstaben auf Fehlerbalken */ markerattrs=(size=0); /* Unsichtbarer Marker */ rowaxis label="Pflanzen-TM (kg ha^{unicode '207B'x}^{unicode '00B9'x})" labelattrs=(size=11pt); colaxis label="Düngerstufe" labelattrs=(size=11pt weight=normal) valueattrs=(size=10pt)/* Schriftgröße der Achsenwerte */; run; ods html5 close; Can someone of you help me with this problem?

Mahis

Hi everyone, Is it possible in SAS Viya to export a report with multiple tabs as an Excel file with multiple sheets?

Mahis · ‎11-29-2024

Hi everyone, Is it possible to load a file containing a list of IDs into a SAS VA report as a parameter, enabling the report to display only the records related to these IDs? Thanks

tc

A SAS ODS Graphics text/scatter plot take on a couple of neat word search-themed architect and designer Xmas cards at dezeen. Happy Holidays, all! * Fun With SAS ODS Graphics - O [Text & Scatter Plot] Xmas Tree A take on a couple of holiday cards at dezeen.com/2022/12/23/christmas-cards-architects-designers-2022/; data letters(keep=r c letter randnum); * Generate random A-Z letters to fill a 13x13 grid; retain a2z 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' letter ' '; do r=1 to 13; do c=1 to 13; randnum=1+floor(rand("Uniform", 26)); letter=substr(a2z,randnum,1); output; end; end; data message(keep=x0 y0 xM yM textM); * Generate x/y points and letters for a "Happy Holidays!" message; retain textM ' '; msg=" HAPPYHOLIDAYS!"; * Holiday message, x/y offset points for where to display letters (leave space at top for star!); msgXY="0,0 -1,-2 1,-2 -2,-4 0,-4 2,-4 -3,-6 -1,-6 1,-6 3,-6 -4,-8 -2,-8 0,-8 2,-8 4,-8"; x0=7; y0=11; * x/y origin of top of "Xmas tree"; do i=1 to length(msg); * Calc x/y locations of message letters; textM=substr(msg,i,1); * Message letter; xM=x0+scan(scan(msgXY,i,' '),1,', '); * x location of message letter (origin+offset); yM=y0+scan(scan(msgXY,i,' '),2,', '); * y location of message letter (origin+offset); output; end; proc sql; * Insert our message into the grid, set color to white for message letters, black for others; create table lettersmessage as select l.r, l.c, case when m.xM is null then 0 else 1 end as color, case when m.xM is not null then m.textM else l.letter end as letter, m.xM, m.yM, m.x0, m.y0 from letters l left join message m on l.r=m.yM and l.c=m.xM; * Display the tree!; ods graphics / reset=all width=6.5in height=6.5in imagefmt=svg noborder; proc sgplot data=lettersmessage noborder nowall noautolegend pad=0 aspect=1; styleattrs backcolor=cx008975; * Nice shade of green from card (hex RGB code obtained using Paintbrush eyedropper); text x=c y=r text=letter / colorresponse=color textattrs=(size=16pt weight=bold) colormodel=(black white); * Display black & white letters; scatter x=x0 y=y0 / markerattrs=(size=11pt color=white symbol=starfilled); * Put a star on top; scatter x=xM y=yM / markerattrs=(symbol=circle size=26pt color=white); * Draw white circles around message letters and star; xaxis display=none values=(0 to 14); yaxis display=none values=(0 to 14); * Suppress axes and set width/height bounds; run;

SASdevAnneMarie

Bonjour les experts, Savez-vous, s’il vous plaît, comment marquer les espaces à l’intérieur de la fonction prxmatch : Je souhaite avoir les données avec T6 et T 6 : if (prxmatch("/T6/",lb_c)>0 and (prxmatch("/T 6/",lb_c)>0 Merci !