Hi,   We have SAS Grid installed on the RHEL linux servers and like to setup some monitors on the linux server to ensure that all the required SAS Services/process on the Compute nodes, metadata servers and Mid-tier are up and running.  Could someone provide me the list of sas services/Process that we need to monitor on the linux server. Do we need to monitor any ports too?   Thanks   ... View more

I'm trying to create a random dataset with 1000 observations and 3 variables(Employee_id, sex, age). I want the employee_id to be in the range (5213 to 9899), sex (as male,female or unknown) and age in between 25 to 75. Is there any function/sas proc thru which i can achieve this? I want the employee id to be random rather than consecutive.Thanks for help ... View more

I'm running the below code on sas 9.3 and encountering error message Please let me know how to trouble shoot it libname abc "xyz\abc\sample"; proc sort data = abc.accinfo out = accinfo_accts; by acct_no key_id; run; Error:Expecting page 5172, got page -1 instead Error: Page validation error while reading abc.accinfo Error: File abc.accinfo.data is damaged.I/O Processing did not complete. Note: The sas system stopped processing this step because of errors Note: There was 134234343 observations read from the data set abc.accinfo Warning: The data set work.accinfo_accts may be incomplete. When this step was stopped there were 134234343 observations and 20 variables ... View more

I'm trying to read a xlsx file using the libname statement. here is the sample code: " libname test1 PCFILES type=excel server = 'servername' port = 8261 path = "c:/test/dfsaa.xlsx"; I did run the proc setinit; It showed sas/access to pc files. BUt I'm still encountering the error message. plz help me on this ... View more