I want to update the ir.INSURANCE_CF dataset which should have the value for the variable INSURANCE_CONTRACT_GROUP_ID per the below calculation. With the below code I could only recreate the ir.INSURANCE_CF dataset  whereas I was asked to only update the dataset.   Is there a way that we can tweak the code below to update the original dataset instead of recreating the same?   ... View more

I would like to know how to use the variable which was created in proc SQL in the same step for join. Please guide me to resolve this issue. Intention of this step is to complete it in one step.     Log:     ... View more

I have table in SQL server and I have one SAS WORK data set. Both are similar structure with same data type. Now I would like to know the different ways to insert SAS dataset observation in SQL table from SAS. Is below code the right way to insert records in SQL server table? e.g. Proc append data=sqllibrary.table data=sas_work_dataset force; Run; ... View more

I'm trying to compare the strings using strip function and that is not doing the comparison as I except. IMO or in terms of project, value 253.3 or 253.30 or 253.0000000000 should be equal. However the following SAS code says it is not equal. I'm OK if the string is converted to numeric while we do the comparison in the following code but the condition is I have to preserve the format numx18.10. Right now the following comparison is not equal but I want it to resolve it as equal. If strip('253.3') ne strip(put(input('253.3',numx18.10),numx18.10)) then num_error=1; ... View more

I have to create multiple dynamic files based one single file which has employee id, reporting date and other variables. If the file has 10 different employee ids and reporting date then it should create 10 files. As is : Emp_ID reporting_dt idv 100000 17mar2019 31 100001 21may2018 36 100000 17mar2019 32 To be: File1 should have Emp_id reporting_dt idv 100000 17mar2019 31 100000 17mar2019 32 File 2 should have Emp_id reporting_dt idv 100001 21may2018 36 ... View more

Assume I have four grid nodes and jobs are running in all those grid nodes. Now if I wish to find the process id, user id,...for each node how can I find it? ... View more

Could you please help me understand to uninstall the hotfix? Also how should I find which hotfix should I apply for my environment? Assume I'm in SAS EG 7.2 then how can I find the hotfix for my environment? ... View more