BookmarkSubscribeRSS Feed
Babloo
Rhodochrosite | Level 12

I'm using file writer transformation in my DI job to create the .txt file. After the successful execution of the job, when I tried to open .txt file, I'm getting an error like "Invalid Physical file". Code generated by file writer transformation as follows.

 

data _null_; 
   set &SYSLAST; 
      attrib TBKPAR length = $2; 
      attrib CRI length = $12; 
      attrib P2KBRN length = $2; 
      attrib CRIHIS length = $12; 
      attrib P2KBRH length = $2; 
      attrib SD length = $9; 
      attrib S2KBRN length = $2; 
      attrib XXAROL length = $8; 
      attrib PSI length = $9; 
      attrib HDK length = $3; 
      file "!FSB/common/life_details_crdb_50_tmp_timestamp.txt" lrecl=1226;
      
         put 
             @ 1 TBKPAR  
             @ 3 CRI  
             @ 15 P2KBRN  
             @ 17 CRIHIS  
             @ 29 P2KBRH  
             @ 31 SD  
             @ 40 S2KBRN  
             @ 42 XXAROL  
             @ 50 PSI  
             @ 59 HDK  
         ;
   
run;

Properties of File wrtier transformation:

 

FW.pngFW2.png

 

Appreciate if someone of you help me understand the likely cause for this issue.

1 REPLY 1
LinusH
Tourmaline | Level 20
How do you try to open it?
Almost any text file generated can be opened using standard text editing tools.
Data never sleeps

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2204 views
  • 1 like
  • 2 in conversation