I have several files with the same data elements. However, in some of these files a prior programmer, omitted some data elements. Example:   Id, Name, Test1, Test2, Test3, GREVERB, GREVERB2, GMATVERB some files are missing:  GREVERB, GREVERB2   Is there anyway to test that these data elements are missing? ... View more

Is there a flag or an option to have the ODS create folders. I have a routine that creates dozens of reports most of which need to be in a separate folder/directory. I have created the top level folders "Distribute\All Users" but there could be a large number of sub-folders(\User1.....\User23). And the number of users is not know until the routine is executed. \All Users \User1 \User2 \User3 \User4 \User5 ODS PDF FILE='W:\Distribute\All Users\User5\User5 Report.pdf' STYLE=prpdf BOOKMARKLIST=NO; ... View more

I am working to clean-up some previous SAS hacker's copy/paste technique. These SAS routines have several dozen DATA steps. At the beginning of the routine, I would like to read a set of Term Codes and Dates into an array and then reference that anywhere in the program. Currently, the ARRAY statement and reference works only within the SAME Data Step. Such that TermCode[1] = 2013-1, TermCode[2] = 2013-2, TermCode[3] = 2013-3...........etc and         TermDate[1]= 19183, TermDate[2]=19274 ...........etc (SAS DATES). So later in the program (about 20 data steps), I can say for TCidx = 2     ChkDate = TermDate[TCidx]; now I just get ERROR: Undeclared array referenced: TermDate. Any suggestions on creating GLOBAL variable that is an array. Thanks ... View more