Dear experts. I have a requirement to create a new variable to use it in my proc report to do the alignment as per data the requirement is I want to create pnum variable  to get each test in one page in the report (i.e in one page different tests should not come) but in one page it can accommodate only 5 records .So that Iam creating pnum for first 5 test as 1 and next till the end of same test should be 2 .  same like for the next test "urin" first 5 is 3 and the rest is 4   like that i have so many tests ..   So if i create a variable like this I can use that in the report as page break  x  test    r  pnum 1 blood 1   1 1 blood 2   1 1 blood 3   1 1 blood 4   1 1 blood 5   1 1 blood 6   2 1 blood 7   2 1 blood 8   2 2 urin   9   3 2 urin 10   3 2 urin 11   3 2 urin 12   3 2 urin 13   3 2 urin 14   4   ... View more

Hi I want to convert multiple variables in iso to DD-MMM-YYYY (18JUNE2018). it also have partial dates for some date values  is there any method to do that? ... View more

Hi Experts,   I have a data set and usually it will have variables Type1 Type2 Type3, but unfortunately this time there is no variables like that, so now if i am working on the below    if Type1 = "1" then label= "Type1"; else label= "NA"; f Type1 = "2" then label= "Type2"; else label= "NA";   etc....   so this time I am getting un initialized  note, is there any way to avoid this? Need and needs this to run in future also with out any changes if the variable added next delivery by the data team.       ... View more

Dear experts ,   I need to round the value 4.7619047619 to 4.8 , I used  round(Percent1,1.0); and also tried with ceil function .   but I am getting the value 5 instead of 4.8   is there any simple technique to tackle this simple problem.   Regards,   ambadi007 ... View more

Hi Team,   I have to convert a variable in to numeric , but I am getting a warning "Invalid argument to function Input"   I have used var1=input(var,best.);   The variable contains data like below   3 4 non-reactive 5 non-reactive 6 7 etc....   the warning is coming for the non-reactive. how to handle this to make this in to numeric  ... View more