proc copy in=in out=out memtype=data; run; could only copy sas datasets from IN libname to OUT libname. ... View more

The most convenient and succinct way is using PROC IML.   data have; input abc def ghi jkl 8.; datalines; 1 4 2 3 6 99 0 8 3 99 6 5 2 4 0 99 ; run; proc iml; use have; read all var _all_ into x[c=vname]; close; idx=loc((x=99)[<>,]); want=vname[idx]; print want; quit;   ... View more

DATA work.test ; LENGTH procesnaam $15.; LENGTH proces_start_date 8.; LENGTH proces_end_date 8.; LENGTH proces_detail $25.; LENGTH subproces $15.; LENGTH sub_start_date 8.; LENGTH sub_end_date 8.; LENGTH start_place $15.; LENGTH end_place $15.; LENGTH comments $50.; INFILE datalines dlm=","; INPUT procesnaam$ proces_start_date :ddmmyy12. proces_end_date :ddmmyy12. proces_detail$ subproces$ sub_start_date :ddmmyy12. sub_end_date :ddmmyy12. start_place$ end_place$ comments$; FORMAT proces_start_date ddmmyy10.; FORMAT proces_end_date ddmmyy10.; FORMAT sub_start_date ddmmyy10.; FORMAT sub_end_date ddmmyy10.; datalines4; walking,01-01-2024,10-04-2024,I walk very slow,part1,01-01-2024,10-01-2024,New york,Amsterdam,I started very well walking,01-01-2024,10-04-2024,I walk very slow,part1,01-01-2024,10-01-2024,New york,Amsterdam,The walk was nice walking,01-01-2024,10-04-2024,I walk very slow,part2,10-01-2024,24-01-2024,Amsterdam,Berlin,Was perfect swimming,10-06-2024,10-07-2024,I love swimming,first swim,10-06-2024,15-06-2024,Leeuwarden,Sneek,Starting was difficult swimming,10-06-2024,10-07-2024,I love swimming,first swim,15-06-2024,30-06-2024,Leeuwarden,Sneek,Injured myself ;;;; RUN; proc sort data=test out=have; by procesnaam--end_place; run; data have2; do until(last.end_place); set have; by procesnaam--end_place; length _comments $ 2000; _comments=catx('~n',_comments,comments); end; drop comments; run; data have3; set have2; by proces_detail; length test $ 32767; if first.proces_detail then do; id=1;test=catx('0909'x,'procesnaam','proces_start_date','proces_end_date','proces_detail')||'~n'||repeat('-',100)||'~n'||catx('090909090909090909090909'x,procesnaam,proces_start_date,proces_end_date,proces_detail); output; end; id=2;test=catx('0909'x,'subproces','sub_start_date','sub_end_date','start_place','end_place')||'~n'||repeat('-',100)||'~n'||catx('09090909090909090909'x,subproces,sub_start_date,sub_end_date,start_place,end_place); output; id=3;test='comments'||'~n'||repeat('-',100)||'~n'||_comments; output; keep id test; run; option nodate nonumber; title; ods escapechar='~'; ods pdf file='c:\temp\temp.pdf' ; proc report data=have3 noheader nowd style={rules=none frame=void outputwidth=100% fontsize=16}; column test id; define test/display; define id/display noprint; compute id; if id=2 then call define('test','style','style={leftmargin=1in}'); if id=3 then call define('test','style','style={leftmargin=2in}'); endcomp; run; ods pdf close;   ... View more

You'd better post a picture to demonstrate your output ,and what kind of file do you like for this report, CSV,RTF,WORD,EXCEL,PDF ? And better post some data by sas code to let us test the code. ... View more

DanH got the right idea here. Another useful option is "clipcap ": highlow y=obsid low=low high=high /lowcap=serif highcap=serif clipcap ; and specify CUTOFF/MAX value in XAXIS : xaxis display=(nolabel) values=(0 to &cutoff. by 1) offsetmin=0 offsetmax=0; ... View more

@GraphGuy maybe knew how to do it with  PROC GCHART. ... View more

data survey; input name $ q1 & $100.; datalines; John Very positive Cathy Very positive Phil Very positive Jason Very positive Darryl Very positive Gary Very positive Courtney Very positive Andrea Very positive Dave Very positive Andy Very positive Will Very positive Zach Very positive Isla Very positive Florence Very positive Henry Very positive Mo Very positive Evie Very Positive Nigel Positive Linda Positive Anna Positive Luke Positive Arlo Positive Archie Positive Wendy Positive Meghan Positive Jack Positive Lucy Positive Theo Positive Dylan Positive Grace Positive Stella Positive Eva Positive Nora Positive Camilla Positive Violet Positive Jude Positive Harry Positive Louis Neither positive nor negative Joe Neither positive nor negative Leo Neither positive nor negative Janet Neither positive nor negative Debbie Neither positive nor negative Alex Neither positive nor negative Daniel Neither positive nor negative Nina Neither positive nor negative Gabe Neither positive nor negative Oliver Neither positive nor negative Anthony Neither positive nor negative Chris Neither positive nor negative Evan Neither positive nor negative Adam Neither positive nor negative Max Neither positive nor negative Sophia Negative Mia Negative Abigail Negative Caroline Negative Shane Negative Chloe Negative Clint Negative Lizzie Negative Sarah Negative Nick Negative Amelia Negative Ava Negative Hazel Negative Ivy Negative Olive Negative Rose Negative George Negative Arthur Negative Ben Negative Finn Negative Elliot Negative Sam Negative Josh Negative Kai Negative Jacob Negative Hugo Negative Mason Negative Mike Negative Liam Negative Vanessa Very negative Fred Prefer not to say ; proc freq data=survey noprint order=freq; table q1/out=freq1 list; run; data freq1; set freq1; datalabel=catx(' ',q1,cats(put(percent,8.2),'%')); run; %macro circular_plot(dataset_in=,id=); data temp; set &dataset_in.; id+1;id=1000*&id.+id; pi=PERCENT*0.01*2*constant('pi'); cum_pi+pi; lag_cum_pi=lag(cum_pi); if _n_=1 then lag_cum_pi=0; run; data plot; set temp; /*for a Polygon*/ do _pi=lag_cum_pi to cum_pi by 0.001; x=&id.*cos(_pi);y=&id.*sin(_pi);output; end; x=&id.*cos(_pi);y=&id.*sin(_pi);output; do _pi=cum_pi to lag_cum_pi by -0.001; x=%sysevalf(&id.+0.5)*cos(_pi);y=%sysevalf(&id.+0.5)*sin(_pi);output; end; x=%sysevalf(&id.+0.5)*cos(_pi);y=%sysevalf(&id.+0.5)*sin(_pi);output; keep x y id ; run; %CENTROID (plot, sgplot, id) data want; merge plot sgplot(rename=(x=centroid_x y=centroid_y)) temp(keep=id datalabel) ; by id; output; call missing(of _all_); run; proc append base=final_want data=want force;run; %mend; proc delete data=final_want;run; %circular_plot(dataset_in=freq1,id=1) ods graphics/ANTIALIASMAX=1000000 ; proc sgplot data=final_want aspect=1 noautolegend noborder; polygon x=x y=y id=id/fill outline lineattrs=(color=white thickness=2) group=id ; scatter x=centroid_x y=centroid_y/markerchar=datalabel markercharattrs=(size=10) labelstrip; xaxis offsetmin=0.1 offsetmax=0.1 display=none ; yaxis offsetmin=0.1 offsetmax=0.1 display=none ; run;   ... View more

@Quentin    1)Yes. You can use MULTILABEL option of proc format to get it,but that is too clumsy.Here is an example. data have ; do date='01Apr2024'd to '30Apr2024'd ; do id=1 to 5 ; pass=ranuni(9)<.3 ; output ; end ; end ; format date date9. ; run ; proc format ; value datef(multilabel notsorted) '24Apr2024'd='24Apr2024' '25Apr2024'd='25Apr2024' '26Apr2024'd='26Apr2024' '27Apr2024'd='27Apr2024' '28Apr2024'd='28Apr2024' '29Apr2024'd='29Apr2024' '30Apr2024'd='30Apr2024' '01Apr2024'd-'30Apr2024'd='01Apr2024 - 30Apr2024' ; run ; proc tabulate data=have; format date datef.; class date/mlf preloadfmt order=data; class pass ; tables date,pass /printmiss; run ;     2) I think the most flexible way is using PROC SQL. If you like it ,I would present it . ... View more

You could use UNICODE sas to import this kind of XPT , after that just convert this dataset from utf-8 encoding into WALTIN1 encoding by this URL: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/p1g1d26os4w0von1cdfh827foo3r.htm ... View more

That would be better to demonstrate your question by posing some data and the picture you want to see.   data have; call streaminit(123); array x{*} opt1-opt6; do id=1 to 100; do i=1 to dim(x); x{i}=rand('bern',i/10); end; output; end; drop i; run; proc transpose data=have out=want; by id; var opt:; run; proc sgplot data=want pctlevel=group; vbar _name_/group=col1 stat=percent ; run;   ... View more

I think you could use ESTIMATE to get RR and its CI ,after that polt it to get the graph you want. http://support.sas.com/kb/24/188.html ... View more

@art297 Arthur.T, Long time no see ! Did you see Perter.E in recently years ? ... View more