Hi all,      I am here again, because of having problem.      My problem senario is like this...      I haved a table call etllib.TempStoreDistinctValue.Inside this table, provided with two coloum name WarehouseCode, ItemCode      What i wanted to do is       i wanted to loop through this table by getting to value and pass the value to a Macro Variable.      Before this, i tried to bind only a coloum into a Macro variable at proc sql      this is how i done it. proc sql noprint;      select count(BranchCode)           into :n           from etllib.TblBranchLookUp;      select BranchCode into:BranchCode1 - :BranchCode%left(&n)           from etllib.TblBranchLookUp; quit;      This is for one coloum only, how about two coloum?      i tried this code. proc sql noprint;      select count(Warehouse)       into :Whs       from etllib.TempStoreDistinctINVNMV;      select Warehouse,ItemCode into :Warehouse1 - :Warehouse%left(&Whs),ItemCode1 - :ItemCode%left(&Whs)       from etllib.TempStoreDistinctINVNMV; quit;      Its seem got bit problem, but dont know where goes wrong that error code is expecting a :. near ItemCode1.      Anthing goes wrong ?      Or have other better method way?      Thank you,Apperciate your help.      Please dont hensitate to  voice out my error or mistake that i done.Learn from mistake is a good thing.Thank you. Liang ... View more

hi all      i created a datastep to generate a delimited csv file.Code as below: Sources Code:          data _null_;           set etllib._101100_MonthlyDSFACT;           FILE DelSum DLM=',' notitles header=headrtne;           PUT  WhsCode :$8.                DocDate :yymmddn8.                DocDueDate :yymmddn8.                ItemCode :$20.                Quantity ;         return;                headrtne:                PUT @1 'WhsCode,DocDate,DocDueDate,ItemCode,Quantity';           return;           run; Output: DelSum_20111012.csv WhsCode,DocDate,DocDueDate,ItemCode,Quantity B09,20110926,20110926,10423632,2 WhsCode,DocDate,DocDueDate,ItemCode,Quantity B11,20110926,20110926,10421902,1 My Expected Output is like this WhsCode,DocDate,DocDueDate,ItemCode,Quantity B09,20110926,20110926,10423632,2 B11,20110926,20110926,10421902,1 How can i do so with the data step. beside, i tried before using proc export to done the job.its provide me the nice output except the date format is following the sas date format /*           proc export data=etllib._101100_MonthlyDSFACT                     file="F:\abc\&&FileNameD%sysfunc(putn(&&Todaydate,yymmddn8.))&&Extension"                     dbms=csv                     Replace;           run; */ Is there other way to deal with it? Please help. Thank you: LiangCk ... View more

HI there,      First of all, thanks for reading this discussion.      i have a some code written that i want to append data that extracted from a series of csv file into one dataset.      what i have done is i "indirectly" append by temporaly store into a temp sas table then call proc append append into a detail table.      my code written like this: Data etllib.TEMPSDelivered_NonDeliveredFact;       infile indir(&fname) truncover delimiter=',' FIRSTOBS=2;       input CardCode:$15. CardName:$100. Block:$100. StreetNo:$100. Address:$100. ZipCode:$20. State:$100. Country:$100. fatherCard:$15. CardReceipt:$100. CardReceiptID:$15. Active:$1. Region:$200. Route_Code:$8.                Branch_Code:$8. Route_Day:$8. Delivery_Date:yymmdd10. ItemCode:$20. ItemName:$100. Quantity UOM:$20. RouteFreq:$100. Route_Sequence Route_Truck:$100. DeliveredStatus:$1. Reason:$100. LogTime:time. LogDate:yymmdd10.;       file outdir(&Read&fname);       put _INFILE_; run; proc append base=etllib.Delivered_NonDeliv data=etllib.TEMPSDelivered_NonDeliveredFact; run; Note:- "indir(&fname)" is a file path name that refer to a csv file.      - TEMPSDelivered_NonDeliveredFact is a temporaly table.      - Delivered_NonDeliv is a detail table. PS: this process is in a nested loop. Problem: am i just can direct append on the infile statment there instead of insert into  TEMPSDelivered_NonDeliveredFact and call                 proc append to done this job?      Please, help me..thank you everyone...      Thank you. Best Regards LiangCk ... View more

Hi there, Basically, apperciate person who read my discussion. I have a  issues with csv or text file encrytion. Currently, we have done the basic requirement from customer. But we notice that we still missing out a part that called encrytion. Basically, our project scenario is we generate several csv file to branched and send to ftp server. And in branches, what they are doing is grab the csv file and made some process through non sas application(moslty is .net app) to grab out all the information. problem is, we should implement an csv file encryption technique and decrypt in branch. Is that any possible way to do so? is there any references to these technique? Please note me if there any question...thank you, apreciate alot. Regards Liang CK ... View more

Dear all,      is there anyone here facing problem that when running a job, sas ignore your user written code?(does not process it) and it show process fullly successfully?.      is there anyone here have any idea what actuallly is occur? is that the marco or any admin stuff? Regards Liangck ... View more

Hello all,           i am going to read a file name thats like B11_20110926_DeliverStatus.csv           i am able to collect the date by substring the file using the following code: %substr(B11_20110926_DeliverStatus.csv,4,8);           but i am unable to get the MONTH of the substring's file.           is that possible to convert the 20110926 to a sas datetime format?           i try to get the date by using following code.           is that still anyway to do so? Regards: Liangck ... View more