cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sanjaymane7
‎07-05-2025
  • 30 Posts
  • 13 Likes Given
  • 0 Solutions
  • 0 Likes Received

Query for Merge/ Update

by Obsidian | Level 7 in SAS Programming
‎03-17-2021 02:58 AM
‎03-17-2021 02:58 AM
Hi, I am merging two tables, but blank variables are not being updated in dataset. Example - Month and Policy etc. Please help in this. My Code – data table_C;  merge test.table_a (in=a) test.table_b (in=b);  by Policy_No;  if a;  run;   Table_A Month Policy_No Insured_Name Apr-2020 110522023120027725 SHYAM LAL YADAV     SHYAM LAL YADAV     SHYAM LAL YADAV Apr-2020 920222023120620551 SAHIL GUPTA     SAHIL GUPTA     SAHIL GUPTA Apr-2020 920222023120658066 MANOJ KUMAR     MANOJ KUMAR     MANOJ KUMAR Apr-2020 200122028170000374 RAVI VERMA Apr-2020 200122028170000374 RAVI VERMA Apr-2020 200122028170000374 RAVI VERMA   Table_B Month Policy_No BusinessTypeActual Apr-2020 110522023120027725 RollOver Apr-2020 920222023120620551 RollOver Apr-2020 920222023120658066 RollOver Apr-2020 200122028170000374 Fresh Business   Expecting output= Month Policy_No Insured_Name BusinessTypeActual Apr-2020 110522023120027725 SHYAM LAL YADAV RollOver Apr-2020 110522023120027725 SHYAM LAL YADAV RollOver Apr-2020 110522023120027725 SHYAM LAL YADAV RollOver Apr-2020 920222023120620551 SAHIL GUPTA RollOver Apr-2020 920222023120620551 SAHIL GUPTA RollOver Apr-2020 920222023120620551 SAHIL GUPTA RollOver Apr-2020 920222023120658066 MANOJ KUMAR RollOver Apr-2020 920222023120658066 MANOJ KUMAR RollOver Apr-2020 920222023120658066 MANOJ KUMAR RollOver Apr-2020 200122028170000374 RAVI VERMA Fresh Business Apr-2020 200122028170000374 RAVI VERMA Fresh Business Apr-2020 200122028170000374 RAVI VERMA Fresh Business   ... View more

How to avoid duplicate records while join table

by Obsidian | Level 7 in New SAS User
‎02-18-2021 07:29 AM
‎02-18-2021 07:29 AM
Hi,   I am trying to merge three data sets. First data have 1 record, second data have 2 records and third data set have 4 records. While merging records, duplicate values gets copied in left data set. Please suggest how to avoid duplicate values Example – Data1 TransactionId Premium ICM_DEC_20_718256 1000000   Data2 TransactionId Comm% Commission ICM_DEC_20_718256 10 100000 ICM_DEC_20_718256 7.5 75000   Data3 TransactionId Rwd % Reward Commission ICM_DEC_20_718256 10 100000 ICM_DEC_20_718256 7.5 75000 ICM_DEC_20_718256 5 3000 ICM_DEC_20_718256 2 10000   Syntax - Data want; Set data1 (in=a) data2 (in=b) data3 (in=c); By TransanctionId; If a; Run;   output - TransactionId Premium Comm % Commission Rwd % Reward ICM_DEC_20_718256 1000000.00 10.00 100000.00 10 100000 ICM_DEC_20_718256 1000000.00 7.50 75000.00 7.5 75000 ICM_DEC_20_718256 1000000.00 7.50 75000.00 5 3000 ICM_DEC_20_718256 1000000.00 7.50 75000.00 2 10000   I don't want duplicate values in premium, comm % and commission variables.   ... View more

Transpose Query

by Obsidian | Level 7 in New SAS User
‎12-22-2020 05:23 AM
‎12-22-2020 05:23 AM
I want to transpose below table – Data set - have Month Policy_Number IRDA_Amt OpsRefNo Nov-2020 XYZ 1000 20201005-M Nov-2020 XYZ 500 20201015-A Nov-2020 XYZ 100 20201222-A   Output (Want) - Policy_Number IRDA_Amt1 RefNo1 IRDA_Amt2 RefNo2 IRDA_Amt3 RefNo3 XYZ 1000 20201005-M 500 20201015-A 100 20201222-A   My Code –   proc transpose data=have out=want (Drop=_Name_ _LABEL_) prefix=irdaamt prefix=refno; var IRDA_Amt OpsRefNo; by Policy_Number;   run;   I am not getting output in desire amount. Please suggest ... View more

dynamic queries

by Obsidian | Level 7 in New SAS User
‎05-25-2020 05:41 AM
‎05-25-2020 05:41 AM
Hi, I have excel file of intermediary code who does insurance business and want to give commission as per their business amount, location, product, channel, make and model. I have already made query for individual intermediary code basis of if condition and it’s working fine. Now, list is increased by 2000 records and very difficult to right individual query to each intermediary code. I am trying through CATX function which is also not manageable after certain limit as combination is being increased day by day. I want to learn dynamic query. Please share any demonstration video and inform about it. Also, sharing an example SAS table for your reference.   IMD_Code Location Product Make Model Business Channel Commission % 1234             10 1235 Mumbai           5 1236 Pune Pvt         7 1237 Delhi Pvt Maruti Alto     12 1238 Delhi Pvt Maruti All > 100000   19.5 1239 Mumbai Pvt       Motor PC 19.5 1240 Mumbai Tw       Motor TW 22.5 ... View more

Re: PROC SUMMARY DATA

by Obsidian | Level 7 in New SAS User
‎01-22-2020 07:20 AM
‎01-22-2020 07:20 AM
Thank you so much 🙂 ... View more

PROC SUMMARY DATA

by Obsidian | Level 7 in New SAS User
‎01-22-2020 04:58 AM
‎01-22-2020 04:58 AM
Hi, I am using proc summary data statement where I don't want '_FREQ_ ','_TYPE_' and 'Total' (Blank) in output/ result.   received below result from SAS     TransactionId _FRQ_ _TYPE_ COMMISSION                            100 A1234 0 1                        80 B1234 0 1                        20   Want result as per below    TransactionId COMMISSION A1234                        80 B1234                        20   ... View more

Re: query for tabel and sumif

by Obsidian | Level 7 in SAS Programming
‎11-23-2019 01:42 PM
‎11-23-2019 01:42 PM
Thank you. It works ... View more

query for tabel and sumif

by Obsidian | Level 7 in SAS Programming
‎11-23-2019 05:12 AM
‎11-23-2019 05:12 AM
Hi, I have data set where I want to sum of premium for particular Agent_Id and want to update incentive percentage as per their sum of premium amount.   Example - If agent id ='14524' sum of premium = 50000 than Percentage = 10; else if agent id='17116' sum of premium  greater 50000 and less than 100000 then 12; else percentage=0; run;   data set = Agent_Id Premium 1633655    800,000 1633655    400,000 12529    200,000 12529    100,000 17116      50,000 17116      25,000 14524      10,000 14524      10,000 14524      20,000   want result as per below   Agent_Id Premium Sum Of Premium Percentage 1633655    800,000 1200000   1633655    400,000 1200000   12529    200,000 300000   12529    100,000 300000   17116      50,000 75000 12 17116      25,000 75000 12 14524      10,000 40000 10 14524      10,000 40000 10 14524      20,000 40000 10 ... View more

Re: Query for Selecting Content

by Obsidian | Level 7 in New SAS User
‎11-17-2019 09:40 AM
‎11-17-2019 09:40 AM
Hi, It works. Thank you so much ... View more

Re: Query for Selecting Content

by Obsidian | Level 7 in New SAS User
‎11-15-2019 02:19 PM
‎11-15-2019 02:19 PM
Thanks. After this filter, I want write as 'broker' in another column/ variable. ... View more

Re: Query for Selecting Content

by Obsidian | Level 7 in New SAS User
‎11-15-2019 01:02 PM
‎11-15-2019 01:02 PM
I have 14 lakh observations in above dataset. Want to select content 'BRG' from Id and update category accordingly ... View more

Query for Selecting Content

by Obsidian | Level 7 in New SAS User
‎11-15-2019 11:52 AM
‎11-15-2019 11:52 AM
Hi,   I have data set and want to select particular contents from variables and want to update desire value in another variable.    Example-   data test; input id category cards; 11BRG234 12IMF456 run;    expecting below result in data   Id                 Category 11BRG234   Broker 12IMF456    Agent   Please suggest ... View more

Re: Date format required

by Obsidian | Level 7 in New SAS User
‎11-10-2019 07:38 AM
‎11-10-2019 07:38 AM
Hi, It's correct code but didn't work on my data. Then, I used mdyampm25. and it's worked.   Thanks for help ... View more

Re: Date format required

by Obsidian | Level 7 in New SAS User
‎10-21-2019 10:18 AM
‎10-21-2019 10:18 AM
Hi, Not working this. I am trying to import csv file through infile statement. In file, date is available in mm/dd/yyyy hr:mm:ss AM/PM. File gets imported but date is appearing blank due to incorrect date format. I need correct informat and format date format. I tried DATEAMPMw.d but error is showing that "Invalid variable specification, DATEAMPMw.d. Variable name of the form X.X must be either First.X or Last X. The name DAT ... View more

Date format required

by Obsidian | Level 7 in New SAS User
‎10-21-2019 07:42 AM
‎10-21-2019 07:42 AM
Hi, I want to create a new dataset wherein date format is in mmddyyyy hr mm ss am/pm. Pls share me informat and format code for date. I already tried datetime18. And datetime19. But not worked. Thanks in advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-05-2025 11:57 AM
Likes given to
Quick links