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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.