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

[nishant604]

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.

[data_null__ · Accepted solution]

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    

[nishant604]

Thanks, that worked.