Tag: datastep

SAS-Append data to a table and increment a flag on the resultant table

I have two tables on SAS “Table_A” and “Table_A_Archive”, as part my ETL process “Table_A” is created on a daily basis and the data should be archived on “Table_A_Archive”. When the data is archived on “Table_A_Archive” a a flag will be created/updated “DT_FLAG”. On the first day this is how the table would look like On Day 2 The new

Extrapolate running total from .LAST value of a BY GROUP

cumulative-sum datastep sas sql

I trying to figure out how to create a running total, if all we have is the total sum in the .LAST variable. I created a sample dataset that should make it a little clearer what I am after: ; so, as you can see we only have data for the last time the store was in business, which includes

SAS datastep/SQL select latest record from multiple records with same ID

datastep proc-sql sas sql

For example I have a dataset as below: By datastep or sql, how could I get the record with id = 1 and latest Date 2002/01/01? Help is appreciated and thanks in advance. Answer Try this sql.