Could someone please help me with this problem.  I am trying to create a macro variable in the format yymm using the following code- however the code seems to ignore the z format for the month portion of the code. I keep getting 162 instead of 1602  What am I missing here?  Please advise.   %macro getdates (currdate); %if %eval("&currdate"d > %sysfunc(intnx(week.6, %sysfunc(intnx(month, "&currdate"d,0,E)),0))) %then %do; %let C_ME=%eval(%sysfunc(intnx(week.6, %sysfunc(intnx(month, "&currdate"d,1,E)),0))); %end; %else %do; %let C_ME=%eval(%sysfunc(intnx(week.6, %sysfunc(intnx(month, "&currdate"d,0,E)),0))); %end; %put %sysfunc(putn(&C_ME,date9.)); %let mth=%sysfunc(cats(%substr(%sysfunc(putn(%sysfunc(year(&C_ME)),4.)),3,2),%sysfunc(putn(%sysfunc(month(&C_ME)),Z2.)))); %put &mth; %mend; %getdates(26Feb2016);   ... View more

I am trying to create a macro variable that will contain the prior year and same month based on a current date. For example if the current date is 30MAY2014 I wiould like to get 1305.  However I keep getting an error with the following : %let medate=30MAY2014; %Let Prior_Year=%sysfunc(cats(%substr(putc(%Sysfunc(year("&medate"d)),4.),3,2)-1,putc(%sysfunc(month("&medate"d)),z2.))); The error I am getting is the following: ERROR: Required operator not found in expression: putc(5,z2.) I would really appreciate any suggestions on how I can fix this. ... View more

Does anyone have any thoughts on how I might accomplish the following: I have a dataset with the following variables: ID Assets0908 Assets0909 assets0910 Month1 month2 month3 1 $109 $200 $150 0909 0910 0911 2 $40 $20 $10 0908 0909 0910 I would like to sum variables Assets0909, Assets0910, Assets0910 based on the values in Month1-3. For example if month was 0908 then the month1_Assets would be the sum of Assets0908 and so on. Please note that the values in month1-3 are character.. Is there a quick way to do this? I would welcome any insights. ... View more

Does anyone have any thoughts on how I might be able to automate the below list of macro variables. Mth1 changes every month and the format of the mth varaibles need to the same yymm-1004, 1005 etc. I would greatly appreciate any ideas. rsubmit; %let mth1 = 1004; %let mth2 = 1003; %let mth3 = 1002; %let mth4 = 1001; %let mth5 = 0912; %let mth6 = 0911; %let mth7 = 0910; %let mth8 = 0909; %let mth9 = 0908; %let mth10 = 0907; %let mth11 = 0906; %let mth12 = 0905; endrsubmit; ... View more

Hoping someone can help me with the following problem: I have dataset that contains the SSNs of sales agents who are linked to other agents. For example the dataset looks like this: VAR1 VAR2 VAR3 VAR4 VAR5 ssn1 ssn3 ssn5 ssn6 ssn20 ssn2 ssn3 ssn5 ssn3 ssn1 ssn1 ssn5 ssn20 ssn4 ssn5 ssn3 ssn1 ssn6 ssn20 and so on. I need to create flags that uniquely identify the distinct combinations. I am stumped and not sure where to begin - does anyone have any thoughts on how this problem can be addresses. Any thoughts would be greatly appreciated! ... View more