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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: