Hello,   Is it possible to create a report through SAS that is similar to the spreadsheet below? The goal is search specific phrase within the SAS files in the folder/path and put it as a report.   Example: File Report file name Data step Proc SQL  Proc Format Proc Freq sample1.sas YES NO NO YES sample2.sas YES YES YES NO sample3.sas NO YES NO NO     Thank you ... View more

Please refer to two fake datasets   Data 1: Year state city conditionA conditionB Value 2021 0 0 1 1 5000 2021 0 0 1 2 4000 2021 0 0 1 3 900 2021 1 1 2 1 . 2021 0 1 2 2 3000 2021 0 1 2 3 2980   Data 2: city conditonA conditionB Value 0 1 2 4100 1 2 3 3000   Final Table: Year state city conditionA conditionB Value 2021 0 0 1 1 5000 2021 0 0 1 2 4100 2021 0 0 1 3 900 2021 1 1 2 1 . 2021 0 1 2 2 3000 2021 0 1 2 3 3000   Basically I want to replace value from data 2 to data 1.   Which method should be used? (data step/proc SQL)   Thanks in advance., ... View more

Hello, I have dataset example illustrated below: row# YEAR SEX CITY STATISTICS VALUE 1 2021 . . 1 500 2 2021 1 1 1 0 3 2021 2 1 1 499 4 2021 . 1 2 750 5 2021 1 1 2 0 6 2021 2 1 2 750 7 2021 . 2 1 300 8 2021 1 2 1 150 9 2021 2 2 1 150 10 2021 . 2 2 550 11 2021 1 2 2 549 12 2021 2 2 2 0   '.' refers to the total I would like to replace the value from row 3 to match with the row 1 value (500) in order to keep consistency on the total. Also, I would like to replace the value row 11 to match it with the row 10 value (550). Is there any code rather than inputting manually to replace values in this situation?   Thank you,  ... View more