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

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

nishant604 — Wed, 22 Jun 2016 17:35:19 GMT

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.

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

data_null__ — Wed, 22 Jun 2016 17:44:44 GMT

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

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

nishant604 — Thu, 23 Jun 2016 04:41:24 GMT

Thanks, that worked.