About rajiv436

rajiv436 · ‎05-15-2018

Hi Ronein, Below code help you to get desired output. data Desired; length cat $50.; do until (last.ID); set aaa; by ID notsorted; cat=catx(',',cat,Stop); end; drop Stop; run;

rajiv436 · ‎03-19-2018

Just got it . Thank you

rajiv436 · ‎03-19-2018

table 1 have input as below code; 1 2 3 table 2 have input as below item_no; 100 101 102 required output as code item_no; 1 100 1 101 1 102 2 100 2 101 2 102 3 100 3 101 3 102 Any help will be really appreciated. Thank you

rajiv436 · ‎02-09-2017

Hi, I wanto run SAS Stored processes on a JAVA based web portal. This is open portal, accessible to every one. Please Suggest the best possible way. I am using SAS 9.3 .

rajiv436 · ‎01-10-2017

Hi, In my SAS EG Program Editor window code automatically erased withou any human action, But in log window my code is available and in the Results Window output is displaying. Please let me know how can I import log into the Program Editor window. Regards, Rajiv Santosh.

rajiv436 · ‎06-24-2016

AS per the update from SAS Technical support, To generate the values dynamically, the table used in the prompt should belongs to the same library of other tables used in the program, I already have the program in the same manner, then also it won't work. May I get any additional information to resolve this issue.

rajiv436 · ‎06-17-2016

That Library is already registered with Meta data. Please find the code below we are using.

rajiv436 · ‎06-17-2016

Hi , We've a problem in stored process excecution. we have selected a dynamic list in one of the prompts, In that the values are not retrieving to display from the selected table of dynamic list. Selected table for dynamic list and other tables used in the stored process belongs to same library. Key points: we are successfully getting the values list in the prompt only before the exection of using Library with libname statement. If we're not executing the libname statement, before running the storerd process its not poping the list in the prompt. Here I've attached some screenshots and the code used in the stored process.

rajiv436 · ‎06-07-2016

HI Ballard, path should be the same as in _clientprojectpath to %include. Program saved in /home/sasdemo/egflow path Thank you ballard.

rajiv436 · ‎06-06-2016

goto file menu --> save as --> servers --> SAS App server --> EGFlow --> (desired folder location) --> programblk1.sas saved.

rajiv436 · ‎06-06-2016

HI, Greetings to all, I'm unable to use .sas files into SAS App server (Linux platform) path. After saving the .sas file it's not visible with winscp tools and if i try to save again it is showing the file and asking to replace the file. If i try to use the .sas file in %include calling statement it pops the error as physical file doesn't exist. Is there any special permissions required to me my PC, If required how to check i've the access permissions or not ? May i get the solution from anyone of you.

rajiv436 · ‎05-02-2016

Hi Timmy, Stream option is enabled and I used %stpbegin and %stpend in my stored process program. In EG its working fine and generating output, but when I access through with Information delivery portal, it gives me such error msg. Find the screen shots also. Here I've attached my Stored process code.

rajiv436 · ‎05-02-2016

Hi Friends, I'm facing a problem with stored processes in IDP, it doesn't displays the output and generating below mentioned errors. Can you please help me. NOTE: Writing HTML Body file: sashtml.htm ERROR: File is in use, /SASCONF/conf93/Lev1/SASApp/sashtml.htm. ERROR: No body file. HTML output will not be created. NOTE: The SAS System stopped processing this step because of errors.

rajiv436 · ‎04-05-2016

Thanks KurtBremser. I got the a very smart answer from you and came to know another way with PC files server. May i know how to use PC files server for excel files import ? Where can i get the detailed information about it? Thanks alot for the above information.

rajiv436 · ‎04-05-2016

Hi, I'm trying to import several files into SAS EG 5.1 from local machine, after executing proc import procedure i'm getting the below error. 15 proc import datafile='C:\Users\admin\Desktop\CpiSampleData.xls' out=asdf dbms=xls; 16 run; ERROR: Physical file does not exist, /SASCONF/conf93/Lev1/SASApp/C:\Users\admin\Desktop\CpiSampleData.xls. NOTE: The SAS System stopped processing this step because of errors. If i use dbms as excel it pops the error not a valid dbms. 15 proc import datafile='C:\Users\admin\Desktop\CpiSampleData.xls' out=asdf dbms=excel; ERROR: DBMS type EXCEL not valid for import. NOTE: The SAS System stopped processing this step because of errors. Please help on this.

Online Status	Offline
Date Last Visited	‎08-01-2018 05:11 AM

Re: Concatenate

Re: Joining tables

Joining tables

How to run storedprocess on JAVA based web portal

Importing DATA(code) from SAS Log file to Program Editor window

Re: Stored Process Prompt issue

Re: Stored Process Prompt issue

Stored Process Prompt issue

Re: Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise...

Re: Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise...

Re: How to run storedprocess on JAVA based web portal

Re: Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise...

Re: Stored Process output display issue in IDP

Re: Concatenate

Re: Joining tables

Joining tables

How to run storedprocess on JAVA based web portal

Importing DATA(code) from SAS Log file to Program Editor window

Re: Stored Process Prompt issue

Re: Stored Process Prompt issue

Stored Process Prompt issue

Re: Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise...

Re: Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise...

Unable to SAVE&Re-Use .sas files into SAS APP server in Enterprise Gui...

Re: Stored Process output display issue in IDP

Stored Process output display issue in IDP

Re: Importing several files into SAS

Importing several files into SAS