Your are really great. Thank you sir. Will try wat u said. ... View more

Hello Sir, How to make this code in macro to automate the process?  ... View more

One more problem Sir.. Since ACMT is not available in last line of record.. The last line got stored in buffer. It is not coming in output. Once this is resolved...I will acheive my required output. Please help   Thanks Abhi ... View more

Super.. I understood now.. I am new SAS your explanation made me very clear. Thanks for patient reply 🙂 Meanwhile, how u r defining the below? I mean how x+4 and X-1? substr(a,x+4); substr(a,1,x-1)   ... View more

Initally you gave length to a1 as $100. Again in input y u gave a1 as $3000? and could you please xplain me what the below code does? x = index(a,'ACMT'); do while (x = 0); input a1 $100.; a = trim(a) !! a1; x = index(a,'ACMT'); end; do while (x > 0); b = substr(a,1,x-1); output; a = substr(a,x+4); x = index(a,'ACMT'); end; ... View more

Copuld you please edit the code and send me. Coz i am not quite clear on macro part. Also let me know what is the difference between your code and mine? ... View more

Where u r defining the variable like. . Which set of data will be set in A variable and which in B? ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Hi, The file is seem to be like extracted from copybook.. As I already explained. .With that data I need to create a table in SAS. I have attached the template and raw data. The data starts from ALH ends with the time. At the middle we have delimiters space and ^T we have to avoid those. And if suppose the file exceeds the maximum variable size which is 32K at that case how can I read the data. This is my question. ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Thank you so much superb explanation. However, the data is not fitting into my table structure. Could you please refer to the attachment . Also, if the file exceeds maximum sas variable(32K) we need to find a solution for it. Please help ... View more