Hi All, this is kumar, Currently i am working on legacy system(Mainframes) and we use to send the final reports to users in ".csv" file format using SAS. Today we received a new requirement to dynamically "Wrap Text" for particular field.
EX:
"First Name",="Last Name",="Middle Initial",="DOB ",="Address1" ==> Header Record
"Abc ",="LM ",="MI ",="01012017",="St name and Flat No and APT name" ==> Detail Record
My requirement is to Wrap the test under "Address1" data to 11 bytes and then the next data should follow under the same field
Expected output when the file is sent through SAS in .csv file format:
"First Name",="Last Name",="Middle Initial",="DOB ",="Address1" ==> Header Record
"Abc ",="LM ",="MI ",="01012017",="St name and
Flat No and
APT name" ==> Detail Record1
"ABBB ",="LM2 ",="MI2 ",="01012017",="St name and
Flat No and
APT name ap
sample data" ==> Detail Record2
Please let me know if any solutions.
EX:
"First Name",="Last Name",="Middle Initial",="DOB ",="Address1" ==> Header Record
"Abc ",="LM ",="MI ",="01012017",="St name and Flat No and APT name" ==> Detail Record
My requirement is to Wrap the test under "Address1" data to 11 bytes and then the next data should follow under the same field
Expected output when the file is sent through SAS in .csv file format:
"First Name",="Last Name",="Middle Initial",="DOB ",="Address1" ==> Header Record
"Abc ",="LM ",="MI ",="01012017",="St name and
Flat No and
APT name" ==> Detail Record1
"ABBB ",="LM2 ",="MI2 ",="01012017",="St name and
Flat No and
APT name ap
sample data" ==> Detail Record2
Please let me know if any solutions.