I was working on a dataset in SAS and I want to filter out data based on date. So right I am using this as a code. data want; set have; where ('09JAN2023'd <= DATE_OF_APPROVAL <= '10JAN2023'd); run; Now, I want to use today as a function to do the above task so that everyday when I run code it takes the below logic.   data want; set have; where ((today()-2) <= DATE_OF_APPROVAL <= (today()-1)); run; (the logic is based on today's date like if today is 11JAN2023 it should bring date of 09JAN2023 and 10JAN2023). I just want guidance in approaching this problem. Is this possible somehow in SAS. Please, help!!   Thanks   ... View more

Can someone guide me how can I achieve the desired result. I was working on a Code as below: proc freq data=final; tables EMP_CODE*DATE_OF_APPROVAL/nopercent nocum norow nocol; run; What should I do to get the below exact result as a table output? When I am using the code below proc freq data=final; tables EMP_CODE*DATE_OF_APPROVAL/nocum norow nocol nopercent out=table_out_result; run; The result is not like the result of proc freq         ... View more

I am working on a data similar to this And the data I want should be like as below: I want to count number of emails approved on the date. Can someone guide how should I approach this problem. ... View more

I was working on a data where I want to have a summary of the data using proc summary. The sample data as below. Now what I want is how many email ids that emp_code has...Something like below Can someone help how can I achieve this...........Thank you in advance for all the contributors. ... View more

I was working on a data where a table has 3 columns in which some of the column values are missing for example:  Now, I want to achieve something like this. Where LC_CODE is not provided we pick from LG_CODE and if LG_CODE is not provided we pick from referral code. And if we don't have any values for any of the columns we just leave it as blank. So the desired output should be something like this as below   Something LIKE this  Data FIN_EMP_CODE; set MR7; FIN_EMP_CODE = ; if('LC Code'.MR7 NE . then 'LC Code'N = FIN_EMP_CODE); else if ('LG Code'.MR7 NE . then 'LG Code'N = FIN_EMP_CODE); else ('Referal Code'N.MR7 NE . then 'Referal Code'N = FIN_EMP_CODE); run; Can someone suggest what should I do to achieve this. Please, HELP!!! ... View more