Hi,   I need help in converting the below line of oracle code into sas proc sql... your help will be highly appreciated..please note that n01 is column name   decode(nvl(n01,-99),-99,'V0','V01') as "tax code"     ... View more

I have two tables, users table and leave table which stores all the information for the user who have captured leave.  I need help in adding people who did not apply leave in table Leave_new with 0 value under  leave_days column      data users; input users $50.; datalines; Andrew Lup Dan Louis Mike Mora Farren Farrao Joseph Mia ; run; data leave; input calender_month leave_days leave_type_code username $50.; datalines; 202101 1 2 Andrew Lup 202101 1 2 Andrew Lup 202101 1 2 Sol Sebe 202001 1 2 Ant Joe 202101 1 2 Dan Louis 202101 1 2 Mike Mora 202101 1 2 Mike Mora 202101 1 2 Mike Mora 202101 1 2 Mike Mora ; proc sql; create table Leave_new as select distinct a.username, a.calender_month, sum(a.leave_days) as leave_days from have as a where a.username in (select users from users) group by 1,2 ;quit; Data Want username calender_month leave_days Andrew Lup 202101 2 Dan Louis 202101 1 Farren Farrao 202101 0 Joseph Mia 202101 0 Mike Mora 202101 4 ... View more

Hi ,   I need help in created a new column named 'userid' from usersname column     data Users; input Users $20.; datalines; sol sebela jack mabaso ally maima marry anne jin sol ; run;       data have; input policy_no risk contents motor home cycle username $20.; datalines; 1 1 0 1 0 0 sol sebela 2 0 0 0 0 1 jack mabaso 3 0 1 1 2 1 ally maima 4 1 0 0 0 0 marry anne 5 1 0 0 0 1 jin sol 6 0 1 1 2 0 sin bad 7 1 0 0 2 1 ole man 8 1 2 0 1 0 kim kad ;   proc sql;       create table data as select a.* from have as a where a.username in (select users from users) ;quit;                                                                             DATA WANT policy_no risk contents motor home cycle userid username 1 1 0 1 0 0 ssebela sol sebela 2 0 0 0 0 1 jmabaso jack mabaso 3 0 1 1 2 1 amaima ally maima 4 1 0 0 0 0 manne marry anne 5 1 0 0 0 1 jsol jin sol     ... View more

Hi, i need help in creating a new column which will be used to assign scores based on the  below bands: if qa_score < 90 then Score = 0 if qa_score >= 90 and qa_score < 92.5 then Score = 0.04 if qa_score >= 92.5 and qa_score < 95 then Score = 0.08 if qa_score >= 95 and qa_score < 97.5 then Score = 0.12 if qa_score >= 97.5 and qa_score < 100 then Score = 0.16 if qa_score = 100 then Score = 0.20   data have; input policy_no QA_score; datalines; 1 88 2 91 3 94 4 96 5 99 6 100 ;  data WANT policy_no   Score 1                0 2                0.04 3                0.08 4                0.12 5                0.16 6                0.20 ... View more

Hi I need help in extracting only policies whereby there is a value greater than or equals 1 from either contents/ motor/ home columns..if all the values from  contents/ motor/ home columns are 0, then delete the entire row..   see below code for data have data have; input policy_no risk contents motor home cycle; datalines; 1 1 0 1 0 0 2 0 0 0 0 1 3 0 1 1 2 1 4 1 0 0 0 0 5 1 0 0 0 1 6 0 1 1 2 0 ;   Data Want policy_no   risk  contents  motor   home   cycle 1                1        0             1          0           0 3                0        1             1          2           1    6                0        1             1          2           0 ... View more