BookmarkSubscribeRSS Feed
chandler
Fluorite | Level 6
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.
MONTHEND,
MONTHEND#1
MONTHEND#2
MONTHEND#3

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.
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 ?

DATA newfile;
set MONTHEND (GENNUM=2) ;
where account_numbers gt "1234" ;
run;
1 REPLY 1
SPR
Quartz | Level 8 SPR
Quartz | Level 8
Hello Chandler,

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.

Sincerely,
SPR

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1622 views
  • 0 likes
  • 2 in conversation