One way to copy a dataset from let's say path1 to path2 is to use the libname and data statement as below   %let path1= something; %let path2=something else; %let fname=be_auto_prmjun2024; libname source spde "&path1."; libname dest spde "&path2"; data dest.&fname.; set source.&fname; run; if we have many files, we coud use a filelist and a call execute and repeat the above script   What will be the unix command that we could use to copy spde file containing only the string prm (stand for premium) from many subfolders to other subfolders and of course only spde file.   Please provide the good unix command Please p   ... View more

Is there a SAS way to convert xml+xsl file to pdf file? I can open a xml file in Microsoft Edge and save it as a html file, so solution of convert html to pdf is welcomed, too. ... View more

Hi Graph Extperts,   I am trying to plot the below graph using PROC TEMPLATE. So till now I have achived to plot the main body and only one table below the plot. But the problem is that I am unable to fit 2 tables under the plot as I have 6 treatments hence each table is taking 6 lines. Kindly help me. I have used below code .   proc template; define statgraph stepplot; begingraph / designwidth=800px designheight=465px border=false....... .......................      layout lattice / rows=3 columns=1 ......................;             <main plot>; endlayout;       layout overlay / ; <table 1 with all required syntax > AxisTable ..................... / poistion =0 ; endlayout; endgraph;   run;   Thanks in Advance.           ... View more

The issue is obvious in this simple example, but it's pretty easy to miss with something more complicated: data T1; input id A B C; cards; 101 3 7 8 102 5 2 1 ; run; data T2; input id A B C; cards; 103 8 2 5 104 6 1 2 ; run; proc sql; select * from T1; select * from T2; select id, A, B, C from T1 union all select id, B, A, C from T2 order by id; quit; The result: ' The log:     ... View more