Writing to an external file with a delimiter

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Writing to an external file with a delimiter

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


Accepted Solutions
Solution
‎01-11-2018 11:32 PM
Super User
Super User
Posts: 7,380

Re: Writing to an external file with a delimiter

[ Edited ]
Posted in reply to swathiprasad

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!

 

 

View solution in original post


All Replies
PROC Star
Posts: 1,920

Re: Writing to an external file with a delimiter

Posted in reply to swathiprasad

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

Solution
‎01-11-2018 11:32 PM
Super User
Super User
Posts: 7,380

Re: Writing to an external file with a delimiter

[ Edited ]
Posted in reply to swathiprasad

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!

 

 

Occasional Contributor
Posts: 15

Re: Writing to an external file with a delimiter

Thank you Sir!!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 132 views
  • 0 likes
  • 3 in conversation