Hey KSharp,   when I'm running this query its checking for all variables for duplicity.   I need to check based on only 3 Variables.   Is there any other way around.    Thanks ... View more

This was happening to me (In random places where I was not working with any files except for datasets) and I think it was only occurring when I was trying to view/move around the log file within in Enterprise Guide. The output etc was fine - so at the moment I assume it was because I was moving around the log file or maybe even lst/result file e.g. if I reran but just left it running it would finish w/o the warning. ... View more

This technique tends to work quite well.   data final; set d:; run;   data output.combined; set output.final_:; run; ... View more

Hi,   If you dont mind please can you share the JCL and SAS ODS code you used, to export or generate to PDF. I am trying to use ODS and generate a PDF and excel file (tagsets.excelxp), but htere is no luck. If you can share that will be of great help.   Thank you ... View more

I am not an expert but maybe you should have PROC SORT command for both data which you want to merge.   ... View more

This "NOMSG" solved my problem, i was having erros on trying to lock the table while the table was still locked.   Here it's the full code:   /* Options to help debug the macro */ options mprint mlogic symbolgen; %macro trylock(member=, timeout=); %local starttime; %let starttime = %sysfunc(datetime()); %do %until (&syslckrc = 0 or %sysevalf(%sysfunc(datetime()) > (&starttime + &timeout))); %put trying to open ...; %put trying lock ...; lock &member NOMSG; %if &syslckrc ne 0 %then %let rc=%sysfunc(sleep(15)); %put syslckrc=&syslckrc; %end; %mend trylock; %trylock(member=&TABLE, timeout=&TIME_TO_CHECK); ... View more

Hi: You posted your question in the middle of a 7 year old posting. It would be better to do the following: 1) start a new post and refer to this post in your question by copying the URL for this post and 2) post your question in the forum reserved for Stored Processes. Are you running a stored process or a stored RDBMS procedure? SAS has stored processes. Are you using the SAS Add-in for Microsoft Office -- using a stored process in that client application would give you great flexibility for the SP results to come back to Excel, but then under the user's control for whether they want to save or not. Also, I would recommend working with Tech Support -- ALL of your stored process code, or at least 1 representative example has to be available for viewing. Just saying you have 10 stored processes isn't enough. You say you are using a "client portal" but is it the SAS Information Delivery Portal? You indicated that you wanted the output automatically directed to excel: there are 2 ways to do this: 1) use the Excel client in the SAS Add-in for Microsoft Office or 2) use the Stored Process Web App with the appropriate code to make an Excel file and the appropriate content-type headers to be executed on the server but have the results sent to Excel. cynthia here's the location of the Stored Process Forum: https://communities.sas.com/t5/SAS-Stored-Processes/bd-p/sas_stored_processes ... View more

Thanks I can extract the list from the vim script. Personally I am not looking for highlighting. ... View more

Thank you. ... View more

Hi,   Can you please share, how did you solved it, as i m looking for same thing.   Thanks, Sunil ... View more

Data task; Input ID ONum notes & $ 30.; cards; 11 10001 This is a Test 11 10001 of SAS 11 10002 Today the weather was good 11 10002 Busy Shopping 44 19999 Fishing 55 77777 Working on car 55 77777 Hunting 55 77777 Swimming ; run; Data task_final; retain id onum ; length new $ 50; do until (last.onum); set task; by onum; new=catx(" ",new,notes); end; Keep ID ONum new; run; ... View more

LIBNAME mylib CLEAR;  This statement only deassign  In Log you can see NOTE: Libref mylib has been deassigned.  ... View more