DATA Step, Macro, Functions and more

How do I import pipe delimited data and preserve the leading spaces in the data column

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How do I import pipe delimited data and preserve the leading spaces in the data column

Hi,

i have a data that is pipe delimited and the last string variable in the file has leading spaces. An example of how the data looks like is - 

 

1|10|5000|dr dr
1|2015|| dr dr

 

I'm trying to import using the below code - 

 

data two;
infile cards dlm='|' dsd TRUNCOVER MISSOVER;
input cust_id A B C & $ ;
cards;
1|10|5000|dr dr
1|2015|| dr dr
;
run;

 

But this is giving me a data where the leading spaces have been stripped. And the last column reads as dr dr for both the rows. How can I preserve the leading spaces while importing this data.

 

 


Accepted Solutions
Solution
‎06-23-2016 12:41 AM
Respected Advisor
Posts: 3,799

Re: How do I import pipe delimited data and preserve the leading spaces in the data column

Posted in reply to nishant604
24         data two;
25            infile cards dlm='|' dsd MISSOVER;
26            input cust_id A B C:$char16.;
27            put c $char16.;
28            cards;

dr dr           
 dr dr    

View solution in original post


All Replies
Solution
‎06-23-2016 12:41 AM
Respected Advisor
Posts: 3,799

Re: How do I import pipe delimited data and preserve the leading spaces in the data column

Posted in reply to nishant604
24         data two;
25            infile cards dlm='|' dsd MISSOVER;
26            input cust_id A B C:$char16.;
27            put c $char16.;
28            cards;

dr dr           
 dr dr    
New Contributor
Posts: 2

Re: How do I import pipe delimited data and preserve the leading spaces in the data column

Posted in reply to data_null__
Thanks, that worked.
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 184 views
  • 0 likes
  • 2 in conversation