Hi, I have a large data set that has country and dates within each country and a value col1. I want to calculate the percentage change between each day and previous day of col1. The first date for each country, the value should be 0.   At moment my code just does difference (diff) If I can get this to work in my code then % should be easy. At moment can't get difference to work correctly.   The code I have looks like this and almost works...   proc sort data=have; by country; run;   data want; set have; by country;   /* this gives me a number 1..n within each country */ if first.country then seq=1; else seq+1;   /* this gives each country a number effectively... prob no necessary */ if seq=1 then counter+1;   /* Here I am hoping that it will give me the difference between current and last record in group */ if not first.country then diff=col1-lag(col1); else diff=0; run;   Where it fails is when there is a 0 in col1 it seems to get the difference between the current record and where there was a value in the col1 last!   Any ideas appreciated!   Thanks   Andrew ... View more

Hi, I have a table of 100,000 customers. I have the month when they started buying from my client. The range of months is 1-200.   What I want to do is break that down into 1/3rd's for example out put might be:   1st 1/3 (33%) of customers bought in months 1->12  2nd 1/3 (33%) of customers bought in months 13->124 3rd 1/3 (33%) of customers bought in months 125->200   I think the solution is to use proc rank but can't seem to get month breaks based on volume of customers.   Make sense?   Thanks   Andrew    ... View more

Hi, We want to send a password from a batch file to be used in a sas prog that actually comes from an Azzure Vault (encrypted key).    The batch file command runs sas, the prog and then we put sysparm at the end:   c:\progs\sas.exe -sysin "test.sas" -sysparm (Passwordstringalphanum)   In a test environment our solution works fine where the password is a mix of alpha and numeric. However, when we use any non alpha/numeric character it fails. eg comma,hash,star,slash etc.   Am pretty sure the issue is the non alpha/num characters in the password.   We have no control over the password so can't suggest passwords are only alpha/num.   Any ideas appreciated!   Thanks   Andrew ... View more