About sasprofile

sasprofile · ‎07-04-2016

Hi Jan, Thanks alot for the prompt reply. I have few doubts I want to clarify with you Is the SAS servers stop and start order is correct which I mentioned in my previous email? Do I need to take backup of all files including SASHome, platform(gmsinstall, Sharedgrid, lsf,pminstall...etc) along with config files of all servers(Metadataserver,Grid master & Midtier) (or) just grid master is enough since am running setup file on SAS grid master. And when it asks for option in the windows clicking Next during my configuration do I need to select existing config lev1 which is in our current grid master location and also in my requirement am supposed to setup the saswork and sasutil files for the new Appserver,where do i need to setup these,do i need to setup in SMC or in Server. You mentioned in your previous email saying that "We work according to the best practice of sharing the SASConfig between all grid nodes, in which case this would the only time you need to run the SDW". (so what exactly you mean when you are saying I need to run SDW)....For your information our Grid Master and Nodes are in NFS for Install and config directories Do I need to select OLAP and connect server also as part of the this new app server context configuration (or) I can use the previous OLAP and connect server components for the new SASApp server. and coming to port numbers I think for OLAP and Connect server i should use unique port numbers not the same port numbers which we used in our default application server and port numbers for workspace servers and pooled wss and stored process sever I believe we can use the same previous port numbers or new port numbers if am not wrong. but in case If i have to use new port numbers for all the server components of new SASApp Server,do I need to use the next sequence number of the existing port numbers of server components in default application server or it's something different. and to Save a response file for later reference I believe below is the command right for the response file to ./setup.sh -deploy -record -responsefile /path to response file/respfile.txt I Would appreciare if you can clarify my above doubts Thank you

sasprofile · ‎07-03-2016

Hello friends, Please help me I need your assistance in Adding Additional SAS Application Server in our new SAS 9.4 environment. I got a requirement to add a additional application server into a new SAS 9.4 environment. This is the first time am doing this configuration It would really a big help to me if you can guide me. and I did not find a specific doc in sas support which can help me with this configuration, I found a doc but it does not provide enough information for this Application server configuration our environment has Total six servers MetadataServer, Grid Master Server, Grid Node 1 Server, Grid Node 2 Server, Grid Node 3 Server, Midtier Server we already have a default application server in SMC and since object spawner is already there so am using same object spawner for the new Application server. below are initial steps am performing to add the Application server. Please correct me if am wrong with any of the below initial stepse, I would really appreciate if anyone can correct me if am wrong. 1) First I will be Taking the Metadata backup from the SAS Management console 2) Second I will be stopping all the below Servers in the below order Midtier Server Grid Node 3 Server Grid Node 2 Server Grid Node 1 Server Grid Master Server Metadata Server 3) Next I will be taking the Config,SASHome, Install files backups from Metadata Server, Grid Master Server and Midtier Node 4) Next I will be restarting the servers in the below order MetadataServer Grid Master Server Grid Node 1 Server Grid Node 2 Server Grid Node 3 Server Midtier Server 5) Then Next I will be running ./setup.sh file from the SAS Grid Master Server to launch Deployment wizard When the Deployment wizard launches select the options as described below a) First option Select Install Software b) Second Select a previously created SASHome c) Next select first radio button Perform a Planned Deployment under this uncheck Install SAS Software checkbox and select only Configure SAS Software d) Next Select first radio button Specify the full path to a customized deployment plan e) Next step under Deployment Step I see below options, from this If am not wrong I should select 2nd option SAS Grid Control and LSF Master Server SAS MetadataServer SAS Grid Control and LSF Master Server SAS Grid Manager Node Servers SAS Middle Tier Server SAS Middle Tier Server Node SAS Clients SAS Grid Manager Client Thank you in Adavnace for all your help

sasprofile · ‎06-17-2016

I have already reinstalled SMC on my machine,but that did not resolve the issue.

sasprofile · ‎06-16-2016

Hello, I have any issue with SMC,I installed recently SAS 9.4 successfully without any issues on my machine. for the first 2 times SMC opened without any issues,but after that when I tried to open SMC the management console screen launches but it never moves further it stays at the first screen only for hours and the screen won't go away until I reboot. but sometimes when the screen stays there only and if I try to open SMC once again it opens but the first screen will stay there only it won't go until I reboot. I think it could be Java related since SMC is Java based client. currently below Java versions installed on my machine and I have SMC 9.3 that works perfectly on same machine.am not sure whether below versions are supported or not for SMC 9.4 Java 6 update 24 Java 6 update 43 am not sure where it's going wrong,I would appreciate if you can help me with this issue Thank you

sasprofile · ‎05-23-2016

Tomkari Tons of Thanks to you for the clarification and the solution

sasprofile · ‎05-22-2016

Thank you very much Tomkari for the solution,I truly appreciate that. so can i use this program for performance testing without any changes to the code or do i still still need to make any changes. and I beleive the below do count = 1 to 1250000 Is not 250 MB right. Its 1.25 GB right if am not wrong. am looking for 250 MB and 25 GB data. data Test250MB; do count = 1 to 1250000; a = rand('uniform'); b = rand('uniform'); c = rand('uniform'); d = rand('uniform'); e = rand('uniform'); f = rand('uniform'); g = rand('uniform'); h = rand('uniform'); i = rand('uniform'); j = rand('uniform'); k = rand('uniform'); l = rand('uniform'); m = rand('uniform'); n = rand('uniform'); o = rand('uniform'); p = rand('uniform'); q = rand('uniform'); r = rand('uniform'); s = rand('uniform'); t = rand('uniform'); u = rand('uniform'); v = rand('uniform'); w = rand('uniform'); x = rand('uniform'); output; end; run;

sasprofile · ‎05-22-2016

Thanks for reply...I don't have data...I need sample data also if possible along with programs.actually I need to do performance testing on our legacy systems Vs the new upgraded system.so that's why I need those programs.

sasprofile · ‎05-21-2016

Please can someone help me with a couple of sample sas jobs which can you use 200-300 MB and other job like 20-25 GB of data. I need them for performance testing,am not good at programming. It would be a big help to me if someone can share withe me. Thanks Swati

sasprofile · ‎05-19-2016

Hello Friends, I have same kind of issue when am trying to import and export excel files from Grid node to PC file server. below are the codes am using,but not sure where its going wrong. proc export data= sashelp.prdsale; dbms=xls; outfile="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxxxxx"; sheet=sheet1; run; proc import dbms=excelcs datafile='D:\pcfile\Demo.xls' out=\tmp REPLACE; port=xxxx; server="xxxxxx"; sheet=sheet1; run; These are the error am getting,any suggestions or advice would be really appreciated. Proc import dbms=excelcs data='D:\pcfile\Demo.xls' ---- 22 76 Error 22-322 Syntax error,expecting onc eof the following: ;,DATAFILE,DATATABLE,DBMS,DEBUG,FILE Error 76-322 Syntax error,statement will be ignored outfile=\tmp REPLACE; port=xxxx; server="xxxxxxx"; run; server proc export data=sashelp.prdsale; Error:FILE or TABLE is required and must be specified. dbms=xls; file="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxx"; sheet=sheet1; run; Thank you

sasprofile · ‎05-19-2016

Thank you Terho, I want to import file from PC file server to Grid node In the code provided you have not mentioned the pc file server port and server name. and also does import works in this case for csv file..I believe it works only with excel and access files.

sasprofile · ‎05-19-2016

Thank you so much for your prompt reply When I used below code for import from grid node to pc file server by launching sas on node,am getting below error proc import dbms=excelcs data='D:\pcfile\Demo.xls' outfile=\tmp REPLACE; port=xxxx; server="xxxxxxxxxxx"; sheet=sheet1; run; Proc import dbms=excelcs data='D:\pcfile\Demo.xls' ---- 22 76 Error 22-322 Syntax error,expecting onc eof the following: ;,DATAFILE,DATATABLE,DBMS,DEBUG,FILE Error 76-322 Syntax error,statement will be ignored outfile=\tmp REPLACE; port=xxxx; server="xxxxxxx"; run; when am using below export code am getting below error proc export data= sashelp.prdsale; dbms=xls; file="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxxxxxxx"; sheet=sheet1; run; proc export data=sashelp.prdsale; Error:FILE or TABLE is required and must be specified. dbms=xls; file="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxx"; sheet=sheet1; run; am not sure where its going wrong,would appreciate if you can suggest

sasprofile · ‎05-19-2016

Hello Friends, Am trying to import excel file from 9.4 SAS Grid control node to PC File server,I tried various to import the file but the none of the code is working.Its giving so many issues. I tried below code to import, I would really appreciate if anyone can assist me in regards to this please send me the correct code for exporting file from PC file server to Grid control node also. I tried all the codes given in the support websites also but none of them worked,not sure where its going wrong PROC IMPORT DBMS=EXCELCS DATA= 'D:\pcfile\Demo.xls’ OUTFILE= \tmp REPLACE; PORT=xxxx; SERVER='xxxxxxxxxx'; SHEET='yoursheet'; RUN; Thank you

sasprofile · ‎05-11-2016

Ok thank you very much,it worked for me.

sasprofile · ‎05-08-2016

Hello everyone, I have an issue with the SASHFADDwn.exe file when I downloaded and ran from the below link When I ran and unzip the file SASHFADDwn.exe on my pc, the files generated shoud be normally SASHFADD.exe and SASHFADD.cfg. but the files actually not generating with proper extensions, the SASHFADD is generating without any .exe extension and SASHFADD.cfg even though its generated with extension .cfg,the file looks like its not editable. please find attached how these files looks like. am not understanding where the problem is I would really appreciate if anyone can assist me with this issue http://ftp.sas.com/techsup/download/hotfix/HF2/SASHFADD.html Thanks everyone on advance

sasprofile · ‎05-05-2016

Hello friends Is there any process in sas 9.4 M3 environment for determining what hotfixes are required for server level and client level products. I need to find out the applicable hot fixes to our SAS 9.4 environment depending on the products we currently have. your inputs would be greatly appreciated Thank you Ramu

Online Status	Offline
Date Last Visited	‎01-17-2024 03:09 AM

SAS products usage by who and when

Re: Migrating from Viya 3.5 to 4.0 what is the best Deployment scenar...

SAS 9.4 vs SAS Viya performance

Re: Migrating from Viya 3.5 to 4.0 what is the best Deployment scenar...

SAS 9.4 M6 Functional difference with SAS Viya

Re: Executing python code from SAS Environment

Re: Executing python code from SAS Environment

Re: Executing python code from SAS Environment

Executing python code from SAS Environment

Re: Can not open data set

Re: Regarding SAS VA Sizing Questionnaire

Re: Regarding SAS VA Sizing Questionnaire

Re: Forgot my Internal account sasadm password

Re: Performance Metrics in SAS Grid 9.4 M3

Re: GIT Version Control Integration with SAS Enterprise Guide 7.13

SAS products usage by who and when

A00-250 – SAS Platform Administrator Certification

Re: Querying the metadata for a list of users and groups

Regarding SAS VA Sizing Questionnaire

Forgot my Internal account sasadm password

Re: Adding Additional SAS Application Server in SAS 9.4

Adding Additional SAS Application Server in SAS 9.4

Re: SAS Management console 9.4 does not open

SAS Management console 9.4 does not open

Re: Large SAS Jobs for Performance Testing

Re: Large SAS Jobs for Performance Testing

Re: Large SAS Jobs for Performance Testing

Large SAS Jobs for Performance Testing

Re: import /export error

Re: Issues with SAS Import/Export from Linux to PC File server and PC ...

Re: Issues with SAS Import/Export from Linux to PC File server and PC ...

Issues with SAS Import/Export from Linux to PC File server and PC to L...

Re: Process for determining required Hotfixes in SAS environment

Issues with SASHFADD

Process for determining required Hotfixes in SAS environment