About adityaa9z

adityaa9z · ‎08-13-2020

Hi. I have to use it on a daily basis for different datasets so adding this code doesn't seem a viable solution which I why was hoping for a macro instead.

adityaa9z · ‎08-13-2020

Hello everyone, Has anyone worked on a macro before that helps us identify missing values for different column in a dataset. Hoping to get an intuitive macro which tells how many and row number where values are missing. Example Name Age Sex. If there are 2 values missing in name, 4 in age and 5 in sex, the macro should be able to tell this info. Planning to use in my code once the final dataset is ready so I can just run this macro and check for missing fields, values.

adityaa9z · ‎04-09-2020

Hi all, I have a text. "ADITYA SASUSER EG" which could be split over multiple lines or it could be in the same line so I am pulling this using upper(line1)||upper(line2)||upper(line3)||upper(line4) like '%ADITYA%SASUSER%EG%' but i would like to improvise it more so if the name is ADTYA SASUSR EG or just SASUSER EG or other spelling mistakes, it still gets pulled. Can you please help me with a logic to do this? Thanks, Aditya

adityaa9z · ‎02-12-2019

Want to read it as DateTime. Want to Write as mmddyy10.

adityaa9z · ‎02-12-2019

Hi Can someone help me with using the informat for this date ? Feb 5 2019 12:00AM Also I need the output in mmddyy10. format? Thanks in advance

adityaa9z · ‎07-24-2018

Thanks. This should work since my DS is sorted by Y

adityaa9z · ‎07-24-2018

Hi team, I have a table HAVE with lets say two variables X Y 1 A 2 A 3 A 4 B 5 C 6 C 7 D In the output WANT I only want the ones which have distinct Y value OUT 4 B 7 D

adityaa9z · ‎07-05-2018

Hi all, I want to understand how can I split a dataset into multiple datasets in different percentages. Say I have a dataset Have and I want to split it into first 20% and rest equally into 3 parts. Thanks in advance

adityaa9z · ‎08-09-2017

Hi Chris, Below is the log. NOTE: Remote submit to SESS2 complete. ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [CONNECT ] Segmentation Violation Traceback of the Exception: /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sas() [0x5280fe] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sas() [0x41f0ee] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2b80c07dd5d4] /lib64/libpthread.so.0() [0x321000f7e0] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasods(+0x9a869) [0x2b8150eaa869] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasods(wobmth+0x57) [0x2b8151060417] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasods(vector+0x27a) [0x2b8150ec4bda] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasxkern(ypoutf+0x6d2) [0x2b80d09428d2] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasxkern(ypprnx+0x144) [0x2b80d094bc74] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sasxkern(yppflsh+0x77) [0x2b80d094ba77] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/saszrlnk(+0x93144) [0x2b8105366144] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/saszrlnk(lsbsfls+0x392) [0x2b8105365a52] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/saszrlnk(ls+0x1c88) [0x2b810535eba8] /sso/sfw/sas/940/SASFoundation/9.4/sasexe/sas(vvtentr+0x101) [0x41ed01] /lib64/libpthread.so.0() [0x3210007aa1] /lib64/libc.so.6(clone+0x6d) [0x320fce8aad] When I googled this error it was mentioned that removing wait=no option should fix this, but doing that runs the sessions sequentially and not parallely.

adityaa9z · ‎08-09-2017

Hello experts, I wanted to ask about the parallel sessions in SAS and how to make it work, with wait =no option. I tried running 3 sessions in parallel using : %LET rc=%sysfunc(grdsvc_enable(_ALL_,server=SASAPP)); signon sess1 inheritlib=(Work=locwork otp=otp); signon sess2 inheritlib=(Work=locwork otp=otp); signon sess3 inheritlib=(Work=locwork otp=otp); rsubmit sess1 wait=no; ***************************************************; * Code for session 1 *; ***************************************************; endrsubmit; rsubmit sess2 wait=no; ***************************************************; * Code for session 1 *; ***************************************************; endrsubmit; rsubmit sess3 wait=no; ***************************************************; * Code for session 1 *; ***************************************************; endrsubmit; waitfor _all_ sess1 sess2 sess3; signoff _all_; ***************************************************; * common code after al sessions have completed *; ***************************************************; However it kept failing until I removed the wait=no option, and that essentially made the session run sequentially one after the other instead of running them in parallel. This can be a big efficiency booster for many of my codes, if we can get this figured by experts from SAS. Thanks a bunch all

adityaa9z · ‎07-20-2017

Thanks Art. But the data is already present in the tables which is why I need to find a way around it.

adityaa9z · ‎07-20-2017

Hi all. Need a solution for Merge operation i Need to perform on a varaible. Below is the Dataset A VAR_1 123 456 789 1 34 45 Below is Dataset B (Please note, some values are separated by comma ) VAR_1 123,456,345 789,2 34 67 The output should look like below.(It should look for Var_1 values from A, try and match with VAr_1 from B and if they dont match, it should output) VAR_WANT 345 2 67 Please suggest an efficient way to do this.

adityaa9z · ‎07-09-2017

Right. Year info is available too. I just didnt include it here since it was an example. I am interested in checking a value of "Yes" for rex in last 3 days and if that happens.. A value of ram <> r in the past 6 days. if these both conditions match.. the value for ram today will be r.

adityaa9z · ‎07-09-2017

1) Date is not the part of dataset. I am calculating it from today -3 days and today - 6 days. 2) Its just a single dataset. Records get appended to it daily. So if today is 1/1/2017. Records for 12/31/2016 will get appended to A. 4) Its a single dataset, has a million records and records get appended to i daily.. Also, take for example Below are the records which already exist in the DS date rex ram 12/26 Yes . 12/27 Yes r /*(Has rex as yes in past 3 days and ram <> null in last 6 days, so ram is populated as r)*/ 12/28 No . 12/29 Yes r /*(Has rex as yes in past 3(12/27) days and ram <> null(12/26) in last 6 days, so ram is populated as r)*/ 12/30 No . 12/31 No . 1/1 No . 1/2 Yes . /*(rex is no in past 3 days so ram is null)*/ Let me know if this helps. 🙂

adityaa9z · ‎07-09-2017

Hello Experts, Need a suggestion ,regarding one of the programming logics I need to figure out. There is a dataset named A and in A there is variable named rex, which has values Yes or No and a variable named ram which has a value of r or Null. 1) If in the last THREE days, the value of rex is Yes, then we have to check the following conditions. --Check whether the value of rex was "Yes" in the past SIX days AND value of ram was not equal to "r", - If this condition matches, then the value of ram should be populated as "r", else Null. 2) If not the value of ram stays as null. The jobs runs daily for each day, so the data will check the previous days to match the conditions and populate the values of ram based on it. Please let me know if this makes some sense or if you have more questions around it.

Online Status	Offline
Date Last Visited	‎08-13-2020 11:44 AM

Re: Macro to Identify missing values

Macro to Identify missing values

BEST WAY TO SEARCH STRING

Re: SAS Date Format

SAS Date Format

Re: Remove duplicates

Remove duplicates

Split datasets into multiple small datasets

Re: SAS Parallel Sessions

SAS Parallel Sessions

Re: SAS Date Format

Re: SAS Parallel Sessions

Re: Effective Merging Techniques

Re: proc sql question

Re: Blank datasets created

Re: Swap values using PROC SQL

Create a function lead

Re: Macro to Identify missing values

Macro to Identify missing values

BEST WAY TO SEARCH STRING

Re: SAS Date Format

SAS Date Format

Re: Remove duplicates

Remove duplicates

Split datasets into multiple small datasets

Re: SAS Parallel Sessions

SAS Parallel Sessions

Re: SAS Merge logic

SAS Merge logic

Re: SAS Logic question

Re: SAS Logic question

SAS Logic question