My code is: options compressed=yes; libname public "path/to/public"; x "gunzip path/to/public/sale_21.sas7bdat.gz"; proc append base=public.sale_21 data=public.new_21 force; run; x "gzip path/to/public/sale_21.sas7bdat"; At the beginning, there are two datasets under public folder: one compressed sale_21.sas7dbat.gz and one uncompressed new_21.sas7bdat I want to uncompressed sale_21 add data from new_21 to the end of sale_21, and then gzip it back. The public folder should still have two datasets. But after I run my program, it create another dataset, now my public folder has three files : one compressed sale_21.sas7bdat.gz and one uncompressed sale_21.sas7bdat and the original new_21.sasbdat. Why it created additional datasets? What should the codes be ?? Thanks SO much!! Any help would be greatly appreciated! ... View more

I run a program to create tables. But I got errors like this: “Error: Expecting page 43290, got page -1 instead. Error: Page validation error while reading libname.tablename.DATA. Error: File libname.tablename.DATA is damaged. I/O processing did not complete. Note: compressed is 43289 pages; “ I used below code to repair the table: Proc datasets lib=libname; Repair tablename / encryptkey=secret; Run; Quit; No errors for Proc dataset step and it seems like worked. But that table still cannot be query. What code I should use to fix it? Please provide an example. Please help! You will be gratefully appreciated! ... View more

I have three tables for event: event21, event22, event23, and one member table. How can I return Event col only based on the year of member’s birthday? I have tables like this: Codes Event21 A CDC F JFK G BOB Codes Event22 A EED F UOP G SNP-D Codes Event23 A EED F UOP G SNP-D K BDP MemberID DOB Codes 123 1/30/2021 F 456 2/28/2022 G 789 3/30/2023 K I want output to be like this: MemberID DOB Codes Event 123 1/30/2021 F JFK 456 2/28/2022 G SNP-D 789 3/30/2023 K BDP How should I join those tables? Thanks! ... View more

I’m new to sas. I need to run my sas program in batch mode on Putty, how do I archive the log to another location? My I have an example of sas codes. I’m using: nohup /opt/sas/config/Lev1/SASApp/sas programname.sas & is that correct？ ... View more