About ChrisBrooks

ChrisBrooks · ‎01-26-2019

I can confirm it also still works fine on Safari

ChrisBrooks · ‎01-25-2019

That's possible although the documentation (such as it is) doesn't mention a limit. I've done a Google search on the Excel version of IRR and found that it's implementation of IRR also has similar issues. My suggestion of a very large negative rate of return causes problems with Excel as does multiple switching from positive to negative values and too many iterations of the algorithm being required to generate a solution as the algorithm is itself internally iterative (this might tie in with your suggestion of their being too many parameters for the function to handle). Assuming that both SAS and Excel use the same algorithm this strengthens the view that we won't solve this here and SAS Support would be the best port of call for @naresh1 to pursue this

ChrisBrooks · ‎01-24-2019

Hi Naresh and welcome to the community. I've done some experiments with your data and with the finance('IRR',...) function and think the error may be due to the large negative values you have early in your list. I suspect these are causing a very large negative rate of return which the function can't handle. You can simulate this more simply with the following code data _null_; val1=finance('IRR',-10,20,2000,30); put val1=; run; This returns a result but if you make the third value -2000 instead of 2000 you get the same error you are seeing. You may want to refer this to SAS Support by raising a track which you can do here -> https://support.sas.com/ctx/supportform/createForm They should be able to confirm if my suspicions are correct and possibly offer a workaround.

ChrisBrooks · ‎01-22-2019

An underscore isn't a numeric character so you won't get exactly what you seem to want. If you can explain why you need to convert this value to numeric might be able to offer an alternative strategy.

ChrisBrooks · ‎01-18-2019

Can you run the following proc code on your file and post the results here please proc contents data=circuit.fve; run; This will tell us what operating system the file was created on and its encoding (although I don't think the encoding is the problem).

ChrisBrooks · ‎01-10-2019

You can get your expected result by setting the third parameter to the yrdif function (basis) to '30/360'. This parameter is used to control how the actual day count is calculated - the default in the Excel yrfrac formula appears to be '30/360' whereas in SAS the default is 'AGE'. The two methods yield slightly different results hence the need to explicitly set the basis. You can find further details of the allowable values for basis here -> http://support.sas.com/documentation/cdl//en/lefunctionsref/69762/HTML/default/viewer.htm#p1pmmr2dtec32an1vbsqmm3abil5.htm Here's the sample code to give you the output you seek data out; set test; mydif=yrdif(date1,date2,'30/360'); run;

ChrisBrooks · ‎01-09-2019

Firstly save each macro you want to use as an auto call macro into a file with the same name as the macro and a .sas suffix. Then place the following two lines into your autoexec.sas file Options mautosource; Options Sasautos=(’C:\SAS\macros\’ SASAUTOS); That should do the trick for you

ChrisBrooks · ‎01-07-2019

Yes you can create simple web forms which will retrieve values from HTML input elements and pass those as parameters to Stored Processes - the first few pages of this paper give an example http://support.sas.com/resources/papers/proceedings14/1272-2014.pdf

ChrisBrooks · ‎01-03-2019

I agree with @Astounding it's easier without the commas - then check out the %scan macro function which allows you to select the nth element from the list, put that inside a %do loop and you're done....

ChrisBrooks · ‎01-02-2019

I agree with @HB - you're going to have to give us some more details before we can help you. For example do you want to export the data into a format which can be loaded into a DB such as ORACLE or MySQL or do you have something different in mind?

ChrisBrooks · ‎12-30-2018

You're right - I don't see any compelling reason to upgrade to the latest version of VirtualBox either (in fact I'm still running v 5.2.18). I don't ever usually rush to install the latest version as we've had issues with updates to VirtualBox "breaking" SAS UE before so it's only wise to hold back a bit anyway..... As to why your post appeared in New Users I really couldn't say - New Users is a fairly new sub-forum but I'm sure you used to be able to post in any forum (except the Community Library which required a minimum number of previous posts before giving write access). If you can only post in that one then I'm guessing it's a new rule linked to the number of posts you've made.

ChrisBrooks · ‎12-29-2018

I haven't heard of this particular problem before but you might be able to get round it by going into VirtualBox (on the latest version), right-clicking on the SAS UE VM and then clicking on Discard Saved State. I don't think you'll lose anything as in all the years I've used UE I've never explicitly saved the VM state and everything's been fine.

ChrisBrooks · ‎12-20-2018

I see you're using an ODBC driver - what is the data source e.g. ORACLE, MySQL?

ChrisBrooks · ‎12-03-2018

I've given this some thought and I can't think of a way of doing it. If it were possible then a Proc FCMP function called via the FCMP package would be the most likely way but not everything you can do in FCMP works through DS2. I'm not even sure the concept necessarily fits with DS2 since the data set would most likely be represented by the DS2 package which seems unnecessary. Of course data sets created with DS2 are compatible with Base SAS anyway so you can just call the Procedure outside DS2, reconfiguring your program as necessary.

ChrisBrooks · ‎12-02-2018

If you already have a sas7bdat file then that is already a SAS data set - you don't need to "import" it at all. If you want to copy it to another data set then you need a SET statement; what's happening in your code is that, assuming the original file is called sbp_2 then you're overwriting it with a blank file because of the absence of a SET statement.

Online Status	Offline
Date Last Visited	‎10-08-2024 11:59 PM