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.
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!
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.