Hello,    I created a table using Proc Sql and used PUT() to convert numeric value to character. There are two issues that I'm now facing and hoping someone can help me:   1. How can I assign format and informat to those columns with no format and informat? 2. For the column wherein I used put(x,9.), I got 8 spaces + . (dot) for those with no value. How do I replace this to just be simply blank? Is there a way to incorporate the solution into my proc sql table? If not what's the most efficient way to tackle these issues?   Thank you for your help!   ... View more

Hello,   I bumped into this post % Let macro variable be max date in dataset.  I followed the solution but when I created and called the macro, I'm getting this error message: 35 21AUG2023 _______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. This is my code : proc sql; select max(a.payout_dt) format=date9. into :max_dt from my.table a; quit; proc sql; create table report as select * from my.database a where a.snap_dt<=&max_dt; quit; Appreciate any feedback that can help me troubleshoot this.   Thanks!         ... View more

Hello,   I have a scheduled job that keeps on failing. The SAS runs fine except for a it gets WARNING: Character expression will be truncated when assigned to character column Type.   I was told by our support to configure the scheduler to look for exit code 1 since the SAS tables are being updated as expected. However, if I change this to exit code 1, it won’t be able to detect if the code has an error or if it failed.   Asking the scheduler to look for Exit Code = 0, fails because I have a Warning message.   My questions are: How do I get rid of WARNING: Character expression will be truncated when assigned to character column Type? The Type column in the server.final has Type=Char, Len=15, Format = $15., Informat = $15. I tried to do something like substr(Type,1,15) length=15 and I also tried altering the character type before inserting to align the format/informat but it didn’t help – I got the idea from here   How do I know what is the exit code of my sas program? I added %put &=syscc in the end of the program I got code 1012 but I don’t know if that’s the exit code   Here is my sas code, it’s very simple but I noticed that the job is failing when add the insert code. Really appreciate your help here.   proc import out=work.import             datafile='directory/a.xls'             dbms=xls replace ;             getnames=yes; run; proc sql; insert into server.final (Date, Name, Type, Full_Comments) select      a.Date,      a.Name,      a.Type,      a.Full_Comments from work.import a; quit; %put &=syscc;   ... View more