Thank you ... View more

Post some data and output would be better to explain your question. data have; infile datalines truncover; input account_no $40.; datalines; 123045600 123945699 000000000000000 0000 00000000000000000000000 99999999999999 99999999 99999999999999999 0999090 ; run; data want; set have; if prxmatch('/^(0+|9{2,})/',account_no) then delete; run; ... View more

Hi: Without your data or a sample of your data, it is hard to understand what you mean when you say that you get an error when you submit on a UNIX command line. Since I don't have Unix to test with, I wouldn't be able to test your code in Unix anyway, but if you posted data with your code, someone might be able to help you. Looking at your code, I don't see where you create work.instructions and I don't understand why you keep using OUT= with PROC REPORT. So clearly there is something in your process that I am not understanding clearly. In this case, I think you need to open a track with Tech Support so they can look at your data, look at all your code and try to replicate your issue on a Unix system. cynthia ... View more

Add instructions as text to a dataset. Proc Print/Report the dataset to ODS.    ... View more

Hi Elliott   If you are accessing your stored process from within a web page through excel, then may be you  can try doing this:   http://bi-notes.com/2012/12/sas-stored-process-debugging-from-the-url/   ... View more

You really should  post it at ODS Graphic.     proc freq data=sashelp.class noprint; table sex*age/list out=have; run; proc sql; create table temp as select age as new_age,count(*)/(select count(*) from sashelp.class) as per format=percent7.2 from sashelp.class group by age; quit; data have; merge have temp; run; proc sgplot data=have; vbarparm category=age response=count/ group=sex groupdisplay=cluster name='a'; series x=new_age y=per/ lineattrs=graphdata3(thickness=8) markers transparency=0.4 y2axis name='b' markerattrs=graphdata3(symbol=circlefilled size=18) filledoutlinedmarkers markerfillattrs=(color=white) markeroutlineattrs=graphdata3(thickness=4) ; y2axis labelattrs=graphdata3 valueattrs=graphdata3; keylegend 'a' 'b' / title=' '; run; ... View more

Hi, This does not seem to be working for me.  The bar chart I created using a task that I provided a screen shot of I used the interleave vertical bar chart to get both bars values.  I tried to use your example and combine the code for the line plot and vertical bar chart but it is not working.  getting this to work would really eliminate a day's worth of work manually created charts for a presentation.  What else can I provide to get assistance with created the chart like I provided in the document I attached in my original post.   Thanks, ... View more

Hi: TAGSETS.TABLEEDITOR works by using JavaScript to take the originally produced HTML table and then produce an Excel workbook/sheets. So, I am not sure whether you can do what you want, directly with the destination. This may be a question for Tech Support. cynthia ... View more