I have a data set with dates, and a product category, and I have a number of rows in the data set which have dates in the future, and so the product column is blank for those, but i'd like to essentially replicate the product data throughout those rows. i.e. sample of my data looks like this now: 12/31/2012 product1 12/31/2012 product2 12/31/2012 product3 12/31/2012 product4 12/31/2012 product5 12/31/2012 product6 12/31/2012 product7 12/31/2012 product8 12/31/2012 product9 12/31/2012 product10 12/31/2012 product11 12/31/2012 product12 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 01/31/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 02/28/2013 And I would like it to look like this: 12/31/2012 product1 12/31/2012 product2 12/31/2012 product3 12/31/2012 product4 12/31/2012 product5 12/31/2012 product6 12/31/2012 product7 12/31/2012 product8 12/31/2012 product9 12/31/2012 product10 12/31/2012 product11 12/31/2012 product12 01/31/2013 product1 01/31/2013 product2 01/31/2013 product3 01/31/2013 product4 01/31/2013 product5 01/31/2013 product6 01/31/2013 product7 01/31/2013 product8 01/31/2013 product9 01/31/2013 product10 01/31/2013 product11 01/31/2013 product12 02/28/2013 product1 02/28/2013 product2 02/28/2013 product3 02/28/2013 product4 02/28/2013 product5 02/28/2013 product6 02/28/2013 product7 02/28/2013 product8 02/28/2013 product9 02/28/2013 product10 02/28/2013 product11 02/28/2013 product12 etc. I thought I could use the lag statement, in a way such as this: data want; set have; if missing(prodcat) then prodcat = lag12(prodcat); run; Since the product categories repeat every 12 observations, but this data step has absolutely no effect on the data set, if i replace the lag function with just a constant string, I see that string populated throughout the rows -- so why doesn't the lag function put the data in properly? Thanks! -Ryan ... View more

Hello all,   I have a large-scale SAS program that I've had completed and functional for quite sometime now. However, I've just transferred to a new computer at work, and after re installing SAS now when I run the program I receive   "An error occurred executing the workspace job 'Exec_AllModels'. SDS Failed to provide the decoder for the data set. Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The data present in the reparse point buffer is invalid. (Exception from HRESULT: 0x80071128"   -I've searched around on Google, and found some people with a similar problem, but not much information or answers provided.   -Also, curiously, the entire program runs and still produces all of the correct output...but I still assume something must be going wrong somewhere and would like to get the issue fixed.   The only thing that has changed from the last error-free run of the program is I am now running SAS from a new computer; however the computer is still a Windows XP 32 bit HP machine -- just with more RAM and a faster CPU. Also I am still using the same version of SAS :SAS 9.2 Enterprise Guide 4.3, and all of the program's code has gone unchanged.   Please let me know any information that you may have.   Thanks! -Ryan ... View more

Hey guys, Ok so I have this code to calculate months between a numeric date range: Example: %let start_month = 200201; %let end_month = 201301; %let second_end_month = 201212; %let start_yr = %eval(&start_month. / 100); %let end_yr = %eval(&end_month. / 100); %let start_mod = %modulo(&start_month.,100); %let end_mod = %modulo(&end_month.,100); %let yr_dif = %eval(&end_yr. - &start_yr.); %let nmonths = %eval(12 * &yr_dif.); %let temp1 = %eval(&nmonths - &start_mod.); %let temp2 = %eval(&temp1 + &end_mod.); %let num_observations = %eval(&temp2 + 1); This is within a macro being called within my program, which sets different date ranges dependent on the current data being processed. When I run this selection of code, it runs fine, and outputs the correct value when I check witha %put statement (133). However When I just run my entire program (which has been operating for some time without error, and this is the only piece of code added since), I receive the error: " ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand        is required. The condition was: 132 - 1; ERROR: The macro SET_PRODUCT_SPECIFICS will stop executing. " I don't understand this error, I don't understand why it is occuring in the same piece of code when run with the entire program, but not when the selection is run alone, also I don't see why "132-1" is not valid input for %eval(). Any help is greatly appreciated. Thanks! -Ryan ... View more