Hi there, I am working on positioning data elements in SAS to exact record postions and then creating a text file? But for some reason I am not able to get the data show in the correct columns. I need to submit some patient data to National Death Index registry to obtain their date and cause of death. So for each data elements, certain numbers of spaces are allowed: For instance Last name (1-20) First name (21-35) SSN (37-45) and so on... I am attaching that document; chapter 2 and page 14-18 provide the guidance on how the data should be prepared. The data is originally in excel file. I am attaching a portion of (unreal) data in the excel file. The first sheet of the excel file has some (unreal) data, that I tried to copy paste in the following SAS code in order to position the each data element to the positons as instructed in the PDF doc. The second sheet in the attached excel file shows the SAS output data. Please take a look and you'll know how the data is misplaced, not under the respective columns headings. I needed to assign the spaces/positions to each element in SAS and then convert it to a text file without any delimiters. Below is the SAS code that I am using and the SAS output file is on sheet 2, which shows that the data is not in the correct columns. I am not sure if there's a specific way to enter the data in the SAS code. I just copy pasted it from the excel file into the SAS code. data test; input Last_Name $ 1-20 @21 First_Name $ 21-35 @36 Middle_Initial $ 36 @37 Social_Security_Number 37-45 @46Month_of_Birth 46-47 @48 Day_of_Birth 48-49 @50 Year_of_Birth 50-53 @54 Father_Surname $ 54-71 @72 Age_Unit_at_death_ 72 @73 Number_of_Age_Units_death 73-74 @75 Sex $ 75 @76 Race $ 76 @77 Marital_Status $ 77 @78 State_Residence $ 78-79 @80 State_Birth $ 80-81 @82 Control_ID_number 82-91 @92 Age_in_1991 92-97; datalines; asdad dasdad 121331313 06 18 1928 M CA 10001 62 adad adad 121212121 02 23 1934 M CA 10002 56 adad adad 021212121 02 23 1934 M CA 10002 56 bnvn vnbvbn 021111212 10 27 1917 F CA 10003 72 rty lfghdh 326598542 07 31 1919 M CA 10008 71 sada bnmb 326512522 06 26 1933 M CA 10010 57 sdfsf ftgh 010201020 07 12 1920 M CA 10011 70 run; Please take a look and let me know if you could offer any suggestions/guidance on this. Thanks so much! Ashwini
... View more