You do not need to count in advance when selecting values into what some people call a macro "array". Just set the upperbound to some value that is larger than the maximum you could find or process. proc sql noprint; select Warehouse , ItemCode into :Warehouse1 - :Warehouse99999 , :ItemCode1 - :ItemCode99999 from etllib.TempStoreDistinctINVNMV ; %let Whs=&sqlobs; quit;
... View more
You do not what to use HEADER option on the FILE statement to generate a CSV file. It will only work with the PRINT option but then it will also generate page breaks (formfeeds) and extra header lines.
... View more
Hi Bruno, Thank for your advice, i think i shall used back my method because this process related to dynamically read external file. Static is much better... Thanks again.. Liang Ck
... View more
If your customer is requiring encryption, I would think that they would require a particular level and algorithm. Take a look at http://en.wikipedia.org/wiki/Encryption_software for some background info and references.
... View more
Halaku: ya, i do it all the way with %put ....and i get no result in the log. totally no idea what happen last time... now no problem alreadly, it work well, just want to made sure its not happen again. Anyway,thanks for reply. LiangCk
... View more
Hi DHNA and Ksharp thanks for your advice, i done it with fdelete alreadly.. the code like this filename fileDel ftp "&&SAS_Import&&Note&I&&Data_Upload&&Docm&J" host=&ftpHost user=&ftpUser pass=&ftpPass prompt; %let rc = %sysfunc(fdelete(fileDel)); Thanks anyway.Apperciate your help. Regards: Liangck
... View more
