Hi, I am reading few values from a input dataset, using SAS in mainframes. And while writing to the output dataset, I need to add titles/header/labels(not sure what we is the exact syntax in sas) for those fields. For example: Input file layout: LA  ,80002,1942,1040 LA  ,80002,1842,1940 LA  ,80004,1713,1510 output file should be as follows: File should have first record as description/title/label for the upcoming records: Kinda of title for all those fields AREA, LOC , CC ,DEPT LA  ,80002,1942,1040 LA  ,80002,1842,1940 LA  ,80004,1713,1510 I cant try proc print, because I am writing all records to a output dataset and not in sas log. Also if i use proc print data=infile1 label; label area='AREA1'; run; I am getting spaces between all those Fields. Please help. ... View more

Hi, I am working in a DYL280 to SAS conversion project. I am facing few issues to complete this task. Please help me to overcome this. Thanks much in advance. Requirement is: First lookup to select NAME and loc: Need to do a lookup between file1 and file2, whereas name was the key field. IF found between two files then update file1 by moving TLOC(in file2) TO ZIPCODE(in file1). If not found then list 'NAME NOT FOUND' NAME in sas log(Note: value in the name field for that unmatched record should be written in the saslog as well) and reject that record . And drop all unmatched records and update file1 with only matched records. DYL280 code: ****SELECT NAME**** BINSEARCH FILE2 NAME IFFOUND EQ 'Y' NEXT ELSE LIST 'NAME NOT FOUND' NAME GOTO NEXTRECORD ENDIF MOVE TLOC TO ZIPCODE Second lookup between file1 and file3, where as DEPT was the key field. IF found between two files AND TAREA1 NOT EQUAL TO 'AYA' then update file1 by moving TAREA2(in file2) TO TAREA(in file1) and AREADESC(in file2) TO LDESC(in file1). If not found and TAREA1 EQ 'AYA'  then list 'DEPT NOT FOUND IN FILE3' DEPT in sas log.And drop all unmatched records and update file1 with only matched records. ****REJECT ANY DEPT CCS, GET CC DECS**** BINSEARCH FILE3 DEPT IFFOUND EQ 'Y' NEXT ELSE LIST 'DEPT NOT FOUND IN FILE3' DEPT GOTO NEXTRECORD ENDIF IF TAREA1 EQ 'AYA' GOTO READMAST ENDIF MOVE TAREA2 TO TAREA MOVE AREADESC TO LDESC SAS code we tried for first logic: But unable to drop unmatched records and update more than one variable at a time. And unable to list down the nonmatched field value in SAS log. proc sql;    update file1 as A    set zipcode = (select tloc from file2 as B                        where b.Tname = A.Name)   ; quit; Input file layout and sample records: data file1; input @01 Name               $12. @14 zipcode             05. @20 Area1              $03. @23 dept                04. @28 ldper               02. @30 ldesc               30.; datalines; JohnAbraham  80000 AY 1900 09 Madisson     75200 AY 1825 01 Murphy       95210 AY 1952 06 Donaldmathew 65214 NY 6854 18 Eric         85102 NA 7889 24 ; run; data File2; input @01 TName           $12. @13 Tloc            05. @18 tarea1         $03. @21 tdept1          04.; datalines; Mathews55589 LA 1980 10 Jonny  75200 LA 1825 01 David  87510 HT 1952 06 Edrick 65214 LO 6854 18 Monaay 74502 NA 7889 24 ; run; data File3; input @01 Tloc1            05. @07 tarea2         $03. @10 tdept2          04. @14 areadesc       30.; datalines; 55589 LA 1980 10 SOUTHEREN CALIFORNIA 75200 LA 1825 01 87510 HT 1952 06 EASTERAN BAY 65214 LO 6854 18 NEWYORK 74502 NA 7889 24 WASHINGTON.; RUN; ... View more