Thank you RW9 for your reply.
I'm opening the text file in Notepad. I've corrected my code by using pipe '|' as delimeter. This file should be sent as text file:
data _null_ ; set table.abc; FILE '/opt/sas94/home/user1/text1.txt' dsd dlm='|' ; PUT var1 var2 var3 var4 var5 var6 var7 var8; run ;
B) your moving it across to Windows from Unix - this is most likely and common.
Yes,maybe it is the issue. There are two ways for me to run the code:
Localy from my PC and connect to the server and save text file there.
From Citrix (Windows server) and save file on server.
In both cases I faced the same problem but it seems that it is OK for my colleague to receive the file in this way.
But I have another question. Here is an example of text file:
100000095|abcdefghijk|kj7764bbid|20JAN2015|21FEB2015|201501100000098|abcdefncvbjk|abcdehg564d5|09JAN2015|02APR2015|201501100000096
In 201501100000098, 201501 is the last value for the first record and 100000098 is the first value for the second record.
How should I change the code so '|' to be placed between 201501 and100000098?
... View more
