Hello.    I am trying to export a text file with specific position points for columns.  I am having difficulty with removing the extra blank line after each row of data.   This text file must have line record length of 455 and CRLF return but it seems like my file is producing CR after each row of data.   This is the code I am using.  Can anyone see what needs to be modified.  Any help would be greatly appreciated.  Thank you.      DATA _NULL_; file 'D:\EF/VACHLINVARMv1.TXT' Ls= 445;    IF _N_ = 1 THEN DO;    SET E.tatehdr;    PUT       @1    FILE_TYPE       @51 TOTAL_RECORDS_IN_FILE       @61 FILE_NAME       @86 FILE_IDREC       @118 FILE_RPT_PERIOD ; END;       SET E.slevel;     PUT @1 RECORD_NUM @11 FIPS @13 AGNCY_NUM  @49 TABLE_NAME @69 WEA     @119 TYPE @169 FinalWea  @184 TYPE2 @234 TOTAL_INDICATOR @435 COUNT @445 '0D'x; RUN; ... View more

Hi.   I am trying to scan data columns for sites for each ID.  I am looking for the following record (where there is no blank) and for that data value to be placed into a new column (Most Recent).  I am having difficulty trying to get SAS to bypass the record rows where there is a blank and to pick the next row containing data.  Can anyone shed some light?    The first table shows the data the second table shows how I would like the results  .         DATA Once;  INPUT ID $ visit1 site1  ; CARDS; Inn342      null  null Inn342      Anc         Sha Inn342      Drr         Loc Pan322                        Pan322      Cli         Dha Pan322      Omn         Sha ; RUN;   ... View more

Hi.  I have a very large dataset and I need to be able to locate data discrepancies to exclude from my rate calculation.  In my example below, column Verd1 is the main identifier and column LocalVerd is another identifier created by a vendor.  I need to figure out how to code to identify erroneous data within a group.  In the example below, under column Plan, Pacific would pass and is correct as the rows within Pacific contain consistent identifier information (Same Verd1 and same localVerd).  However, Plan Delta for product X33ui will need to be excluded as this product (X33ui) contain two different LocalVerd identifiers (PX333 and Rx988) for this same Verd1 identifier (Twa88)- LocalVerd should be PX333 but reported Rx988.      Is there a way to code to output table containing all the Plan and product containing inconsistencies?    Data table is below and my output table I would like is the second table.  Thank you in advance   Plan Product Verd1 LocalVerd Delta X33ui Twa88 PX333 Delta X33ui Twa88 PX333 Delta X33ui Twa88 RX988 Pacific V933aa Lbl322 QT770 Pacific V933aa Lbl322 QT770         Wanted OUTPUT     Plan Product Verd1 LocalVerd Delta X33ui Twa88 PX333 Delta X33ui Twa88 PX333 Delta X33ui Twa88 RX988   ... View more