Hi All, I currently have an excel file that has multiple lines associated with certain records as follows: ID J Order 003 01003 05 40 6050 K 150 1500005 I'm looking to create datalines in SAS as follows: data have;
input ID ORDER;
datalines;J,^003|01003|05|40|6050
K,^150|1500005; Also, is there a limit to how many characters can be in a single dataline? Some of the excel records have hundreds of order numbers associated with them. Thanks for all your help!
... View more