Reeza, I use the following code and when I transfer the file from Linux to windows files out put is  - Product_id 123. However, when I edit the file out put is different - Product ID 1 2 3 Reeza wrote: Yes it works on unix. What does your data look like? Another possibility is your text editor is garbling it. Try viewing it in something else or via the more command in unix. You still haven't posted your code though. data product; infile datalines; input product_id $; datalines; 1 2 3 ; filename outfile "/mnt/data01/test.txt"; data _null_; file outfile Encoding=u; set Product; if _N_ = 1 then put  'Product_id'; do _N_ = 1 to length(Product_id); id=substr(Product_id,_N_,1); put @1'id'n 10.; output; end; run;        ... View more

Would this work on Linux ? Outfile file is on linux server. ... View more

i used the   if _n_ =1 then put .....and i'm still getting data in one line Product ID 123 I woulud like the result to be: Product ID 1 2 3 Thanks ... View more

Thanks for all your help. Linlin solutin worked: data want; set have; /* your dataset name */ by rid; if first.rid then sales_start_day=0; sales_start_day+1; run; ... View more

Thanks for the quick reply. ... View more