I assume that you have tested you stored procedure outside SAS already. Does the call work but your SAS table will be empty? What are the values of SQLXRC and SQLXMSG macro variables? Any usable hints from the SAS LOG? Regards, Linus ... View more

Try this: data agent2(drop=y rename=(i=y)); set agent1; do i = y to 1 by -1; output; end; run; /Linus ... View more

For sorting the data, you could use a temporary sort column, where your A+ gets a lower value than A, or having A have larger value than A+. For summarization, if you use PROC MEANS/SUMMARY, you can specify ORDER=DATA on the CLASS statment, which will preserve the order from the procedure input. /Linus ... View more

In your case, your BY statement should (probably) look the same as in the preceding PROC SORT. /Linus ... View more

This seems very odd. I can't see why your SQL shouldn't work. Probably the best way to solve this is to open a track to SAS support. A work-around could be using a view, that shouldn't slow things down that much. /Linus ... View more

This documentation might shed some light over your problem: http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a000695157.htm /Linus ... View more

If you are using DELETE FROM in "open" proc sql code, it will assume that twp level table names will contain a SAS libname. In fact, it requires that you first assign a libname to your DB2 database. But by using CONNECT TO, you are using SQL pass-thru. To use pass-thru to delete records enclose your DB2 specific SQL using execute: EXCUTE( ... ) BY DB2; /Linus ... View more

Those macro variables are created and set in the remote session. Use %SYSRPUT to assign them in the client ("master") session. /Linus ... View more

If your Excel cells contains strictly numerical data, PROC IMPORT should treat them as such. So, check that your columns only have numerical data. If so, be sure that they are formatted as numbers. /Linus ... View more

Executing Oracle stored procedures is covered by this SAS (alraedy mentioned in a different thread): http://support.sas.com/kb/18/350.html /Linus ... View more

First of all, why can't you stick with filename ftp? Second, I think would get more luck on a different forum than these ones at this site, since SAS has nothing to offer if you chose to perform the processing outside SAS (by using X statement). Then it's not clear what you want to protect. A password in a scrip tfile can be protected by using file system security. You might also consider that ftp offers no proection during communication. In this case you could consider using the sftp protocol instead. /Linus ... View more

No, call symput will not be executed until after the data step have finished, so there little you can do about changing the syntax within the data step itself. Try this, does it suit your needs? data play; B1=1; B2=5; B3=2; B4=6; B5=3; array b(5) b1-b5; array maxi(5) M1-M5; m1=b1; do i=2 to 5; maxi(i)=max(maxi(i-1),b(i)); end; run; /Linus ... View more

You can use RETAIN to keep track on the date you want to start you 6 month period. It would help if you transform your MM/YYYYY to SAS date format, then you can use INTCK function or calculate the number of days between the current status date and the original defaulted date. /Linus ... View more

You should always use COALESCE() function on common columns when performing a full join. /Linus ... View more

I got it to work. In what way does it not work for you? Maybe you should show your LOG/OUTPUT. My example from sashelp.class: proc sql; select name, find(name,'ne','i') from sashelp.class; quit; Partial output: Name partialname findPos Alfred ne 0 Alice ne 0 Barbara ne 0 Carol ne 0 Henry ne 0 James ne 0 Jane ne 3 Janet ne 3 ... /Linus ... View more