About kumarsandip975

kumarsandip975 · ‎01-05-2023

I was following to this post : Get last SAS logins of users and clients - SAS Support Communities I need to do it on windows platform, can you please suggest how to get the user's last login data from SAS Studio on a month basis. So, let's say we have 200 users on SAS metadata, I can extract for sure(SAS administrators tip: keeping track of SAS users), but how to script in power shell to get the user's last login on SAS Studio by reading metadata logs. Help would be appreciated.

kumarsandip975 · ‎01-04-2023

@fja I am not worried about year as of now, as month wise data already I have. I just need to filter data of different system and sum the size. So, If I have a way to do the same for one month , I can do it for another month. Note: Also, it;s not mandatory to write output like this, I would be okay with as follows as well. System Size CXV 634.1 Gb LZ0 3787.6 GB QZ0 58.72 GB

kumarsandip975 · ‎01-04-2023

Dear Members, Please help with some calculation here. Input Data: Here we have different systems (not only three, but it is also more than that), per system code we have some data in terms of GB with different dates. I have to calculate total "Size" for each "system" per month (assume here data is for Dec only). Date System Size 31/12/2022 CXV 158,9 Gb 31/12/2022 LZ0 947 Gb 31/12/2022 QZ0 14,68 Gb 30/12/2022 CXV 158,7 Gb 30/12/2022 LZ0 946,9 Gb 30/12/2022 QZ0 14,68 Gb 29/12/2022 CXV 158,4 Gb 29/12/2022 LZ0 946,9 Gb 29/12/2022 QZ0 14,68 Gb 28/12/2022 CXV 158,1 Gb 28/12/2022 LZ0 946,8 Gb 28/12/2022 QZ0 14,68 Gb Output: Date System Size Dec CXV 634.1 Gb Dec LZ0 3787.6 GB Dec QZ0 58.72 GB

kumarsandip975 · ‎12-26-2022

@SASKiwi It is happening on Query, not on download. I have verified removing download line, but same error.

kumarsandip975 · ‎12-23-2022

@Kurt_Bremser , Ideally this macro definition is %logon_macro correct, there is no issue with macro. That is being called in backend.

kumarsandip975 · ‎12-23-2022

Hello, Can you please suggest possible reason to get the following error while executing below query. %GLOBAL conn_table; %logon_macro(SSKC, JX123456, {SAS002}2XXXX04E3xxxxxxx2C19BCE799); rsubmit; options db2ssid=DVC0 ; proc sql; create table LAND_KD as select * from connection to db2( select distinct substr(KODE_WD,1,2) as CUSTOMER_COUNTRY_CODE ,substr(EN_OMS_TK,1,35) as CUSTOMER_COUNTRY_DESC from qera.Cabcdf where kode_nm = 'ISO-LAND-KD' ); disconnect from db2; quit; proc download data= LAND_KD; run; endrsubmit; ERROR: NOTE: Remote submit to SSKC commencing. ERROR: Conversation termination; status=1. ERROR: A link must be established by executing the SIGNON command before you can communicate with SSKC.

kumarsandip975 · ‎11-29-2022

@s_lassen thanks. I tested with your suggestion, it is working fine with sort length value between code= and &session_state, but I have approx 700+ charater string between these two keywords. Can you please suggest, how to deal with long characters values.

kumarsandip975 · ‎11-29-2022

Hi Everyone, Could you please suggest how to extract Following highlighted part only. This abcdxy will always between code= and &session_state. login.microsoftonline.com/common/oauth2code=abcdxy&session_state=ab123bf2345

kumarsandip975 · ‎11-26-2022

Thanks for detailed explanation. 🙂

kumarsandip975 · ‎11-25-2022

We are using SAS STUDIO 3.81 Version.

kumarsandip975 · ‎11-25-2022

Hi, Is there any way we can create stored process with SAS Studio? Can somebody suggest. TIA.

kumarsandip975 · ‎11-25-2022

May be I can give you complete requirement. 1. I am setting up a solution to access sharepoint site from sas studio. 2. This setup will require token.json file, which is kind of manual task which every user has to generate/refreshed(it will expire when user is changing password). 3. As per blog post, https://communities.sas.com/t5/SAS-Communities-Library/How-to-use-SAS-to-access-Microsoft-365/ta-p/667869 , I have configured everything and able to access sharepoint site as well. 4. I want to automate tokennization process , this process has two part: 4.1 get the authorization url 4.2 from authorization url response , get the auth_code This process really challanging for every other users , so I am thinking to automae bit, may be If I can get sutorization url response like some kind og pop-up through some process so that user can use the same in auth_code.

kumarsandip975 · ‎11-25-2022

I want to get the new link to be appear on new tab or new window.

kumarsandip975 · ‎11-25-2022

Hi, I want to call below html code, may be I can have this in html file. Can you suggest to call these html code through SAS. TIA. <html> <head> <title>Open URL in New Tab </title> </head> <body> <p> Click the button to open <b> SAS Site </b> in new tab </p> <button onclick="NewTab()"> Open Here to open SAS S*ite </button> <script> function NewTab() { window.open( "SAS: Analytics, Artificial Intelligence and Data Management | SAS", "_blank"); } </script> </body> </html>

kumarsandip975 · ‎11-22-2022

Hi, Can anyone suggest how to exit from program in case file does not exit. I have some other include statement, based on file existance, I need to proceed to next program call. filename ip_file '&ip_folder.\&file.'; %if (%sysfunc(fexist(ip_file)) eq 0) %then %do; %put ERROR: Physical file does not exist ==> &ip_folder.\&file. ; %end; %include "someother program/abcd.sas";

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.

Get last SAS logins of users

Re: Coding help

Coding help

Re: ERROR: Conversation termination; status=1.

Re: ERROR: Conversation termination; status=1.

ERROR: Conversation termination; status=1.

Re: Extact strings

Extact strings

Re: Create stored process with SAS STUDIO

Re: Create stored process with SAS STUDIO

Create stored process with SAS STUDIO

Re: How to call html code/file from sas.

Re: How to call html code/file from sas.

How to call html code/file from sas.

ERROR HANDLING WITH FILE EXISTANCE