Thanks @DavidPhillips2, for reporting the response you got from SAS. ... View more

Yes, I agree @ballardw, no macros needed here. ... View more

Since 8.2 is not installed I'm going to try to use BASE SAS on 7.1.  When I try to connect to a library in Enterprise Guide 7.1 it looks like the library is not recognized.  I found documentation to connect to a metadata server from base SAS but not how to connect to a library.  What is the correct libname call?   options metaserver="servername" metaport=8561 /* The port on which the metadata server is listening. */ metauser="xxx" /* The domain-qualified user ID for the connection to *//* the metadata server. */ metapass="xxx" /* Password*/ metaprotocol=bridge /* Protocol for the metadata server. */ metarepository=Foundation; /*this is the line I'm trying to figure out*/ libname mylibname '//servername/Shared Data/VCU/libraryname/Libraries'; ... View more

@DavidPhillips2 wrote: Thanks that solved the issue.  It is odd that missing is required to not produce what seems like a bug. Pretty well documented in the Proc Tabulate syntax for Class statement options MISSING.   Depending on the actual needs for your report you can add a variable that is occasionally missing to create filters in tables by nesting that variable in only some tables.   Another approach would be to add an appropriate variable to contain the "nested" class variables such as with one of the CAT functions. Then the only records not used would be where ALL of the nested variables were missing. I admit that might be odd to read but is an option where the values are pretty obvious. ... View more

@DavidPhillips2 wrote: Thanks, Ballardw oddly the editor did not catch the unbalanced parameters.  This solved the issue though. It isn't an automatic function. You place the cursor on a ( and then with the proper key it should find the match. In the SAS Display Manger that is Ctrl+( or Ctrl+) keys. Hold Ctrl and press either of the ( or ) and the cursor moves to the matching key (and back, doesn't matter which of the () that you use). If it doesn't move then there isn't a match.   Because of the basic approach SAS has to code and especially with the macro language there can't really be a syntax check prior to submission for some forms of missmatched () and/or quotes. ... View more

Madelyn,  Thanks, I'll check with our SAS Administrator to see if we can install that patch. ... View more

Madelyn, I would not have thought of that.  Thank you for your screenshot it was very helpful. ... View more

Reeza,   Thanks for posting, this is what I was looking for.  I'm still figuring proc transpose out so I got stumped with what I had to do before the proc transpose. ... View more

For what it's worth, in VA 8.4 and later the viewer and editor are integrated and it is a single button click to switch in and out of editing mode. Sam ... View more

This will work for the full solution. proc sql; create table temp2 ( acaedemic_period_base varchar(6), year1 num(1), year2 num(1) ); quit; proc sql; insert into temp2(acaedemic_period_base, Year1, Year2) values ('200810', 1, 1); insert into temp2(acaedemic_period_base, Year1, Year2) values ('200710', 1, 1); insert into temp2(acaedemic_period_base, Year1, Year2) values ('200810', 0, 0); insert into temp2(acaedemic_period_base, Year1, Year2) values ('200710', 1, 0); insert into temp2(acaedemic_period_base, Year1, Year2) values ('200810', 1, 1); insert into temp2(acaedemic_period_base, Year1, Year2) values ('200710', 1, 1); quit; data want; set temp2; base_year=input(acaedemic_period_base,4.)-1; array fall [2007:2010] Fall_2007-Fall_2010; fall[base_year+1]=year1; fall[base_year+2]=year2; if Fall_2007 = . then Fall_2008 =0; if Fall_2008 = . then Fall_2008 =0; if Fall_2009 = . then Fall_2009 =0; if Fall_2010 = . then Fall_2010 =0; run; ... View more