Yes. You are correct ! ... View more

Alternatively, you can use the built-in Project Log feature w/o the need for adding any coding. The Project Log feature can keep a running log for each project including the logs created for your code as well as the logs created by EG tasks. Tools > Options > Project and Process Flows > then select "Enable project log for new projects" > OK to close/save. This will add a "Project Log" tab from which you can choose Share > Export (or Export as a Step) based on when you want to write the Project Log to disk. Regards, Bill   ... View more

Yes.  SAS will set the error code when it exits, which you can then test.  In this example the error code was set to 5: 1? options errorabend; 2? data x.y.z; run; 2 data x.y.z; run; ----- 211 ERROR 211-185: Invalid data set name. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ERROR: SAS ended due to errors. You specified: OPTIONS ERRORABEND;. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 17.24 seconds cpu time 0.04 seconds >echo $? 5 Or you can use the ABORT statement with the RETURN option and return an error number you want. Example: >sas -noautoexec -nodms ... NOTE: SAS initialization used: real time 0.06 seconds cpu time 0.03 seconds 1? data _null_; abort return 27; run; ERROR: Execution terminated by an ABORT statement at line 1 column 14, it specified the RETURN option. _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 13.24 seconds cpu time 0.03 seconds >echo $? 27 Now you just need to ask the makers of that other software how to detect the return code of a program you used it to run. ... View more

You rarely need (or want) to use PROC IMPORT to read a delimited text file.  And for a file like that it goes triple.   Just READ the file. You could read it into multiple observations if you are not sure how many values are on the line. First lets convert your example into a FILE so we have something to program against. filename have temp; options parmcards=have; parmcards; PB.PXDWXBX.SEDWVPAB.MP0|2918951|255186908| ;;;; Now just run a normal SAS data step to read in the file. data want; infile have dsd dlm='|'; var+1; input value :$20. @@; run; Results Obs var value 1 1 PB.PXDWXBX.SEDWVPAB. 2 2 2918951 3 3 255186908 4 4 ... View more

  Do both libname definitions include the database name? What about the ODBC driver definitions?   ... View more

You could use libname() funtion in data step to get job done. data _null_; response =libref("data"); put response=; if response ne 0 then rc=libname('data','c:\temp'); run; ... View more

What happens when you just do: mkdir /tmp/user1/test/jan2025 ?   ... View more

I have spent many hours to seach and to develop. I thought that it will be a good idea to share with the community ... View more

Looks like you turned off the LABEL option.   Example: data class; set sashelp.class; label name='Student Name'; run; options nolabel; data class2; set class; run; options label; data class3; set class; run; proc compare data=class compare=class2; run; proc compare data=class compare=class3; run;     ... View more

I would like to know why when we add just one more variable like orgnl_sas_ds_row_nbr, the label into the new dataset become blank instead of transfering the previoius label.     How to correct that issue? ... View more

Hi ! Nice solution, with pipe it is the only way it worked for me.    Regards, Miguel. ... View more

Use a slash to change a password. data T1(pw=R); A=1; run; proc datasets nolist ; modify T1(write=R/W alter=R/A read=R/RR); run; quit; proc print data=T1(read=RR); run;   ... View more