SAS Macro: How to Retrieve a Value from a Dataset

December 24, 2009 by
Filed under: Uncategorized 

SAS is a very powerful language when one have to deal with processing huge datasets. It becomes much more complicated when one wants to play with single elements. I recently had the need to put a specific value of a dataset into a macro variable. With the help of the SAS support team of Switzerland, I have made a small macro for that. Here is the definition of the function:

  • Macro name: Get_data
  • Input: myDataset (name of the dataset), myLine (line number), myColumn (name of the column), myMVar (name of the macro variable used to store the result)
  • Output: A new macro variable named &myMVar.

And here is the corresponding code:

%MACRO Get_data(myDataset=,myLine=,myColumn=,myMVar=);
%GLOBAL &myMVar.;
data _null_;
set &myDataset.;
if _N_ = &myLine. then do;
call symput(symget('myMVar'),&myColumn.);
end;
run;
%MEND Get_data;

Of course, I would be very interested if someone found a simplier way of performing this action (and I think SAS support would be interested as well).

Share

Comments

74 Comments on SAS Macro: How to Retrieve a Value from a Dataset

  1. lordthias on Thu, 24th Dec 2009 2:54 pm
  2. Hi Sandro,
    Here’s an other way to do the same think (maybe a little faster on big dataset)

    %MACRO Get_data(myDataset=,myLine=,myColumn=,myMVar=);
    %GLOBAL &myMVar;
    proc sql noprint;
    select &myColumn into :&myMVar
    from &myDataset
    where monotonic() = &myLine;
    quit;
    %MEND Get_data;

    %Get_data(myDataset=tablename,myLine=linenumber,myColumn=colname,myMVar=varname)
    %put &varname;

    I let you test the execution time 😉

    Joyeuse fête de noël !

  3. Sandro Saitta on Thu, 24th Dec 2009 4:05 pm
  4. @lordthias: Thanks for the PROC SQL example. I’m not using the get_data macro on big data sets for the moment, but I would of course compare both codes before using it on huge files :-) A toi aussi et bonne année!

  5. Chris Hemedinger on Thu, 24th Dec 2009 4:16 pm
  6. I second the suggestion for using PROC SQL SELECT INTO. The concept of sequential records holds true for SAS datasets, but if your data is in a DBMS, you might want a different mechanism for pulling out a specific record (value in an ID column, for example).

  7. Sandro Saitta on Sat, 26th Dec 2009 7:35 pm
  8. @Chris: Thanks for sharing your opinion. Also PROC SQL is closer to mySQL and may be worth considering if planning to move from SAS to another ETL tool (Talend, etc.)

  9. Shane on Wed, 30th Dec 2009 9:59 am
  10. Another benefit of PROC SQL is it doesn’t require sorted datasets for a join… where as DATA …; MERGE … BY … will throw an error if it is not sorted — very annoying!!

  11. Sandro Saitta on Sun, 3rd Jan 2010 1:23 pm
  12. @Shane: Good point! This is something we should keep in mind when comparing DATA step with PROC SQL execution time.

  13. Manish on Thu, 14th Jan 2010 12:01 pm
  14. Hi

    This is the simplest and the most efficient code I can think of (would be hapy to learn better way to do this).

    —————————————————————-

    %MACRO Get_data(myDataset=,myLine=,myColumn=);
    %GLOBAL myMVar;
    data _null_;
    pull = &myLine; /*assigning value of macto var to datastep*/
    set &myDataset (keep=&myColumn) point=Pull;
    call symput(‘myMVar’,&myColumn);
    output; stop;
    run;
    %MEND Get_data;

    %Get_data(myDataset=,myLine=,myColumn=);
    %put &myMVar; /*to print value of macro var in log*/

    —————————————————————-
    It is effiencie because it will read only the line that you want SAS to read. If ‘If – Then’ is used, sas reads each obs and then does the evalauation of IF condition, more input-output. This can be optimised by telling sas to read only the required row using ‘Point=’ option. But ‘Point=’ option takes only variable name. Hence, before set statement, a variable called ‘Pull’ is defined with the value of required row-number.. Now sas just reads the required row saving i/o. DO NOTE that ‘Output;’ and ‘Stop’ must be used with ‘Point=’ option of you will execute a never-ending data-step;

    I hae further optimised the program by using ‘KEEP=’ optin in set statement, which asks SAS to read only relevant columns.

    The syntax of ‘Call Sumput’ is actually simpler than what you have used here. You don’t need to use Symget here.

    Hope this helps.

    Manish

  15. Sandro Saitta on Thu, 14th Jan 2010 12:47 pm
  16. @Manish: Thanks for your example Manish. I haven’t tested it yet, but it seems (really) optimized by only reading the correct row/column. Thanks for your input!

  17. Song Liu on Thu, 18th Feb 2010 9:03 pm
  18. Use sas I/O funtions would be effient. Here is the code:
    %MACRO Get_data(myDataset,myLine,myColumn);
    %global myMvar;
    %let dsid=%sysfunc(open(&myDataset.,i));
    %let rc=%sysfunc(fetchobs(&dsid, &myLine.));
    %if &rc = 0 %then %let myMvar=%sysfunc(GETVARN(&dsid,%sysfunc(varnum(&dsid,&myColumn)))); /****use getvarc for character variables*****/
    %let rc=%sysfunc(close(&dsid));
    %MEND Get_data;

  19. RolandRB on Tue, 1st Feb 2011 3:55 am
  20. I have a macro called %getvalue to do this that uses SAS I/O functions as above. The advantage with this method is that you can have a function-style maco to do this that allows you to call it in the middle of a data step if need be.

    http://www.datasavantconsulting.com/roland/Spectre/utilmacros/getvalue.sas

    More macros here:
    http://www.datasavantconsulting.com/roland/Spectre/maclist2.html

  21. Sandro Saitta on Thu, 3rd Feb 2011 8:23 pm
  22. @RolandRB: Thanks for the links!

  23. fab on Sun, 8th Apr 2012 11:27 am
  24. I look for something like ‘setvalue’
    is it possible to write a value of a macro variable to a certain observation in a data set?
    I want to navigate with the line number as well.
    data and point with symget?

  25. Android Training in Chennai on Mon, 9th Feb 2015 12:56 pm
  26. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks,
    kathiresan

  27. Android Training in Chennai on Mon, 9th Feb 2015 1:33 pm
  28. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks,
    kathiresan

  29. Oracle Training on Wed, 18th Feb 2015 8:30 am
  30. Your blog is really useful for me. Thanks for sharing this informative blog. If anyone wants to get real time Oracle Training in Chennai reach FITA located at Chennai. They give professional and job oriented training for all students.

  31. SAP Training on Sat, 28th Feb 2015 12:26 pm
  32. Thanks for sharing this informative blog. FITA provides SAP Training in Chennai with years of experienced professionals and fully hands-on classes. SAP is one of the CRM. Today’s most of the IT industry use this software for customer relationship management. To know more details about sap reach FITA Academy. Rated as No.1 SAP Institutes in Chennai.

  33. Oracle Training in Chennai on Mon, 2nd Mar 2015 1:55 pm
  34. Your blog is really useful for me. Thanks for sharing this informative blog. If anyone wants to get real time Oracle Training in Chennai reach FITA Oracle Training Institutes in Chennai. They give professional and job oriented training for all students.

  35. Salesforce Training on Fri, 6th Mar 2015 10:52 am
  36. Thanks for sharing this informative blog. FITA provides Salesforce Training in Chennai with years of experienced professionals and fully hands-on classes. Salesforce is a cloud based CRM software. Today’s most of the IT industry use this software for customer relationship management. To know more details about salesforce reach FITA Academy. Rated as No.1 Salesforce Training Institutes in Chennai.

  37. Digital Marketing Training on Wed, 11th Mar 2015 7:41 am
  38. Thanks for sharing this informative blog. Recently I did Digital Marketing Training in Chennai at a leading digital marketing company. It’s really useful for me to make a bright career. To know more details about this course please visit FITA.

  39. Android Training Institutes in Chennai on Sat, 14th Mar 2015 7:20 am
  40. Your blog is really useful for me. Thanks for sharing this useful blog..Suppose if anyone interested to learn Android Training in Chennai please visit fita academy which offers best Android Course in Chennai at reasonable cost.

  41. Android Training in Chennai on Wed, 18th Mar 2015 7:53 am
  42. Thanks for your informative article. Android SDK allows you to create stunning mobile application loaded with more features and enhanced priority. With basis on Java coding language, you can create stunning mobile application with ease. Best Android Training institute in Chennai

  43. Android Course in in Chennai on Wed, 18th Mar 2015 7:55 am
  44. Thanks for your informative article. Android SDK allows you to create stunning mobile application loaded with more features and enhanced priority. With basis on Java coding language, you can create stunning mobile application with ease.

  45. Ios Training in Chennai on Thu, 19th Mar 2015 9:09 am
  46. Excellent post on iOS mobile apps development!!! The future of mobile application development is on positive note. You can make most it by having in-depth knowledge on mobile application development platform and other stunning features.

  47. SEO Training on Wed, 25th Mar 2015 6:51 am
  48. Your information is really useful for me.Thanks for sharing such a valuable information. If anyone wants to get SEO Training in Chennai visit FITA Academy located at Chennai. Rated as No.1 SEO Training institute in Chennai.

  49. Jenny on Tue, 7th Apr 2015 8:41 am
  50. dataset is really helpful. and can retrive a value from the dataset.Loadrunner Training in Chennai | Software Testing Training in Chennai | QTP Training in Chennai

  51. Java training in Chennai on Mon, 13th Apr 2015 12:51 pm
  52. Bind blowing. You have achieved your target. People should follow your blog for getting more information and their basic needs.

    Java training in Chennai | Android training in chennai | Java training in Chennai

  53. Android Training on Tue, 21st Apr 2015 8:36 am
  54. I agree with your post. Android software development kit makes the application development process lot simpler and effective. You can create best performing android application with ease. Android Training Institutes in Chennai | Android Training in Chennai

  55. jercy on Tue, 21st Apr 2015 10:08 am
  56. SAS is a type of Business Analytics Software.In these several topics are involved.Retriving the values in the dataset is the important one.These blog explained very clearely about the topic.It really nice.
    Loadrunner Training in Chennai | Loadrunner Training in Chennai | Loadrunner Training in Chennai

  57. Android Training on Tue, 21st Apr 2015 12:21 pm
  58. Hi, I am Emi lives in Chennai. I am technology freak. I did Android mobile application development course in Chennai at reputed training institutes, this is very usful for me to make a bright carrer in IT industry. So If you looking for best Android Training Institutes in Chennai please visit fita academy. Android Training in Chennai

  59. dhanalakshmi on Fri, 24th Apr 2015 10:17 am
  60. Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for me.. I get a lot of great information from this blog. Thank you for your sharing this informative blog. Android Training in chennai | Android Training chennai | Android course in chennai | Android course chennai

  61. John on Thu, 7th May 2015 1:03 pm
  62. PROC CONTENTS would be the quickest way to get that information in a dataset. Column names can be found in the column NAME.proc contents data=sashelp.class out=contents noprint; run;

    SAP Success factor Training in Chennai

  63. Testing Training in Chennai on Wed, 10th Jun 2015 7:13 am
  64. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.

    Regards..
    Software Testing Training in Chennai

  65. emtvnews on Mon, 15th Jun 2015 8:09 am
  66. Emtv helps us to provide updated Papua new guinea( PNG ) news, PNG Videos, PNG Article, PNG business, PNG technology, PNG weather, PNG Real Estate, PNG Fashion News, PNG Hollywood movies and other PNG News as well.

    PNG Travel News

  67. sdfasdf on Mon, 15th Jun 2015 8:11 am
  68. TOP Class Backlinks SERVICES PROVIDER

    High PageRank Backlinks

  69. lucy on Thu, 30th Jul 2015 12:43 pm
  70. Benefits of SAS:
    Increases your career opportunities and marketability.
    Enhances your credibility as a technical professional.
    Enhances your knowledge of SAS software.
    Helps you to earn industry validation(certifications) for your knowledge.
    SAS is marked as hot technology in many industries and thus SAS experts are getting higher salaries than others.
    40,000 – 50,000 SAS Analyst and programmer will be required in the next couple of years
    SAS Consultants are highly paid , get quick promotions, their Job is secured WORLDWIDE.
    List of companies currently hiring in SAS — > GE,Genpact, Standard Chartered Bank,Fidelity, HSBC,HP,,Accenture,Novaritis,Target,Mu Sigma, WIPRO,TCS,IBM India,Hewitt,Bank Of America,American, Express,Glaxo,Ranbaxy,Cipla,Inductis, Mercer,Ameriprise,WNS,Barclays,Steria,Tech Mahindra,HCL,Dunnhumby,Infosys,United Health Group,CSC and many more.

  71. juliaroberts on Wed, 5th Aug 2015 2:18 pm
  72. This was so useful and informative. The article helped me to learn something new.

  73. srisathvika on Thu, 6th Aug 2015 1:22 pm
  74. Good to learn something new from this blog. Thanks for sharing such worthy article.

  75. SAS Online Training on Wed, 19th Aug 2015 7:41 am
  76. Great information & very useful blog.

  77. sas training in Chennai on Fri, 21st Aug 2015 12:11 pm
  78. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.

  79. Swetha on Wed, 26th Aug 2015 5:01 am
  80. Are there any statements\functions capable of get the name of variables? Preferrably putting them into a column of another data set, a text field or a macro variable.

  81. SAS advance Training in Chennai on Wed, 26th Aug 2015 5:34 am
  82. First off, I assume you are talking about SAS/Base not SAS/IML; SAS/IML is essentially similar to R and has the same kind of operations available in the same manner.

    SAS/Base is more similar to a database language than a matrix language (though has some elements of both, and some elements of an OOP language, as well as being a full-featured functional programming language).

    As a result, you do things somewhat differently in order to achieve the same goal. Additionally, because of the cost of moving data in a large data table, you are given multiple methods to achieve the same result; you can choose the appropriate method for the required situation.

    To begin with, you generally should not store data in a macro variable in the manner you suggest. It is bad programming practice, and it is inefficient (as you have already noticed). SAS Datasets exist to store data; SAS macro variables exist to help simplify your programming tasks and drive the code.

    Creating the dataset “b” as above is trivial in Base SAS:

    data b;
    set a;
    keep v2;
    run;

  83. SAS training in chennaii on Wed, 26th Aug 2015 5:36 am
  84. That creates a new dataset with the same rows as A, but only the second column. KEEP and DROP allow you to control which columns are in the dataset.

    However, there would be very little point in this dataset, unless you were planning on modifying the data; after all, it contains the same information as A, just less. So for example, if you wanted to merge V2 into another dataset, rather than creating b, you could simply use a dataset option with A:

    data c;
    merge z a(keep=v2);
    by id;
    run;

  85. iOS Training in Chennai on Mon, 26th Oct 2015 1:11 pm
  86. Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for me.. I get a lot of great information from this blog. Thank you for your sharing this informative blog.

    iOS Training in Chennai

  87. Android Training in Chennai on Mon, 26th Oct 2015 1:12 pm
  88. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.

    Android Training in Chennai

  89. CCNA Training in Chennai on Mon, 26th Oct 2015 1:14 pm
  90. PROC CONTENTS would be the quickest way to get that information in a dataset. Column names can be found in the column NAME.proc contents data=sashelp.class out=contents noprint; run;

    CCNA Training in Chennai

  91. CCNA Training in Chennai on Fri, 30th Oct 2015 11:48 am
  92. It’s too informative blog and I am getting conglomerations of info’s. Thanks for sharing; I would like to see your updates regularly so keep blogging. If anyone looking ccna just get here
    Regards,
    ccna training institute in Chennai|ccna institutes in Chennai|ccna training in Chennai

  93. Shamsul Arifin on Thu, 12th Nov 2015 9:02 pm
  94. Hello:

    Good afternoon!

    I am very new in SAS, needs some help of your expertise.

    Would you mind to extend your hand to look into this problem?

    I was creating some Macro and trying to

    create table from existing table with some extra fields added using SELECT SQL

    Then I was trying to populate those new fields with some condition of the old existing fields.

    But it is not populating at all, populating the default one which falls into the extreme else condition.

    Here are my programs:

    A.

    proc sql;
    create table ReptLib.TestFile1 as
    select filecntl, entityid, def_sal,
    ‘ ‘ as
    name format=$50.,
    ‘ ‘ as
    fname format=$35.,
    lname, comp,addr1, addr2,
    city, prov, pcode, country,
    ‘ ‘ as
    longprov format=$40.,
    ‘ ‘ as
    ncountry format=$20.
    from ImptLib.a_november_appeal_main_cad;
    run;

    The above program works to create the new fields like name, fname, longprov, ncountry
    But I think, it can done in a more efficient way, can have any idea?

    B.

    %let dsn = ReptLib.TestFile1;
    %let lprov = longprov;
    %let sprov = prov;
    %let scountry = ncountry;

    %macro test1(dsn, lprov, sprov,scountry);
    /*
    %put &dsn;
    %put &sprov;
    %put &lprov;
    */

    data &dsn;
    set &dsn;
    %if %upcase(&sprov) = “AB” %then
    %do;
    &lprov. = “Alberta”;
    &scountry = ‘Canada’;
    %end;
    %else %if &sprov = ‘BC’ %then
    %DO;
    &lprov = ‘British Columbia’;
    &scountry = ‘Canada’;
    %end;
    %else
    %do;
    &lprov = ‘Not Match’;
    &scountry = ‘What Country’;
    %end;
    ;
    run;
    %mend;
    %test1(&dsn,&lprov,&sprov,&scountry);

    When I run this Macro, it goes to the end else condition for all records of the dataset

    &lprov = ‘Not Match’;
    &scountry = ‘What Country’;

    So, I am frustrated and seeking your help.

    Thanks for your time and effort.

    Regards,
    Shamsul Arifin

  95. Jharkhand Labour Department Recruitment 2016 on Mon, 28th Dec 2015 10:57 am
  96. Hey this is a great post, thanks for the share………

  97. Nicole Marie on Sat, 20th Feb 2016 6:12 am
  98. How I Got My Loan From A Genuine And Reliable Loan Company (Lexieloanfinance@gmail.com)!!!

    My Name is Nicole Marie, I live in USA and life is worth living comfortably for me and my family now and i really have never seen goodness shown to me this much in my life, As i am a struggling mum with two kids and i have been going through a serious problem as my husband encountered a terrible accident last two weeks, and the doctors states that he needs to undergo a delicate surgery for him to be able to walk again and i could not afford the bill for his surgery then i went to the bank for a loan and they turn me down stating that i have no credit card, from there i ran to my father and he was not able to help me, then when i was browsing through yahoo answers and i came across a God fearing man (Mr Martinez Lexie) who provides loans at an affordable interest rate and i have been hearing about so many scams on the Internet mostly Africa, but at this my desperate situation, i had no choice than to give it an attempt due to the fact that the company is from United State of America, and surprisingly it was all like a dream, i received a loan of $82,000.00 USD and i payed for my husband surgery and thank GOD today he is ok and can walk, my family is happy and i said to myself that i will shout to the world the wonders this great and God fearing Man Mr Martinez Lexie did for me and my family; so if anyone is in genuine and serious need of a loan do contact this GOD fearing man via Email: Lexieloanfinance@gmail.com or ( Lexieloancompany@yahoo.com ) or immediately reach him through text Tel: +1 (406) 946-0675 thanks

  99. Carolyn V. Metnick on Sun, 20th Mar 2016 5:29 am
  100. HOW I GOT MY LOAN FROM ELVIN LOAN COMPANY{elvinloancompany@yahoo.com}

    I am Carolyn V. Metnick,from Ohio USA, i want to use this great medium to announce this lender Elvin Morrison who is really a God sent to my family. few months back i was in search of a loan from the internet where i was scammed of $3250.00, i never thought i will ever apply for a loan on the internet again before i met a post about this lender made by one Maury who also got a loan from them, then i took a try again, after loan processing i was ask to provide my banking details which i did and to my greatest surprise i was granted a loan of $45,000.00 at first i thought it was a joke until i got to the bank to confirm and it was true, i was overwhelmed with joy. so i want you all who desire a loan and are capable of paying back the funds at the due time to contact: elvinloancompany@yahoo.com or on page http://elvinloancompanys.bravesites.com or Tel:+1(307)213-2540 and be a partaker of my testimony ….

  101. Andrew Thompson on Wed, 20th Apr 2016 10:25 pm
  102. How I Was Rescued By A God Fearing Lender (Lexieloancompany@yahoo.com)

    Hello, I am Andrew Thompson currently living in CT USA, God has bless me with two kids and a lovely Wife, I promise to share this Testimony because of God favor in my life, 2days ago I was in desperate need of money so I thought of having a loan then I ran into wrong hands who claimed to be loan lender not knowing he was a scam. he collected 1,500.00 USD from me and refuse to email me since then I was confuse, but God came to my rescue, one faithful day I went to church after the service I share idea with a friend and she introduce me to LEXIE LOAN COMPANY, she said she was given 98,000.00 USD by MR LEXIE , THE MANAGING DIRECTOR OF LEXIE LOAN COMPANY. So I collected his email Address , he told me the rules and regulation and I followed, then after processing of the Documents, he gave me my loan of 55,000.00 USD… So if you are interested in a loan you can as well contact him on this Email: lexieloancompany@yahoo.com or text +1(406) 946-0675 thanks, I am sure he will also help you.

  103. Mrs. Kari on Sun, 24th Apr 2016 3:54 pm
  104. Dear valued customer,

    Do you need Financial Assistance?
    Do you seek funds to pay off credits and debts?
    We give out loan with an Interest rate of 1.00%

    Please, contact us for more information: karituncer@mail.com

    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    Please, contact us for more information: karituncer@mail.com

    We look forward to hearing from you.

    Yours Sincerely,
    Mrs. Kari Tuncer.

  105. Mrs. Kari on Sun, 24th Apr 2016 3:55 pm
  106. Dear valued customer,

    Do you need Financial Assistance?
    Do you seek funds to pay off credits and debts?
    We give out loan with an Interest rate of 1.00%

    Please, contact us for more information: karituncer@mail.com

    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    Please, contact us for more information: karituncer@mail.com

    We look forward to hearing from you.

  107. Desmond Cloud on Thu, 5th May 2016 3:56 pm
  108. Hello, I am Desmond Cloud currently living in CT USA, God has bless me with two kids and a lovely Wife, I promise to share this Testimony because of God favor in my life, 2days ago I was in desperate need of money so I thought of having a loan then I ran into wrong hands who claimed to be loan lender not knowing he was a scam. he collected 1,500.00 USD from me and refuse to email me since then I was confuse, but God came to my rescue, one faithful day I went to church after the service I share idea with a friend and she introduce me to JEFFERY SMITH LOAN COMPANY, she said she was given 98,000.00 USD by MR JEFFERY SMITH , THE MANAGING DIRECTOR OF JEFFERY SMITH LOAN COMPANY. So I collected his email Address , he told me the rules and regulation and I followed, then after processing of the Documents, he gave me my loan of 55,000.00 USD… So if you are interested in a loan you can as well contact him on this Email: (jefferysmithloancompany@gmail.com) thanks, I am sure he will also help you.

  109. Anita Frank on Sun, 22nd May 2016 5:48 pm
  110. HOW I GOT MY LOAN FROM THIS GREAT COMPANY

    Hello my dear people , I am Anita Frank, currently living in New jersey city, USA. I am a widow at the moment with three kids and i was stuck in a financial situation in April 2015 and i needed to refinance and pay my bills. I tried seeking loans from various loan firms both private and corporate but never with success, and most banks declined my credit ,do not full prey to those hoodlums at there that call them self money lender they are all scam , all they want is your money and you well not hear from them again they have done it to me twice before I met Mr. Wilson Edwards the most interesting part of it is that my loan was transfer to me within 74hours so I will advice you to contact Mr. Edwards if you are interested in getting loan and you are sure you can pay him back on time you can contact him via email……… (wilsonedwardsloancompany@gmail.com) No credit check, no co signer with just 2% interest rate and better repayment plans and schedule if you must contact any firm with reference to securing a loan without collateral then contact Mr. Wilson Edwards today for your loan
    They offer all kind of categories of loan they
    Short term loan (5_10years)
    Long term loan (20_40)
    Media term loan(10_20)
    They offer loan like
    Home loan…………., Business loan…….. Debt loan …….
    Student loan……….,Business start up loan
    Business loan……. , Company loan………….. etc
    Email……….(wilsonedwardsloancompany@gmail.com )
    When it comes to financial crisis and loan then Wilson Edwards loan financial is the place to go please just tell him I Mrs. Anita Frank direct you Good Luck…………………..

  111. Mrs. Fatima on Sat, 28th May 2016 5:47 pm
  112. Dear valued customer,

    PERGO CORPORATE FINANCE,(PCF), aims is to provide Excellent Professional Service and to conduct ourselves in a manner that maintains high standards of business ethics with consumers, thereby transacting business in such a manner as to merit the continued respect and confidence of consumers and the general public. PERGO CORPORATE FINANCE,(PCF), PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    Do you need Financial Assistance? We are looking for businesses that are in need of funding for Acquisition, Expansion, Growth, Refinance or Survival.
    We give out loan with an Interest rate of 1.0%

    Please, contact us for more information: PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    Kindly write us back with the loan information;

    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    If you are interested to get a loan then kindly write us with the loan requirement.

    Please, contact us for more information: PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    We look forward to hear from you ASAP

  113. Mrs. Ceren on Sat, 28th May 2016 5:47 pm
  114. PERGO CORPORATE FINANCE,(PCF), aims is to provide Excellent Professional Service and to conduct ourselves in a manner that maintains high standards of business ethics with consumers, thereby transacting business in such a manner as to merit the continued respect and confidence of consumers and the general public. PERGO CORPORATE FINANCE,(PCF), PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    Do you need Financial Assistance? We are looking for businesses that are in need of funding for Acquisition, Expansion, Growth, Refinance or Survival.
    We give out loan with an Interest rate of 1.0%

    Please, contact us for more information: PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    Kindly write us back with the loan information;

    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    If you are interested to get a loan then kindly write us with the loan requirement.

    Please, contact us for more information: PERGO CORPORATE FINANCE,(PCF),( pergocf@fastservice.com )

    We look forward to hear from you ASAP

  115. Mrs. Ceren on Wed, 22nd Jun 2016 8:25 am
  116. WE OFFER ALL KIND OF LOANS – APPLY FOR AFFORDABLE LOANS.

    Do you need Financial Assistance? We can help you
    We give out loan with an Interest rate of 1.0%
    Please, contact us for more information: pergocf@fastservice.com
    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    If you are interested to get a loan then kindly write us with the loan requirement.
    Please, contact us for more information: pergocf@fastservice.com

    Yours Sincerely,
    Mrs. Ceren Kelly
    pergocf@fastservice.com

    We look forward to hear from you ASAP.

  117. Mrs. Ceren on Fri, 1st Jul 2016 8:14 pm
  118. Do you need Financial Assistance?
    Do you seek funds to pay off credits and debts?
    We give out loan with an Interest rate of 1.00%

    Please, contact us for more information: pergocf@fastservice.com

    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed…$, €, £:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    Please, contact us for more information: pergocf@fastservice.com

  119. Imelda Daher on Mon, 4th Jul 2016 6:23 pm
  120. Hey guys, my name is Imelda Daher from Philippines but reside in America i am very happy that i was able to be online last week when Janet posted on YouTube that she has finally gotten what she wanted for her marriage life after all the stress she went through trying to hack into our husbands phone herself.. So after that I decided to try and see if it’s gonna work or still the same thing I see online everyday so I contacted Michael as i was referred to by Janet to his email which I did and got his direct telephone number as well too and believe me he did a good job for me that I was shocked when I got the information I needed that my dear husband for 10 year of marriage has a baby mama in Sweden. thanks to Michael Lawson for this great job even if it’s gonna break my home its better than been fooled for the rest of my life. lawsonmichael33@yahoo.com by Janet and he did a good and fast job for me in less than 48hrs…he made available phone hack, chat histories, present chats and future chats…You can also contact him for all sorts of mobile hacking jobs like he told me. Good luck to everyone who really wanna work with him and put a stop to the entire nightmare.

  121. Andy James on Wed, 6th Jul 2016 5:43 am
  122. My name is Andy James currently living in california USA Am writing this letter because am really grateful for what Elvin Morrison did for me and my family when I thought there was no hope he came and make a way for me and my family by lending us loan at a very low interest rate of 2%. I never thought that there are still God sent and genuine loan lenders on the web but to my greatest surprise i got my loan without wasting much time so if you are out there looking for a loan of any amount i would like to recommend you to Elvin Morrison the Managing director of Elvin Loan Company because he is a God sent man that can change your life forever, So if you really want to make a better life without any fund scarcity I would advise you to get in touch with him through this e-mail below elvinloancompany@yahoo.com or text +13072132540 or on our web page http://elvinloancompanys.bravesites.com

  123. Devdutt Vyas on Fri, 22nd Jul 2016 5:14 pm
  124. We specialized in Bank Guarantee {BG}, Standby Letter of Credit {SBLC}, Medium Term Notes {MTN}, Confirmable Bank Draft {CBD} as well as other financial instruments issued from AAA Rated bank such as HSBC Bank Hong Kong, HSBC Bank London, Deutsche Bank AG Frankfurt, Barclays Bank , Standard Chartered Bank and others on lease at the lowest available rates depending on the face value of the instrument needed.

    We deliver with time and precision as sethforth in the agreement. Our terms and Conditions are reasonable, below is our instrument description.

    The procedure is very simple; the instrument will be reserved on euro clear to be verified by your bank, after verification an arrangement will be made for necessary bank documents and stock testing expenses, the cost of the Bank Guarantee will be paid after the delivery of the MT760.

    Below is our instrument description.

    DESCRIPTION OF INSTRUMENT:
    Instrument: Bank Guarantee (BG/SBLC).
    Total Face Value: Minimum of 1M Eur/USD (One Million Eur/USD) to Maximum of 5B Euro/USD(Five Billion Eur/USD).

    Issuing Bank: HSBC London, Barclays Bank, Deutsche Bank Frankfurt, Hong Kong, Any AA rated Bank in Europe or any Top 25 WEB.

    Age: One Year, One Day
    Leasing Price: 5% of Face Value plus 2% commission fees to brokers.
    Delivery: Bank to Bank SWIFT.
    Payment: MT-760.
    Hard Copy: Bonded Courier within 7 banking days.

    All relevant business information will be provided upon request plus our terms and
    procedures: If you are interested please contact me for us to proceed further

    Regards

    Devdutt Vyas
    Email: devdutt_vyas@outlook.com
    devdutt.vyas2016@gmail.com
    Skype: devdutt.vyas

  125. Mrs. Ceren on Thu, 11th Aug 2016 7:00 pm
  126. Dear valued customer,

    WELCOME TO PERGO CORPORATE FINANCE,(PCF), pergocf@fastservice.com aims is to provide Excellent Professional Service

    Do you need Financial Assistance? We can help you
    We give out loan with an Interest rate of 1.0%
    Please reply to via Email : pergocf@fastservice.com

    WE OFFER ALL KIND OF LOANS – APPLY FOR AFFORDABLE LOANS.

    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    We encourage you to contact us and learn more about the loans service we offered. If you have any questions or want more information about our company, please feel free to email at pergocf@fastservice.com
    Yours Sincerely,
    Mrs. Ceren Kelly
    pergocf@fastservice.com

    We look forward to hear from you ASAP.

  127. Mrs. Ceren on Thu, 11th Aug 2016 7:00 pm
  128. WELCOME TO PERGO CORPORATE FINANCE,(PCF), pergocf@fastservice.com aims is to provide Excellent Professional Service

    Do you need Financial Assistance? We can help you
    We give out loan with an Interest rate of 1.0%
    Please reply to via Email : pergocf@fastservice.com

    WE OFFER ALL KIND OF LOANS – APPLY FOR AFFORDABLE LOANS.

    Kindly write us back with the loan information;
    – Complete Name:
    – Loan amount needed:
    – Loan Duration:
    – Purpose of loan:
    – City / Country:
    – Telephone:
    – Name of the Site:

    We encourage you to contact us and learn more about the loans service we offered. If you have any questions or want more information about our company, please feel free to email at pergocf@fastservice.com
    Yours Sincerely,
    Mrs. Ceren Kelly
    pergocf@fastservice.com

    We look forward to hear from you ASAP.

  129. Mark Andrew on Mon, 22nd Aug 2016 2:15 am
  130. Finding a genuine provider of financial instrument is very challenging but we are certified Financial Instrument providers in United Kingdom. Presently, we only focus on BG/SBLC for Lease and Sale transactions. However, our Lease BG/SBLC is 6+2% and Sale at 40+2%.

    Should you find this interesting and acceptable? Kindly, contact us and we shall review and respond with draft Contract/MOU within 48hrs maximum.

    Please request for full procedure details if interested.

    For further inquiry contact:
    Mark Andrew
    Skype:andrewmark1996
    Email:andrewmarkhill360@gmail.com

  131. Lindsey Tyler on Thu, 25th Aug 2016 2:06 pm
  132. Hello every one please i will like to talk about the goodness of GOD in my life after so many months of trying to get a loan on the internet and was scammed the sum of $1,800 i became so desperate in getting a loan from a legit lender online then a friend told me that there is a legit loan company where he got his loan fast and easy without any stress so he introduced me to a Man called Edward Jones Jr , So i applied for a loan sum of ($60,000.00) with low interest rate so the loan was approved and deposited into my bank account that was how i was able to get my loan and i was able to pay off my bills. i am advising every one who is interested in getting a loan fast and easy to kindly contact them via email: {jonesloanfinance@yahoo.com} ,So thanks as you read the greatest testimony of my life and thanks be to GOD almighty for his goodness upon my life.

    Lindsey Tyler

  133. Johnson Hatton on Tue, 30th Aug 2016 3:30 pm
  134. We have direct and efficient providers of Bank Guarantee (BG’s), Insurance Guarantees,Confirmable Bank Drafts, Standby

    Letters of Credit (SBLC) medium term note (MTN) and Third Party Guarantees. which are specifically for sell/lease at leasing

    price of 4+2% /40+2% for selling price.
    If you are a potential Investor or principal looking to raise capital, we will be happy to answer any questions that you

    have about this opportunity and to provide you with details regarding these services.

    Our BG/SBLC Financing can help you get your project funded, by providing you with yearly renewable leased bank instruments.

    We work directly with the providers of these instruments.

    DESCRIPTION OF INSTRUMENTS:

    1. Instrument: Bank Guarantee (BG/SBLC) (Appendix A)
    2. Total Face Value: Eur 5M MIN and Eur 10B MAX (Ten Billion USD).
    3. Issuing Bank: Barcley’s Bank , HSBC Bank London, Credit Suisse and Deutsche Bank Frankfurt.
    4. Age: One Year, One Month
    5. Leasing Price: 4% of Face Value plus 2% commission fees to brokers.
    6. Delivery: Bank to Bank swift.
    7. Payment: MT-103 or MT760
    8. Hard Copy: Bonded Courier within 7 banking day.

    BELOW IS OUR FCO PROCEDURE

    WE will arrange for a fresh cut BG/SBLC EURO/USD $10million to 100billion in favor of your company with Euro clear access

    code and block code as well as the ISIN and CUSIP numbers and Common Code of the SBLC from Barclay’s Bank to enable you

    verify it at a lease cost of 4+2% After which you will transfer Euro cost fee to validate the instrument before it is

    delivered by swift MT199/MT799 pre-advice and finally via MT760 and the beneficiary is expected to pay 4% lease cost via

    MT103 to providers funding bank after verifying and authenticating the swift MT760 from issuing bank Barclay’s, hsbc, and

    deucthe bank etc.
    Contact us for outstanding service, competence & professionalism;

    For all inquires Contact:

    Name: johnson Hatton
    Email: johnsonhatton@gmail.com
    Skype: johnson.hatton007

  135. Rohlfsen on Tue, 30th Aug 2016 3:33 pm
  136. We have a direct genuine provider for BG/SBLC specifically for lease, at leasing price of 4+2 of face value, Issuance by HSBC

    London/Hong Kong or any other AA rated Bank in Europe, Middle East or USA.

    Contact : Mr rohlfsen russell
    Email:rohlfsenrussell@gmail.com
    Skype ID:rohlfsen.russell

    Intermediaries/Consultants/Brokers are welcome to bring their clients and are 100% protected. In complete confidence, we will

    work together for the benefits of all parties involved.

    All inquires to Mr.Rohlfsen Russell should include the following minimum information so I can quickly address your needs:

    Complete contact information:
    What exactly do you need?
    How long do you need it for?
    Are you a principal borrower or a broker?

    Contact me for more details.

    Rohlfsen Russell

  137. Precious Williams on Wed, 31st Aug 2016 10:02 pm
  138. Wow i never thought i will happy in my life ever again, i want you all to thank DR OGUDUGU of GREATOGUDUGU@GMAIL.COM, he is a father that takes care of his children the spell caster of our time, he has saved me from a very ugly situation that almost made my life miserable and i want you all to thank him for me,my husband and i have be married for so many years now with children and the relationship was being threatened by a small girl in his working place,she was almost destroying my home i met so many spell casters but to no avail until i met a friend who came from africa and she told me about DR OGUDUGU, and i decided to contact him and try him out as i was losing faith in all spell casters, but he told not to worry that now am in his temple everything will be alright he assured me 100% that his spell has no side effects and that it will work straight and save my home and my marriage and after he has performed the sacrifices and casted the spell, my husband came back to us with love and affection and he loved us more and more and he never looked back or none did his love for me waiver, if you are also experiencing this sort of your situation in your home, if your husband is drifting away, if you are experiencing a broken home or you have lost your husband to a young woman outside there then look no further help is here as GREATOGUDUGU@GMAIL.COM is ready to help you out okay for any of your problem is it financial needs, revenge spell, job spell, promotion spell what kind of spell do you need DR OGUDUGU is going to solve it for you okay i have promised him to always talk of his good works to the world in general and to any body who cares to listen, you can email him on his personal email on or GREATOGUDUGU@GMAIL.COM and he will attend to you as soon as possible okay once again his email is or GREATOGUDUGU@GMAIL.COM OR call +2348142250751 Thank you great father your daughter Precious Williams.

  139. Lindsey Tyler on Thu, 1st Sep 2016 4:40 pm
  140. How I Got A Loan From My God Fearing And Trusted Lender {jonesloanfinance@yahoo.com}

    Hello every one please i will like to talk about the goodness of GOD in my life after so many months of trying to get a loan on the internet and was scammed the sum of $1,800 i became so desperate in getting a loan from a legit lender online then a friend told me that there is a legit loan company where he got his loan fast and easy without any stress so he introduced me to a Man called Edward Jones Jr , So i applied for a loan sum of ($60,000.00) with low interest rate so the loan was approved and deposited into my bank account that was how i was able to get my loan and i was able to pay off my bills. i am advising every one who is interested in getting a loan fast and easy to kindly contact them via email: {Jonesloanfinance@yahoo.com} or Test us now (424) 281-7747 , So thanks as you read the greatest testimony of my life and thanks be to GOD almighty for his goodness upon my life.

    Lindsey Tyler

  141. DAVID MIKE on Mon, 5th Sep 2016 4:48 pm
  142. To Whom it may concern!!!

    Are you a businessman / woman? Are you in any financial mess or you need
    funds to start your own business? or to pay off your bills or start a good
    business? Contact us on davidmike756@gmail.com. You can also Text or Call
    Our Head Office In United state of america on +19513561932.
    required to fill the info :
    Name—-
    Amunt—-
    Duration—-
    Phone number—
    Country—
    Regards,
    FROM: DAVID MIKE Loan Company
    +19513561932.
    davidmike756@gmail.com

  143. mcao laro on Fri, 16th Sep 2016 7:53 am
  144. I live in usa and life is worth living comfortably for me and my family now and really have never seen goodness shown to me this much in my life as I am a mother who struggles with three children and I have been going through a problem as seriously as my husband found a terrible accident last two weeks, and the doctors states that he needs to undergo a delicate surgery for him to be able to walk again and I could not pay the bills, then your surgery went to the bank to borrow and reject me saying that I have no credit card, from there i run to my father and he was not able to help, then when I was browsing through yahoo answers and i came across a loan lender MR TONY HARTON, offering loans at affordable interest rate and i have been hearing about so many scams on the internet but at this my desperate situation, I had no choice but to give it an attempt and surprisingly it was all like a dream, I got a loan of $ 50,000 and I paid for my husband surgery and thank God today is good and you can walk and is working and the burden is longer so much on me more and we can feed well and my family is happy today and i said to myself that I will mourn aloud in the world of the wonders of God to me through this lender GOD fearing MR TONY HARTON and I would advise anyone in genuine and serious need of loan to contact this God-fearing man on financialhome34@outlook.com through .. and I want you all to pray for this man for me
    Thanks

  145. EDWARD JONES on Wed, 21st Sep 2016 1:25 pm
  146. AFFORDABLE LOAN OFFER

    Are you financially down? Do you need a loan to start up business of pay off bills? we offer all kinds of financial assistance to every individuals “Business loan and personal loan, for investment, debt consolidation and house purchase etc.” we will be willing to offer you the loan. Offer is affordable at an interest rate of 2%;this Funding program allows our client to enjoy low interest payback for as low as 2% per annul for a period of 2 months – 50 years. We can approve a loan/funding for a minimum of 5,000.00 up to 20,000,000.00 depending on the nature of business. but before we can proceed with the loan,if interested contact us now : { jonesloanfinance@yahoo.com}

  147. Bharath K Vasu on Mon, 26th Sep 2016 5:21 pm
  148. I am a direct Mandate to a genuinely renowned Investment Finance Company offering Cash & Asset Backed Financial Instruments on Lease and Sale at the best rates and with the most feasible procedures.
    Instruments offered can be put in all forms of trade and can be monetized or discounted for direct funding.
    GENUINE BANK GUARANTEE (BG) AND STANDBY LETTER OF CREDIT (SBLC) FOR LEASE AND SALE AT THE LOWEST RATES AVAILABLE. OTHER FINANCIAL INSTRUMENTS SUCH AS MTN, CD, DLC, PB ARE ALSO AVAILABLE.

    We offer certifiable and verifiable bank instruments via Swift Transmission from a genuine provider capable of taking up time bound transactions.

    Kindly contact for genuine inquiries and I can provider you with the needed information.

    With Regards,
    Bharath Kumar Vasu

    Financial Mandate on Bank Instruments

    Email:bharathkvasufinservices@gmail.com
    Emai:bharathkvasu@yahoo.com
    Skype: bharath.kvasu.finservices

    Bharath Kumar Vasu
    Financial Mandate on Bank Instruments
    Private Banking and Client Services
    Email : bharathkvasufinservices@gmail.com
    Skype : bharath.kvasu.finservices
    London – Manchester – Essex – Southampton – England – United Kingdom
    BROKERS ARE WELCOME & 100% PROTECTED!!

Tell me what you're thinking...





  • Swiss Association for Analytics

  • Most Popular Posts

  • T-shirts, Mugs & Mousepads


    All benefits given to a charity association
  • Data Mining Search Engine

    Supported by AnalyticBridge

  • Archives

  • Reading Recommandations