Hi, I'm trying to export data to an excel file without labeling it since I want the first row in the excel file to be the first row with data in the EG database. I have EG 4.3 SAS9.2 proc export data=work.QUERY_ART DBMS=excelcs outfile="C:\Documents\Reports SAS\Test.xls" Replace; PUTNAMES=NO; Sheet="Test"; Server="pgl0408"; Port=8629; Run; However it gets an "ERROR 180-322: Statement is not valid or it is used out of proper order." for the putnames statement. Appreciate all the help. ... View more

Hi, I'm trying to add two tables with similar data but I have more than one possible match between them. Example below: Table 1 Field 1 Field 2 Field 3 LA Street 1 House 1 LA Street 2 House 1 LA Street 2 House 2 NY Street 1 House 1 NY Street 1 House 2 NY Street 2 House 1 and Table 2 Field 1 Field 2 Field 3 Code LA Street 1 House 1 Code1 LA Street 2 House 1 Code12 LA Street 2 House 2 Code54 NY Street 1 Code15 NY Street 2 Code43 NY Street 3 Code67 I want to match the code on Table 2 to each row on Table 1 however for NY it doesn't have a field 3 specification and the code should be linked only to street number whatever the house number is. I want the output to be something like this: Field 1 Field 2 Field 3 Code LA Street 1 House 1 Code1 LA Street 2 House 1 Code12 LA Street 2 House 2 Code54 NY Street 1 House 1 Code15 NY Street 1 House 2 Code15 NY Street 2 House 1 Code43 Is there any way I do this on SAS EG directly? Thanks ... View more