About kumarsandip975

kumarsandip975 · ‎05-29-2023

All, May I know if there is a way to setup a display warning Message for Inactive User sessions in SAS Studio.

kumarsandip975 · ‎05-28-2023

Can you please help me the below requirement. I need to store date values as below. data t1; validfrom=<firstdayoflastmonth> e.g 01APR2023; ValidTill=<lastdayoflastmonth> e.g 30APR2023; run; already, I have another dataset , where above two variables (validfrom and validtill) have dates. I need to concatenate both of them. I used something, but this is storing as character, and unable to concatenate. %let firstdayofthelastmonth = %sysfunc(intnx(month,%sysfunc(today()),-1),date9.); %let lastdayofthelastmonth = %sysfunc(intnx(month,%sysfunc(today()),-1,e),date9.); %put &firstdayofthelastmonth.; %put &lastdayofthelastmonth.; Kindly suggest.

kumarsandip975 · ‎05-25-2023

Hi, Can somebody suggest, how to find the current authentication protocol we are using (SAS 9.4 M6 on Linux/RedHat 7.9 ).

kumarsandip975 · ‎05-25-2023

Can you please suggest whether the current version of our SAS 9.4 M6 on Linux/RedHat 7.9 environment supports the possibility of using Kerberos as authentication mechanism? This will help us to decide to move this into Kerberos as authentication mechanism. Thanks in Advance.

kumarsandip975 · ‎05-23-2023

o was typo, I mean if amount=0 then delete;

kumarsandip975 · ‎05-22-2023

I have amount columns as below, few amount column is 0(Zero) values, and some are more than Zero. I do not want Zero values from amount column. proc contents as below. # Variable Type Len Format Informat Label 5 amount Num 8 18. When I am using as below, still I see amount 0 is there in output and not deleting. May I know what I am missing here in condition. data want; set have; if amount=o then delete; run;

kumarsandip975 · ‎05-22-2023

Dear Co's, May I know, if it is possible in SAS studio to set up scroll speed for the open file? If we are working with big file, scrolling up and down can get kind of slow. Seems like there are some "pain“ points with big files and cursor in general.

kumarsandip975 · ‎05-12-2023

Could you please suggest with the following error message. we are trying to access below dataset on mainframe via JCLS. 10 DATA BESTUT.IN1; 11 INFILE TEST; 12 INPUT @1 CAPPL $5. 13 @6 CNIV $CHAR20. 14 @26 CTAAL PD2. 15 @28 TOMSCH $CHAR40.; Error : The library data set ABCD.DEF.FGHK is an extended format sequential data set. However, the SASE7 engine only supports DSNTYPE=BASIC or DSNTYPE=LARGE data sets. Encountered error when the V9 engine tried to determine if BESTUT has a registered secured library object location. Library BESTUT is not in a valid format for access method SASE7.

kumarsandip975 · ‎05-11-2023

Can somebody suggest some good materials, blogpost to go for SAS Admin interview questions and answer.

kumarsandip975 · ‎05-11-2023

data t1; length v1 $ 100; input v1 $; datalines; G:/Data/CXV/PGMS/CTS_Test/Scripts/ScannedFiles1.txt D:/Data/ABC/PGMS/CTS_Test/Scripts/ScannedFiles2.txt E:/Data/XYZ/PGMS/CTS_Test/Scripts/ScannedFiles3.txt C:/Data/DEF/PGMS/CTS_Test/Scripts/ScannedFiles4.txt F:/Data/JFK/PGMS/CTS_Test/Scripts/ScannedFiles5.txt ; run; I need to extract only folder, not file (which is last ). Can you please help. G:/Data/CXV/PGMS/CTS_Test/Scripts D:/Data/ABC/PGMS/CTS_Test/Scripts E:/Data/XYZ/PGMS/CTS_Test/Scripts C:/Data/DEF/PGMS/CTS_Test/Scripts F:/Data/JFK/PGMS/CTS_Test/Scripts Thanks in Adavance.

kumarsandip975 · ‎04-26-2023

data _null_; informat lastDayofTheLastMonth yymmddn8.; lastDayofTheLastMonth=intnx('month', today() , -1, 'E'); put lastDayofTheLastMonth; call symput('lastDayofTheLastMonth1',lastDayofTheLastMonth); run; %put &lastDayofTheLastMonth1; data have; INFILE 'Path\ScannedFiles_&lastDayofTheLastMonth1..txt' delimiter=',' dsd; input var1 var2 var3; run; I need to replace lastDayofTheLastMonth1 as yyyymmdd(e.g 20230331) in infile statement, when I am running above code, it's not resolving, kindly suggest. INFILE 'Path\ScannedFiles_20230331.txt' delimiter=',' dsd;

kumarsandip975 · ‎04-18-2023

Dear Members, I have below piece of inputs with comma separated entries with 5 columns. I need to extract only column first (e.g, ABC), four (e.g., 654), and fifth (e.g., 14/04/2023 14:17:14), can someone suggest best way to get these. Input: "ABC","DATA","G:\Data\ces 202302.csv",654,14/04/2023 14:17:14 "ABC","DATA","G:\Data\ces 202302.csv.bak",654,14/04/2023 14:00:41 "XYZ","DATA","G:\Data\ces 202303.csv",5770,14/04/2023 14:17:39 "XYZ","DATA","G:\Data\ces 202303.csv.bak",5770,14/04/2023 09:49:28 "DEF","DATA","G:\Data\CES individuele.xlsx",104637,23/03/2023 14:53:38 "DEF","DATA","G:\Data\CES.xlsx",23370,23/03/2023 14:53:19 "DEF","DATA","G:\Data\12GR.csv",539,08/02/2023 15:12:13 Output: "ABC",654,14/04/2023 14:17:14 "ABC",654,14/04/2023 14:00:41 "XYZ",5770,14/04/2023 14:17:39 "XYZ",5770,14/04/2023 09:49:28 "DEF",104637,23/03/2023 14:53:38 "DEF",23370,23/03/2023 14:53:19 "DEF",539,08/02/2023 15:12:13

kumarsandip975 · ‎01-26-2023

updated baselines for RHEL (must be at RHEL 7.5 or higher). And with M8, SAS 9.4 supports RHEL 9.1. ----> "Do you mean SAS 9.4 M8 will only be supported with RHEL 9.1? "

kumarsandip975 · ‎01-26-2023

Currently we are using SAS9.4 M6 which is running on the operating system Red hat Linux 7.9 Version. We are in planning phase to reinvest on the New Linux Servers 8/9, with Latest maintenance release and planning to go with same old architecture (2 Servers for Environment). As a part of the pre-Study, we need couple of clarifications/suggestion on below points. When is the Expected date of SAS9.4 M8 Release. For the Port numbers like, I guess we can use the same port numbers in new environment (to use in configuration time) which are currently present in the 9.4M6? If not, please advise on this. What are the different challenges respective to these migrations, which we should keep in mind. If you have any latest documents or links to our upgrade plan, pls share us.

kumarsandip975 · ‎01-06-2023

Dear Members, Can you please help how to create mainframe dataset through data step on SAS STUDIO. Note: I have already remote signon macro where I can login mainframe platform and code data step inside rsubmit/endrsubmit. Code sample: %remote_signon(); Rsubmit; LIBNAME LIB1 "MAINFRAME.PDS" ; Data LIB1.TEST1; Var1="ABCD"; run; Endrsubmit ;

Online Status	Offline
Date Last Visited	‎01-03-2026 10:59 PM

Issue accessing SASStudio application with Kerberos setup

Re: Integrated Windows Authentication in the Middle Tier

Re: Integrated Windows Authentication in the Middle Tier

Re: Integrated Windows Authentication in the Middle Tier

Re: Integrated Windows Authentication in the Middle Tier

Integrated Windows Authentication in the Middle Tier

Kerberos setup in SAS 9.4 M8(Hosted on Windows).

Need help to get desired output

Re: SMTP Server cannot be specified in 9.4

Re: Migration SAS 9.4 M6 to new machine.

Re: Migration SAS 9.4 M6 to new machine.

Re: Migration SAS 9.4 M6 to new machine.

Re: Migration SAS 9.4 M6 to new machine.

Re: SAS 9.4 M6 Standard support

Re: why smtp server configuration is required in sas

Migration SAS 9.4 M6 to new machine.

SAS 9.4 M6 Standard support

Re: why smtp server configuration is required in sas

why smtp server configuration is required in sas

Uninstall of instance of the SAS Web Application Server.

Display a Warning Message for Inactive User Sessions - SAS STUDIO

Store Date values in variables and concatenate

Current authentication protocol check

Question: Kerberos as authentication mechanism

Re: Unable to delete records.

Unable to delete records.

SAS studio to set up scroll speed for the open file

SAS on Mainframe ERROR

SAS Admin Interview Questions for Exp Profile

Extract folder search path from string

Programming Help

Programming help

Re: Details required for new installation/Configuration Linux Servers ...

Details required for new installation/Configuration Linux Servers 8/9 ...

SAS Mainframe : Create Permanent Dataset