https://communities.sas.com/t5/SAS-Programming/GENNUM-Data-Set-Option/m-p/20405#M3196 I am running SAS v9.1.3 SP4 on Windows XP operating system. In our data mart there are Generational Datasets for each monthend file, ie. <BR /> MONTHEND,<BR /> MONTHEND#1<BR /> MONTHEND#2<BR /> MONTHEND#3<BR /> <BR /> All the SAS documentation I could fined only talks about creating and maintaining generational datasets, and how to do a PROC PRINT on a specific generation number, but no instructions on how to reference and retrieve data from a specific generation number, in a data step.<BR /> I want to read data from MONTHEND#2, to create a subset of data, based on a where statement. Is this data step, below, the proper way to do that and is the syntax correct ?<BR /> <BR /> DATA newfile;<BR /> set MONTHEND (GENNUM=2) ;<BR /> where account_numbers gt "1234" ;<BR /> run; Wed, 02 Mar 2011 17:37:56 GMT chandler 2011-03-02T17:37:56Z https://communities.sas.com/t5/SAS-Programming/GENNUM-Data-Set-Option/m-p/20405#M3196 I am running SAS v9.1.3 SP4 on Windows XP operating system. In our data mart there are Generational Datasets for each monthend file, ie. <BR /> MONTHEND,<BR /> MONTHEND#1<BR /> MONTHEND#2<BR /> MONTHEND#3<BR /> <BR /> All the SAS documentation I could fined only talks about creating and maintaining generational datasets, and how to do a PROC PRINT on a specific generation number, but no instructions on how to reference and retrieve data from a specific generation number, in a data step.<BR /> I want to read data from MONTHEND#2, to create a subset of data, based on a where statement. Is this data step, below, the proper way to do that and is the syntax correct ?<BR /> <BR /> DATA newfile;<BR /> set MONTHEND (GENNUM=2) ;<BR /> where account_numbers gt "1234" ;<BR /> run; Wed, 02 Mar 2011 17:37:56 GMT https://communities.sas.com/t5/SAS-Programming/GENNUM-Data-Set-Option/m-p/20405#M3196 chandler 2011-03-02T17:37:56Z https://communities.sas.com/t5/SAS-Programming/GENNUM-Data-Set-Option/m-p/20406#M3197 Hello Chandler,<BR /> <BR /> I do not see any problems with this syntax. The only thing I should mention that if account numbers contain both letters and digits then using GT operator could depend on sorting seqiences and have to be used with caution.<BR /> <BR /> Sincerely,<BR /> SPR Thu, 03 Mar 2011 19:02:03 GMT https://communities.sas.com/t5/SAS-Programming/GENNUM-Data-Set-Option/m-p/20406#M3197 SPR 2011-03-03T19:02:03Z