Table1 Id mnth1 mnth2 mnth3 mnth4 mnth5 mnth6 1. Apr20 may20 jun20 jul20 aug20 sep20 Table2 Id mnth vol 1 apr20 12 Table3 Id mnth vol 1 may20 15 Similar for other mnths also I have data Output dataset Id Apr May Jun jul aug sep 1. 12 15 .... If terminal is installed in may then i should get the vol from may Oct
... View more
I have populated the table based on your above code, Installedtid mnth1 mnth2 mnth3 mnth4 mnth5 mnth6 Other tables I have installedtid and mnth1 vol similarly in other tables as well, Now I need to get output table with installedtid mnth1volume mnth2volume mnth3volume mnth4volume mnth5vilume mnth6volume, Even I have volumes of all months in the tables I need to get the volumes of 6mnths only which I have populated months
... View more
In other tables I have the volume of those installed terminals seperately,From Apr 2020 to Nov 2020 I have volumes ,but I need to get the volume for only six months for the months which we have populated,
... View more
Hi thanks for the code,based on that 6months i need to extract the data from seperate tables the table names contain month names,can we do that automatically in the same step,extracting the data month wise for the terminals
... View more
Hi All, I need to develop a logic, scenario given below: I need to get the data of terminals after they have installed of first 6months Example: If a terminal is installed in apr2020 they i need to get the data of Apr May Jun jully aug sep.similarly if terminal is installed in may i need to get data of May Jun jully aug sep oct.this data has to be picked automatically based on terminal installation month. Kindly help me with the logic
... View more
Yes it should be missing,it's my mistake, And the per value will not be the the boundaries of the range values, It may be in between the range1 and range2 Like 23,44.4...in this cases also it should the proper rating The ids also increase up to 10 and the corresponding per and rating. @
... View more
If Id in both tables matches we need to check the per column in the table1 With the range1 and range2 ,accor accord we need to give the rating as defined in table 2
... View more
Help me in getting the below output Table 1 Id Per 1 10 1 20 2 60 1 90 Table 2 Id range1 range2 Rating 1 10 20 1 1 21 40 2 1 41 60 3 2 10 20 1 2 21 60 2 2 61 90 3 Output Id Per rating 1 10 1 1 20 1 2 60 2 1 90 3 Similary I have many IDs and their ranges and rating I need help in coding this with out hardcoding
... View more
<p>Hi,</p> <p> </p> <p>I want to add a row after the rbreak ,please help.me regarding the same</p> <p> </p> <p> </p> <p>Thanks,</p> <p>Rubia.</p>
... View more
While starting DI it is asking to create a new profile,which requires the following details machine,server,port,user ID, password, authentication domain,what will be this fields
... View more
I have installed SAS 9.4 on my local system ,what details I have to fill while creating the SAS profile,I don't have knowledge on that,could you please guide me on that
... View more
Hi , I have installed SAS EG and DI ,while opening DI it is asking to create the profile ,can any one guide how to create the profile. Thanks
... View more
