proc sort data=delq_array; by application app_month perf_month; run;
data want; set delq_array ; by application app_month perf_month; length string $60; retain string; string=compress(catx('',string,delq)); if last.application then do; output; call missing(string); end; run;
the aove program currently appends delq column data and outputs based on last.application. But i need to append '.' if there is missing performance based on perf_month column by application.
indata is attached. please help me on the logic
current output
Application
App_month
Perf_month
string
1
1-Sep-15
1-Sep-17
000112345211000000000000
2
1-Sep-15
1-Jul-17
0001123452000000000
3
1-Sep-15
1-Jan-16
00
required output
Application
App_month
Perf_month
string
1
1-Sep-15
1-Sep-17
000112345211000000000000
2
1-Sep-15
1-Jul-17
0001123452..0.00000000
3
1-Sep-15
1-Jan-16
.0.0
... View more
i am trying to implement first. and last. logic SAS DI. But this should not be done using user written code option. This should be carried out using SAS DI tools/options. Please let me know if it possible or provide me a link when i can go through.
... View more
data available not_available;
merge _temp1 (in=a) _temp2 (in=b); /* One - To - One Join*/
by x;
if a then output available;
if manager = '' then output not_available;
run;
in the above code, i am pulling information from _temp2 like manager, project details to _temp1 based on my common variable x.
so dataset "available" will have all the observations coming from _temp1 based on "if" filter. the second dataset "not available" will have observations if my mangager details are missing in "available" dataset.
if by chance, if the values are present in "not_available" dataset then sas should stop executing. it should display a message in editor window that "Manager details are missing. Please check".
Please help me on this, is there any way i can pop up messages in editor window
... View more
I am trying to find out server utilization at a directory level. Total space is 100 GB. It is allocated to two levels equally and the rest of the sub-directories share the allocated space based on the usage. I got the directories usage how much space is used. But when I sum it up at the last level it won't add up to 100GB because for some directories, users haven't created sub-folders. So I need to go back and add it to know how much is used.
Input file is attached. Raw data is residing from column A to Column C and the output which i am looking for is available from column F- Column H.
It will be great if some one assit me.
... View more
I am trying to find out server utilization at a directory level. Total space is 100 GB. It is allocated to two levels equally and the rest of the sub-directories share the allocated space based on the usage. I got the directories usage how much space is used. But when I sum it up at the last level it won't add up to 100GB because for some directories, users haven't created sub-folders. So I need to go back and add it to know how much is used.
Input file is attached. Raw data is residing from column A to Column C and the output which i am looking for is available from column F- Column H.
It will be great if some one assit me.
... View more
Hi I have a dataset "Products" which has a variable "Prod". This variable has got values
A
A B
Z
Z
C
C
Z
Z
Whenever Z value comes up, like in this case Z has come up 4th observation, so it has to retain preceding value (B) and then again 5th observation is Z, since 4th obs has been replaced the 5th obs has also to be replaced with prior observation. When ever Z pops up it has to take preceding value
so the output is
A
A
B
B
C
C
C
C
... View more
sorry for the confusion from my side. I am using Base SAS 9.4., I just shared a sample of the dataset in an excel file which has got two tabs. 'Input' and 'Output' tab. I need to use the data which is in INPUT tab to just derive a variable 'Total_Due_Last_4_Mnths' based on the values that are available in A_20151201. If the value is 11/1/2015, I need to sum the last 3monts along with Nov month. Here is an example. Sum( Total_Due_201511, Total_Due_201510, Total_Due_201509, Total_Due_201508). I have given the same in OUTPUT tab for reference by color coding. I just need to derive the variable. The output should be same as is how its in the output tab. I have attached the file again.
... View more
Hi Thank you for the support. But I am not getting the output desired. I need to load the data as is how it its in the INPUT tab..the output is in the output tab. But in the output tab..i am deriving a column total_due_last_4_months based on a_20151201. This column has got values. Based on the value that is available i need to calculate last 4monhts total due by summing it up. the layout of output how i am looking is in output tab
... View more
Hi. .I need to load the data as is how it its in the INPUT tab..the output is in the output tab. But in the output tab..i am deriving a column total_due_last_4_months based on a_20151201. This column has got values. Based on the value that is available i need to calculate last 4monhts total due by summing it up. the layout of output how i am looking is in output tab.
... View more
I have attached the sample data for the query I am looking for. I am deriving a column 'Total_Due_Last_4_Months' based on column A_20151201. If the year is 2015 and month is 11 in the column 'A_20151201' then i need to sum last 3 months along with 11 month as well. It will like sum(total_due_201511,total_due_201510,total_due_201509,total_due_201509). If the month is 10 then it is sum(total_due_201510,total_due_201509,total_due_201508,total_due_201507). I want it in a loop.
... View more
Hi..In the sample data each row is distinct for a customer..so customer 1 has a product A which is active for 3 months and then it was cancelled so a flag has to be raised as active_cancel = 1 and again he reactivated it so cancel_reactivate = 1. customer 2 with the same product A in the second row first its showing as Unknown and then it was reactivated so unknown_reactivate = 1.
please let me know if you need any details.
thanks for the support
... View more
Hi Team..could you please help me in building the logic. I have attached the sample file which is having sample input and the output i am looking for
... View more
