![]() ![]() You will easily understand changes needed. Instead why don't you just study what is basic differences in VB and FB datasets. What changes we need to do when input is a VB file with RL 84 and output file is having same RECFM *FB 100 SPLICE FROM(IN1) TO(OUT) ON(80,1,CH) KEEPNODUPS. But I need A to be copied into output dataset. Then the above code is creating empty output dataset. In IN1 (input) contains only one record i.e, When my Input contain only single record then "SPLICE" is returning empty dataset as an output. I was using the above ICETOOL "SPLICE" code, now I got an issue with the above code. Give the relevant information (RECFM, LRECL, layout of input and output fields, etc). ![]() ![]() Show an example of your input records and what you expect for output. Please start a NEW topic for your question. SAS PROC TRANSPOSE is a way to do this but it's not part of the SORT package. I have a requirement were i need to convert the rows to columns. INREC IFTHEN=(WHEN=INIT,OVERLAY=(101:SEQNUM,4,ZD)), I have considered 4 records in the i/p file and built this ICETOOL cards. I want all the records from the column need to convert into one row. Is that first four records of the i/p to be converted to a row in the o/p and then the second four records of i/p file to second row in the o/p file. What the LRECL and RECFM of i/p and o/p files? Please let me know your suggestions/ideas. I need to convert the data from this column into a row with comma seperated.įile One(Input file) contains records as below: ![]() I have a dataset which has a single column. Convert columns to rows in a dataset -IBM Mainframes ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |