cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sburnos
‎06-17-2019
  • 8 Posts
  • 7 Likes Given
  • 0 Solutions
  • 0 Likes Received

Batch multiple codes Task Scheduler

by Fluorite | Level 6 in SAS Programming
‎06-17-2019 03:27 AM
‎06-17-2019 03:27 AM
Dear SAS community,   I hope you could help me in the following: I have created a batch .cmd file, where I execute multiple SAS codes. This batch perfectly works if I do simply double click on it.  Now I tried to run the batch via the Task Scheduler. And sometimes it works, and sometimes I get an error "sas.exe has stopped working". This error happens only for the second part of the .cmd, meaning that the first part, which includes one SAS code executes just fine, but the second SAS execution crashes. And this is happens from time to time, while testing I observed crashes in 70-80% of executions.   Here is my .cmd file: set file_path=XXX set file_path_log =XXX_log set file_path_lst=XXX_lst   "\\vm19003\c$\program files\SASHome\SASFoundation\9.4\sas.exe" -sysin "%file_path%.sas" -LOG "%file_path_log%" -PRINT "%file_path_lst%" -NOSPLASH -NOLOGO -ICON   TIMEOUT /T 10   ::---------------------------------------------------------------------- set file_path=YYY set file_path_log =YYY_log set file_path_lst=YYY_lst   "\\vm19003\c$\program files\SASHome\SASFoundation\9.4\sas.exe" -sysin "%file_path%" -LOG "%file_path_log%" -PRINT "%file_path_lst%" -NOSPLASH -NOLOGO -ICON exit /b   And here is the Task Scheduler action: cmd.exe/c "Path_to_cmd_file"   Looking forward for your recommendations! Sergey ... View more

Re: Tranwrd a single quotation mark in Macro Var

by Fluorite | Level 6 in SAS Programming
‎04-26-2019 10:48 AM
‎04-26-2019 10:48 AM
Thank you a lot. Have spent a day on searching for a solution. You replied within 10 minutes. For the future will use the help of SAS community more frequently.   Regarding data step, my ultimate goal was to assign the value of macro variable to a label. Therefore I needed that.   ... View more

Tranwrd a single quotation mark in Macro Var

by Fluorite | Level 6 in SAS Programming
‎04-26-2019 10:27 AM
‎04-26-2019 10:27 AM
Dear SAS community,   Struggling with an issue to add a single quote symbol into a macro var by function twanwrd and add it to a label of a variable. The idea, that I want to have a label of a var as "Smith' car". At the moment I have a macro var "SmithZZZ car". This is the code I am using:   %let have=SmithZZZ car;   data temp;    var1="have";    var2="want";    label var1="&have";    %let want=%sysfunc(tranwrd(%bquote(&have),%str(ZZZ),%str(%')));    label var2="&want"; run;   this code does not work,  and I tried many ways to solve the issue, but without success.  Could anyone propose a solution? ... View more

Re: how to put dim(ArrayName) into macro variable

by Fluorite | Level 6 in SAS Programming
‎02-20-2019 10:34 AM
‎02-20-2019 10:34 AM
Thanks for the reply.  Unfortunately, this does not work as I need to count the dimension of the array. If I use the  %sysfunc(countw(&var.)) the result of the length_var =1, but I need it to be 6.  ... View more

how to put dim(ArrayName) into macro variable

by Fluorite | Level 6 in SAS Programming
‎02-20-2019 10:25 AM
‎02-20-2019 10:25 AM
Dear All,   could you please suggest a solution for the following issue, I cannot save the dim(ArrayName) into a macro variable in order to use it later: data test; var_test___1=0; var_test___2=1; var_test___3=1; var_test___4=1; var_test___5=0; var_test___6=0; run;   %macro instrument_inarow(var= ); %local j var_length; data output_data; set test(keep=&var.: ); array list_asc(*) &var.:;   call symputx('var_length',dim(list_asc),'G'); * HERE is the issue, I need to assign to var_length = dim(list_asc)*/   array list_desc(*) %do j=&var_length. %to 1 %by -1; &var.___&j. %end; %str(; ); if 1 then flg=1; /*here comes some conditions*/ else flg=0; run; %mend;   %instrument_inarow(var=var_test);   What would be a solution?   Many thanks in advance! ... View more

Re: Proc Print fail for Obs starting with "<"

by Fluorite | Level 6 in SAS Programming
‎08-16-2017 08:06 AM
‎08-16-2017 08:06 AM
Yes, I run your code, copied and pasted. ... View more

Re: Proc Print fail for Obs starting with "<"

by Fluorite | Level 6 in SAS Programming
‎08-16-2017 07:54 AM
‎08-16-2017 07:54 AM
Thank you KurtBremser,   Very weird, in my case the result is the folllowing: ... View more

Proc Print fail for Obs starting with "<"

by Fluorite | Level 6 in SAS Programming
‎08-16-2017 06:59 AM
‎08-16-2017 06:59 AM
Dear Sas community,   I could not find the solution for the following problem. For the following table, the Proc Print procedure fails to correctly assing the value of the OBs starting with symbol "<" /* First part */ data test; input n1 :$20. n2 :$100. ; datalines; 1 AA 221 <AA> 441 A<A> ;run; /* First part works correctly, but the following Proc Print fails to print Obs "<AA> */   proc print data=test2; var n1 n2; run;   What could be a problem? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-17-2019 11:44 AM
Likes given to
Quick links