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!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.