I am wondering what kind of version control tool everyone uses to manage SAS program versions.  Can you please suggest the one you like and easier to use?   I also would like to know the setup for this tool such as Tortoise SVN - I have installed this in my computer, but setting a repository seems challenging and not straight forward. How do I connect the repository to my SAS grid server. Admins have not used any such tools, but they are willing to try out if we suggest any.         ... View more

We have many manual excel entry from multiple users about their daily schedule and other info (10+ rows of daily data from each user). The current method is very manual and involves excel file with 100+ sheets (1 sheet for each user or so) and several VBA modules for data cleaning. The clean data sheet is read by PC-SAS and some kind of scorecard report is being created out of this for incentive purposes. Almost 50 hours a month spent on this task.    I suggested that we could use Web app (typing, drop down selection, radio button etc.) to collect data from users. Once the data entered, the data can go to either SQL server or teradata or even SAS grid datasets directly (we own space in all).    Once we have data in any DW, it would be a piece of cake to clean the data and produce any kind of reports. However, I am stuck at the first step of creating web app. I am not sure what tool to use. I wanted to try the SAS stored process, WebDAV etc., but it involves multiple setup and web programming, those I tried didn't work well.    Is there any easy way to create this front end web app or any other ways this could be accomplished other than web app? I know there is some kind of SAS studio where you could drag and drop to create Java applications, but that studio is not available for us. Please suggest anything that is easier to develop in a week or less.    ... View more

  We are moving everything to SAS grid server from PC-SAS, SSRS, SSIS etc., to have a centralized repository of all programs, reports etc., in one place for the entire team.   We have some phone data from Avaya which comes from IBM Informix 2000 server. It works in PC-SAS with ODBC connection and a local OpenLink driver installation. However, when SAS admins try this connection they told us they could not establish this connection in the server. I am positive it is possible in the server side. I want to provide the admins some additional steps they could try.   If anyone has already established a connection from SAS grid to IBM Informix 2000 server, could you please provide some details? Thanks much.   ... View more

I have a teradata table with 1.5 billion rows of data. I need to filter this table on 1+ million account numbers, so I can only get those rows from the teradata table. The second table containing only the account numbers is in SAS locally obtained from a totally different DW.   I thought of using "intersect", but the issue is that the first table has several columns, and the second table got only one column containing account numbers, so it won't work. Then I thought of adding all account numbers into a macro and pass that in the explicit passthrough. But then the macro values will go beyond 32,767 character limit.   It seems I have to use implicit passthrough, but I want this to be done quick not taking hours. Is there any other ways this can be accomplished within a matter of minutes vs. hours? ... View more

I have a query text created by a upstream process that I don't have any control. I use the table that has a column holding that query text   Simple Example -- (select x,y,z where a.abc = (NEW) and b.xyz = (OLD))   But the query text column is infact very complicated normally around 1000 characters or so and has so many sub-select and where conditions.   The issue I have is the values for the where conditions are not quoted. Since I am moving them to SAS and proc SQL needs a quote on the where conditions if it is a string value, I wanted to translate this query to add quotes to all the character variable values --- unless if there is a workaround without adding any single or double quote. In that query text numeric values are being coded as strings, but in that case I don't want any quotes on them, rather I want to convert them to numeric values.   Can someone show a simple way to accomplish this? my co-workers are trying bunch of regex and tranwrd etc., but I thought that is complicated. Thanks! ... View more

Anyone here experiencing SAS EBI tools especially SAS BI Dashboard, WRS, STPs etc., are really slow. Here admin says they use JBOSS as mid-tier and web-tier also in there. I am not really familiar with all these. According to them, when the 9.4 upgrade happens it might be faster, just a hope.   Why SAS even develop these tools if it is dead slow in bringing in 10 rows and 2 columns visual via BI Dashboard? Some reports got 4-5 static and dynamic prompts, but even the one without prompts takes time.   Sometimes, it takes 5-10 minutes to see this small (10x2 table) info map based BI Dashboard. I am not sure if this is an issue with these SAS tools or issue on the JSP pages (?) on the browser side or web-tier side.   Can someone shed some lights? Thanks!    So far, I advised admins to look at: 1) Multi-threading on the web-tier 2) Increase memory on the web-tier 3) Enable caching on the web-tier   ... View more

WARNING: Email: 552 5.3.4 Error: message file too big   I am getting this WARNING in the SAS log in one of the batch processes. This has 2 excel file attachment -- one is 9MB size and the other one is 100KB size. I don't want to reduce the file size, as most of them are required. When I changed it to CSV, the size is almost doubled, so it is not an option. Right now it uses proc export to xlsx file and then attach via filename email statements.   The program abends due to this issue and does not send any emails. I had to manually run from EG and it works fine from EG. Can anyone suggest a work around for this without removing columns in excel file?   I am looking for options where you tell SAS to ignore these warning or use larger than 10MB file size, but could not able to find one.   Thanks.     ... View more

I have some ideas that I wanted to implement in my team where I am leading the SAS projects.   Here is what we have now:   1) Our group has so many excel files  - all involve much of manual interventions of users adding comments, new data rows etc. 2) These files are being used by PC-SAS with some manual intervention and then the PC-SAS program process them and create a new excel file and store them in network drives for users   Solution I am thinking:   1) To avoid these manual interventions, I wanted to bring the web applications instead of users manually entering the items in excel. 2) Then the user responses should be captured into a SAS dataset directly from web apps. 3) The SAS program runs and send out the processed excel file to the Windows virtual drive directly   I have been looking for web apps that can integrate with SAS grid server. I know that HTML web forms can be easily added on the SAS stored processes (_webout), but it is getting complicated for me when I tried complex table. I am looking something simple for everyone to use in the team. The SAS skill level is really low among all others, so I will have to develop all these myself if I use the SAS stored process route.   Is there any GUI based application where we can develop Web apps and the results can go to SAS dataset directly? I am looking like drop down, radio button, blanks etc., in the web app, so they can be captured into SAS dataset and stored.   Does SAS offer any tool like this?   Thanks.   ... View more

I am trying to create a PDF file using ODS PDF containing proc report. This proc report is within a macro having 2 parameters for different employee. One of the columns uses format= option where the format obtained from a dataset having a column with the href text as below.   I am using this in the proc sql to obtain the dynamic hyperlink format "<a href='R"||trim(left(put(id,3.)))||".pdf'>"||trim(left(put(id,3.)))||'-'||trim(left(projname))||' ['||trim(left(status))||']'||"</a>" as label   ODS HTML shows fine with the hyperlink. However, using the same code with ODS PDF the hyperlink does not show up, instead I see the actual text/tags like this: <a href='abc.pdf'> The ABC PDF file </a>   How can I get the PDF to show the hyperlink within each row for the entire column. The hyperlink is basically the pdf files stored in previous steps. I remember doing similar kind long time ago, but can't able to wrap my head around to figure this out googling.   can someone please help? Thanks. ... View more