About Jagadishkatam

Jagadishkatam · ‎08-28-2019

I am assuming that the Cat_Obligo=put(Obligo,ffmt.); is alreadu created in Rawdata2, so in the same dataset I am creating a new variable Obligo2 only for sorting. Then i am using that in proc report. data RawData2 ; set RawData2 ; Obligo2=Obligo ; run; PROC REPORT DATA=RawData2 NOWINDOWS; COLUMN Obligo2 ('Group of Obligo' Cat_Obligo ) mon,(Obligo allowance Obligo=N_Customers); DEFINE Obligo2 / noprint order order=data; DEFINE Cat_Obligo / '' GROUP order=internal ; DEFINE mon/ '' ACROSS NOZERO ORDER=INTERNAL; DEFINE Obligo / SUM 'Sum_OBLIGO' FORMAT=comma12.1 ; DEFINE allowance / SUM 'Sum_Allowance' FORMAT=comma12.1 ; DEFINE N_Customers /N 'Customers' FORMAT=comma18.; ; RUN;

Jagadishkatam · ‎08-28-2019

Could you please try the below code, we do not need to name the new variable as INSURANCE_CONTRACT_GROUP_ID _NEW, instead use the same existing name INSURANCE_CONTRACT_GROUP_ID proc sql; create table ir.INSURANCE_CF as select a.*, b.INITIAL_RECOGNITION_DT, compress(cats(a.INSURANCE_CONTRACT_GROUP_ID,put(a.ISSUE_DT,date9.),put(b.INITIAL_RECOGNITION_DT,date9.)),'.') as INSURANCE_CONTRACT_GROUP_ID length=72 from IFRSLDIS.INSURANCE_CASHFLOW as a left join IFRSLDIS.ADP_OUTPUT_NON_LIFE as b on a.REPORTING_DT = b.REPORTING_DT and a.ENTITY_ID = b.UNIT and cats(substr(put(ISSUE_DT,yymmn6.),1,4),"-",substr(put(ISSUE_DT,yymmn6.),5)) = b.ISSUE_MONTH ; quit;

Jagadishkatam · ‎08-28-2019

Alternatively proc sql; create table want as select id, gestage from test group by id having sum(gestage=. or gestage <=20 or gestage >=43)=0 ; quit;

Jagadishkatam · ‎08-28-2019

The problem is you are not using the order in Obligo variable, please try the below code, Here i created a copy of Obligo as Obligo2 which i used in the begining of the all variables in column statement of proc report and order it. Please test and let us know. data RawData2 ; set RawData2 ; Obligo2=Obligo ; run; PROC REPORT DATA=RawData2 NOWINDOWS; COLUMN Obligo2 ('Group of Obligo' Cat_Obligo ) mon,(Obligo allowance Obligo=N_Customers); DEFINE Obligo2 / noprint order order=data; DEFINE Cat_Obligo / '' GROUP order=internal ; DEFINE mon/ '' ACROSS NOZERO ORDER=INTERNAL; DEFINE Obligo / SUM 'Sum_OBLIGO' FORMAT=comma12.1 ; DEFINE allowance / SUM 'Sum_Allowance' FORMAT=comma12.1 ; DEFINE N_Customers /N 'Customers' FORMAT=comma18.; ; RUN;

Jagadishkatam · ‎08-27-2019

please try below code data have; input Policy_No From_Date:date9. To_Date:date9. Amount Ind$; format From_Date To_Date date9.; cards; 10864457 08Nov2013 08May2014 29.93 Pos 10864457 08May2014 08Nov2014 28.43 Pos 10864457 08Nov2014 08May2015 28.43 Pos 10864457 08May2015 08Nov2015 29.91 Pos 10864457 08Nov2015 08May2016 26.91 Pos 10864457 05Jan2016 08May2016 -18.39 Neg 10988488 23Sep2013 23Sep2014 63.89 Pos 11295729 04Dec2015 04Jun2016 38.69 Pos 11295729 10Feb2016 19Feb2016 -1.94 Neg 11295729 19Feb2016 04Jun2016 -22.56 Neg ; proc sql; create table neg as select Policy_No, min(From_Date) as From_Date2 format=date9., sum(amount) as amount2 from have where lowcase(ind)='neg' group by Policy_No; quit; data want; merge have(in=a where=(ind='Pos')) neg(in=b); by Policy_No; if a and b and last.Policy_No then do; To_Date=From_Date2; amount=amount-abs(amount2); end; drop amount2 From_Date2; run;

Jagadishkatam · ‎08-27-2019

I believe you should use the calculated with having in proc sql, so please try this below untested code proc sql; create table temp3 as select cats(substr(put(a.ISSUE_DT,yymmn6.),1,4),"-",substr(put(a.ISSUE_DT,yymmn6.),5)) as ISSUE_MONTH_INS_CA_FL,a.*,b.INITIAL_DT from INSURANCE_CASHFLOW_updated2 as a left join ADP_OUTPUT_NON_LIFE as b on a.REPORTING_DT=b.REPORTING_DT and a.ENTITY_ID=b.UNIT having calculated ISSUE_MONTH_INS_CA_FL=b.ISSUE_MONTH and a.REPORTING_CAUSE="ACT"; quit;

Jagadishkatam · ‎08-27-2019

You can something like below, consider that the code is within the macro sample, this is an untested code %macro sample; %global variable1; %let variable1=go; %if &variable1=go %then %do; filename mail email to='xxxxx@xxxx.com'; data _null_; file mail; put 'Hi'; run; %end; %mend sample; %sample

Jagadishkatam · ‎08-26-2019

Please try the below code data WORK.IND; input START :DATE9. END :DATE9. UID:$200. ED:32.; format start end date9.; datalines4; 30MAR2016 31MAR2016 S110 5 01APR2016 02APR2016 S110 10 03APR2016 04APR2016 S110 15 05APR2016 17APR2016 S110 20 18APR2016 18APR2016 S110 0 25APR2016 25APR2016 S110 0 18MAY2016 18MAY2016 S110 0 23MAY2016 24MAY2016 S110 0 ;;;; data want; set ind; if _n_ ne 1 and lag(end)+1 ne start then flag=1; starts = lag(end)+1; ends=start-1; output; start=starts; end=ends; format starts ends date9.; if flag=1 then do; ED=20; output; end; drop starts ends flag; run; proc sort data=want; by start end; run;

Jagadishkatam · ‎08-23-2019

Please try the below code proc sort data=have; by id side indate; run; proc transpose data=have out=want1 prefix=indate; by id side; var indate; run; proc transpose data=have out=want2 prefix=isolate; by id side; var isolate; run; data want; merge want1(in=a) want2(in=b); by id side; run;

Jagadishkatam · ‎08-22-2019

Could you please share an example of the issue you are facing along with the expected output to get better response.

Jagadishkatam · ‎08-20-2019

Thank you @PaigeMiller, I agree it should be quit

Jagadishkatam · ‎08-20-2019

did you observe any error in the log

Jagadishkatam · ‎08-20-2019

Please try the below untested code proc sql; delete from ismecorp.SMB_Model_Mart where model_id ='128' and input(month_id,best.) < (intck('month','01jan1990'd,today())-3); run;

Jagadishkatam · ‎08-20-2019

Could you please check the path again. I believe this is not the correct path, could you share the screenshot of the actual path \\path\Report.xlsx

Jagadishkatam · ‎08-19-2019

Please try the below code Data ex1; Name="&&&state&I.&&i" ; Run;

Re: 2023 Customer Awards: WCG Clinical Endpoint Solutions - Visual Sto...

Re: next date as end date by subject

Re: next date as end date by subject

Re: Fill in missing IDs

Re: Help with charts - clustered bar graph (?)

Re: SGplot x axis ticks without lumping or losing data

Re: Proc transpose help

Re: Remove x axis percent values in proc sgplot

Re: defining before and after dates using changing dates

Re: unending lines in the series plot of proc template

Re: Remove x axis percent values in proc sgplot

Re: How to remove words in a column by another column values

Re: Assign values to a new var by 1st valid value of another var for a...

Re: Unicode for superscript b

Re: remove words from string if the word length is lower than 4

Re: SAS advanced Guide Chapter 1 quiz Q7

Re: Extract VARIABLE NAME and concatenate with other variable names ba...

Re: How to find the week number of a month?

Re: How to find the week number of a month?

Re: Removing quotation marks

Re: Proc Report with across and group, order of group varaible

Re: Update table in proc sql

Re: How to remove a group of observations based on conditions

Re: Proc Report with across and group, order of group varaible

Re: Data manipulation based on values in base SAS

Re: CALCULATED references in the immediate query

Re: Conditional sending of email via sas

Re: how to insert continous dates if there is any gap

Re: transposing data wide to long with multiple observations per subje...

Re: Why can't I add an abbreviation?

Re: Aritmetic with Data and String issue

Re: Aritmetic with Data and String issue

Re: Aritmetic with Data and String issue

Re: send an email from SAS and attach a file

Re: How resolve macro variable