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.
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.