About Linda_V

Linda_V · ‎06-10-2016

Hi, We are currently using Version R.3.1.0 (Spring Dance) on our SAS server and can use R software within SAS Studio. We also have SAS IML Studio licensed. We would like to obtain a newer version of R that contains the Package "car". I believe R.3.2.5 might contain this package but I'm not sure. Where can I confirm this? Where does SAS recommend that we obtain the R software from? Someone told me that R was purchased by another company? Will this have any impact on us acquiring the software? We will need to install it on both a Windows and Linux server. Will we need different versions? Thank you for any guidance that you can provide. Linda

Linda_V · ‎07-02-2015

Thanks Chris. I've been trying to get the modeler to provide more details to me, like the code and the log, but I haven't received those yet. Just thought I'd see if anyone had some hints. That's why I haven't created my SAS ticket yet. Thanks again, Linda

Linda_V · ‎07-02-2015

Any ideas? The modeler said that he ran his program in a loop and SAS worked ok for the first 32 files. Then he got the following error: ERROR: Invalid Operation. ERROR: Termination due to Floating Point Exception We are using SAS EG 6.1 with SAS 9.4 on a Linux Server. Thanks for any help you can provide.

Linda_V · ‎09-24-2014

Do I need a new version of Tagsets for SAS9.4? Also, I am running in a Server environment and it is not letting me WRITE to the Template Store. I remember getting around this after the last upgrade we went through, but that was several years ago. Thanks!

Linda_V · ‎05-30-2014

Update... I got it to work... The INFORMAT can be 12.2 but then I need to FORMAT it bigger.... 14.2 to fit the decimal sign and the leading minus sign... YAY!!!

Linda_V · ‎05-30-2014

I am not using Mainframe SAS to read the file. I use Enterprise Guide interface and read the Mainframe file via FTP statement. That is why I need to use the EBCDIC informats to read my data in. Otherwise I get gibberish. I have tried all of the file formats listed and none of them get me the desired results. I will review the website to see if I missed any. Thanks anyway..

Linda_V · ‎05-30-2014

(1) I have a column of data that looks has either a positive amount or a negative number. The data is suppose to be formatted 12.2 For example: FRED 000002300086 BARNEY -99999999999 Fred's amount = 23,000.86 and Barney's amount = -99999999.99 The Variable Name that I am having trouble with is: TotalRewardCash shown below. (2) A second question I have is the Variable PeriodId is yyyymmdd and I would like to read it in as a date, but couldn't find an ebcdic format that would work properly. DATA CCARD_RAW_DATA; INFILE COMMCARD; INPUT @1 ReferenceNumber $EBCDIC12. @13 CustomerID $EBCDIC12. @25 BankId $EBCDIC12. @37 PeriodId $EBCDIC8. @135 TotalRewardCash S370FZDU12.2 ; RUN; I have tried many informats but this one gets me the closest. It brings in the numbers but will not bring in the leading negative sign. I have tried S370FZDL12.2 but then I get nothing. Does anyone have any suggestions? Thanks.

Linda_V · ‎05-16-2014

Thanks. Do you have a website that might have some examples that I can look at ?

Linda_V · ‎05-16-2014

Hi.. We have a lot of our reports written as Stored Processes so that the report users can run their own reports as needed using the SAS Add-in for M/S Office. We would like to create a stored process for a report that outputs to multiple tabs in excel. Can this be done? I have created an example using the SASHELP.CLASS directory to try and show you what we are trying to do. When I created a stored process using this code, all of the PROC PRINTS are writing to one excel sheet. Can they somehow be sent to separate tabs? Thank you for your suggestions. ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME='FIRST') STYLE=NORMAL; PRINT DATA=SASHELP.CLASS (WHERE=(SEX='F')); RUN; ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME='SECOND'); PRINT DATA=SASHELP.CLASS (WHERE=(SEX='M')); RUN; ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME='THIRD'); PRINT DATA=SASHELP.CLASS; RUN; ODS TAGSETS.EXCELXP CLOSE;

Linda_V · ‎06-27-2012

It looks like you are outputting the file to your Linux directory. I was going to try to push the file directly to the Windows directory as its destination. For example FILE="P:\folder|filename.xls" We use PC File Server to "jump the fence" to the Windows world which eliminates the step of using the FTP software to drag and drop the file to the Windows directory.

Linda_V · ‎06-27-2012

I went to the awesome presentation on TAGSETS and I used to use them all the time on my Local SAS, however, I'm on a Linux Server now and I have to use the PC File Server to get my files over to a Windows environment. Where do I put my magic word SERVER = in the ODS Statements needed to make the TAGSETS work? :smileyconfused:

Linda_V · ‎06-21-2012

I also downloaded the SAS Addin called: Export to Microsoft Excel 2007/2010 from the SAS website. It's working great but it's like a Wizard. It doesn't produce code you can use in batch. And it will only Export to a Windows environment so if you have a large file, it takes a bit. Have a great day..

Linda_V · ‎05-24-2012

Hi... I have a similiar problem in EG with the PROC Freq Titles... I'm trying to surpress it saying The FREQ Procedure... but I do want my TITLE to show.. I changed the setting in the Options under TASKS GENERAL -- I unchecked "Include SAS procedure titles in results" ... but they are still showing...??? Any suggestions? Thanks!!

Linda_V · ‎05-08-2012

Thanks.. I have Excel 2010. Do I need to load any special Excel Add-ins?

Linda_V · ‎05-08-2012

I'm trying to export more than 256 columns as an excel file or a .csv file. Can this be done with SAS 9.2 ??

Online Status	Offline
Date Last Visited	‎09-17-2024 05:00 PM

Re: Using serverpass=

Re: Using serverpass=

Using serverpass=

Error Notification

Re: Using the Add-in for Excel, Can a Stored Process Output to multipl...

Re: Using the Add-in for Excel, Can a Stored Process Output to multipl...

Re: Sending to Excel

Re: How to disable Enterprise Guide Short-cut keys

How to disable Enterprise Guide Short-cut keys

Re: Need help to combine multiple column into a single column.

Re: Using serverpass=

Re: Remove empty row between title/footnote and table ODS EXCEL and PR...

Re: Using the Add-in for Excel, Can a Stored Process Output to multipl...

Re: How to disable Enterprise Guide Short-cut keys

Re: sas.iomprovider.1 not registered on local machine

Re: Using the Add-in for Excel, Can a Stored Process Output to multipl...

How and where to acquire the latest R software that is compatible with...

Re: New Error message that I haven't seen yet... Floating Point Excep...

New Error message that I haven't seen yet... Floating Point Exception

Do I need a new version of Tagsets for SAS 9.4?

Re: Reading Mainframe file via EG Linux

Re: Reading Mainframe file via EG Linux

Reading Mainframe file via EG Linux

Re: Using the Add-in for Excel, Can a Stored Process Output to multipl...

Using the Add-in for Excel, Can a Stored Process Output to multiple ta...

Re: TAGSETS and PC FileServer Quesion...

TAGSETS and PC FileServer Quesion...

Re: Can we use Proc Export for more than 256 columns?

Re: Some graph titles no longer appearing when program run in EG

Re: Can we use Proc Export for more than 256 columns?

Can we use Proc Export for more than 256 columns?

SAS Global Forum 2018