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:
Appreciate if someone of you help me understand the likely cause for this issue.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.