About Aidan

Aidan · ‎07-25-2019

Thank you Patrick, I will test a few bits and let you know how it goes. Much appreciated

Aidan · ‎07-25-2019

Hi there Is it possible to execute a PL/SQL Oracle package on the Database via SAS DI Studio? I know it is possible to execute functions in this manner, however haven't come across an actual PL/SQL package been executed in this manner. If it is possible, would anyone have examples/reference doc's or code snippets to help me achieve this please. A basic call of the package is below; execute package.go(); Thank you Aidan

Aidan · ‎12-07-2018

got it working using this thanks anyway 🙂

Aidan · ‎12-07-2018

Hi there I dont think this will work for me, thanks all the same. I found something below; data _NULL_; set &_INPUT1 end=last; if _n_=1 then call execute('data want; set &_INPUT2; length wordsfound $50;'); call execute('if findw(LOG_NOTES,"'||strip(word)||'") >0 then wordsfound=catx(",",wordsfound,"'||strip(word)||'");'); if last then call execute('run;'); run; This seems to work to some extent but it wont return any value for wordsfound, just set to null

Aidan · ‎12-07-2018

Hi there What I want to do is search for a string within a large text string. So I will have around 100 products for instance. What I need to know is if any of these 100 products appear in a larger text string (which will have a lot of junk text but will have the product name in places) stored in a different table. I am thinking I will need some sort of loop but not certain if their is an easier way to achieve this. Any suggestions or helpful link or examples would be fantastic. Thanks Aidan

Aidan · ‎11-15-2017

A simple data set would contain the below, need to be careful in terms of what I provide here; Col_A EMAIL EMAILCC 123456789 testemail@1234.com testcc@1234.com 987654321 testemail@5678.com testcc@5678.com

Aidan · ‎11-13-2017

Hi there, I have the below code, which works fine to dynamically e-mail a distribution list I have dynamically each day. How would I go about adding a new condition to factor in varying people to CC on the e-mail. I have tried a few things however keep failing in my attempts. I tried adding select distinct EMAILCC into :EMAILCC1- from &DATA; Then applying a CC section to the code, to="&&&EMAILCC&I", if anyone has any guidance it would be great * send mail from DATA; %macro mailit(DATA); %let NOBS=0; * get emails from DATA; proc sql noprint; select distinct EMAIL into :EMAIL1- from &DATA; select count(distinct EMAIL) into :EMAILN from &DATA; quit; * cycle through emails; %do I=1 %to &EMAILN; filename temp email to="&&&EMAIL&I" type="text/html" subject="OP Claims Daily Alert List"; ods html file=temp; proc print data=&DATA noobs; var ALERT; var ALERT_DESC; var ALERT_NAME; var CI_CLAIM_ID; var STDUSR_USER_FULLNAME; var CH_CLAIM_TYPE; var PRIORITY; var GRP_GROUP_NAME; where EMAIL="&&&EMAIL&I"; run; ods html close; %end; %mend mailit; %mailit(W714P7YT);

Aidan · ‎10-19-2017

Thanks both for your input, both work fine for me

Aidan · ‎10-19-2017

Hi there What I am looking to do is dynamically populate an excel file. So below I can get the info per period as per page statement. Ideally I would have an excel file with the periods split into each tab. I have tried a few things with ODS excel but no luck as yet, would anyone know of any code available that I could try and integrate that with my current code? My code is below; PROC TABULATE DATA=CMTEST.A2 ; VAR ARTR_AMOUNT_BILLED; CLASS FREQUENCY / ORDER=UNFORMATTED MISSING; CLASS ADVANCED_HEADING / ORDER=UNFORMATTED MISSING; CLASS AGE_BAND / ORDER=UNFORMATTED MISSING; CLASS PERIOD / ORDER=UNFORMATTED MISSING; TABLE /* PAGE Statement */ all = 'Total' PERIOD , /* ROW Statement */ AGE_BAND=' ' all = 'Total' , /* COLUMN Statement */ ADVANCED_HEADING=' ' *FREQUENCY=' ' *(ARTR_AMOUNT_BILLED=' ' * Sum=' ' ) all = 'Total' *(ARTR_AMOUNT_BILLED=' ' * Sum=' ' ) ; ; RUN;

Aidan · ‎08-22-2017

This looks great Patrick I can work with this now, thanks very much for your quick response

Aidan · ‎08-22-2017

So the below is something that I would have for instance. So item 1 keeps the days to April 2014 Item 2 has 3 for Jun 2014 Item 3 then is spread across more than 1 month Hope this helps. Item Date 1 Days 1 1 22-Apr-14 4 2 11-Jun-14 3 3 27-Feb-14 114

Aidan · ‎08-22-2017

Hi there Don't know if this is feasible in SAS but I know its possible in other tools. If I have a data set and there is 2 dates e.g. 1/Jan/2017 and 22/Apr/2017 so there is 111 days betwen these 2 dates. What I want to achieve is distributing these days to a particular month, so the first 30 days go to Jan 17, the second 28 go to Feb 17, 31 to Mar and 22 to Apr Any ideas if this can be done? Kind Regards Aidan

Aidan · ‎05-16-2017

Hi I want to piviot the below data in excel on export. Any ideas? I know how to use proc export etc to do a data cump in excel but how would I pivot the data? Col A Age Qtr Gender Type Amt E14 3 Quarter 3 F IP 2 E14 5 Quarter 3 M IP 1 E14 6 Quarter 3 F DC 10 E14 7 Quarter 4 F IP 1 E14 8 Quarter 4 M DC 1 E15 3 Quarter 3 F IP 2 E15 5 Quarter 3 M IP 1 E15 6 Quarter 3 F DC 10 E15 7 Quarter 4 F IP 1 E15 8 Quarter 4 M DC 1 Expected Output Sum of Amt Qtr Gender Type Quarter 3 Quarter 3 Total Quarter 4 Quarter 4 Total Grand Total F F Total M M Total F F Total M M Total Col A Age DC IP IP IP DC E14 3 2 2 2 2 5 1 1 1 1 6 10 10 10 10 7 1 1 1 1 8 1 1 1 1 E15 3 2 2 2 2 5 1 1 1 1 6 10 10 10 10 7 1 1 1 1 8 1 1 1 1 Grand Total 20 4 24 2 2 26 2 2 2 2 4 30

Aidan · ‎04-07-2017

Just seeing if its possible

Aidan · ‎04-07-2017

Do you mean jsut add the LRECL = 650 for example below? PROC EXPORT DATA=work.W4NV5KA OUTFILE="\\xxxx\Test.txt" LRECL=650 DBMS=TAB REPLACE; PUTNAMES=NO; RUN;

Online Status	Offline
Date Last Visited	‎11-14-2019 09:14 AM

Re: Execute PL/SQL package in DI Studio

Execute PL/SQL package in DI Studio

Re: Search for various strings with a variable

Re: Search for various strings with a variable

Search for various strings with a variable

Re: Email from SAS

Email from SAS

Re: Proc Tabulate to excel

Proc Tabulate to excel

Re: Distribute Days between 2 dates

Re: how to get distinct observation from a dataset

Tip: Getting the Most from your Random Forest

Re: Execute PL/SQL package in DI Studio

Re: SAS EG 8.1 - how to obtain?

Re: Email from SAS

Re: Search for various strings with a variable

Re: Text File Creation in DI

Re: Execute PL/SQL package in DI Studio

Execute PL/SQL package in DI Studio

Re: Search for various strings with a variable

Re: Search for various strings with a variable

Search for various strings with a variable

Re: Email from SAS

Email from SAS

Re: Proc Tabulate to excel

Proc Tabulate to excel

Re: Distribute Days between 2 dates

Re: Distribute Days between 2 dates

Distribute Days between 2 dates

Pivot data on export

Re: Proc Export

Re: Proc Export