Hi
when i tried to write data to an external file with a delimiter,it is writing data to the file but with no delimiter.
The code is as below
data _null_;
file " &ctl_file " dlm='|' ;
put "&business_dt_tm" "&business_dt_tm" "&extract_dt_tm" "&extract_dt_tm" "&rec_count" "&sequencenum";
run;
What's wrong with the code?
Thanks,
Swathi
The PUT statement will not write delimiters between string literals. Either include the delimiter in the strings,
data _null_;
file "&ctl_file" dsd dlm='|' ;
put "&business_dt_tm|&business_dt_tm|&extract_dt_tm"
"|&extract_dt_tm|&rec_count|&sequencenum"
;
run;
or put the strings into a variable and write the variable.
data _null_;
file "&ctl_file" dsd dlm='|' ;
length name $100 ;
do name = "&business_dt_tm" ,"&business_dt_tm", "&extract_dt_tm"
,"&extract_dt_tm", "&rec_count", "&sequencenum"
;
put name @ ;
end;
put;
run;
Also don't put spaces at the beginning and end of your filenames. You will have a real hard time referencing those files again!
You are writing text, not data, So the text is written as is.
data _null_;
file " &ctl_file " dlm='|' ;
put VAR1 VAR2 ;
run;
will use the delimiter
The PUT statement will not write delimiters between string literals. Either include the delimiter in the strings,
data _null_;
file "&ctl_file" dsd dlm='|' ;
put "&business_dt_tm|&business_dt_tm|&extract_dt_tm"
"|&extract_dt_tm|&rec_count|&sequencenum"
;
run;
or put the strings into a variable and write the variable.
data _null_;
file "&ctl_file" dsd dlm='|' ;
length name $100 ;
do name = "&business_dt_tm" ,"&business_dt_tm", "&extract_dt_tm"
,"&extract_dt_tm", "&rec_count", "&sequencenum"
;
put name @ ;
end;
put;
run;
Also don't put spaces at the beginning and end of your filenames. You will have a real hard time referencing those files again!
Thank you Sir!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.