cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Swapnil_21
‎04-14-2025
  • 36 Posts
  • 0 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Encoding issue while Extraction from Z/OS in SAS Studio

by Obsidian | Level 7 in SAS Programming
‎04-02-2025 02:17 PM
‎04-02-2025 02:17 PM
Remote is open_ed-1146 Local is utd-8 ... View more

Re: Encoding issue while Extraction from Z/OS in SAS Studio

by Obsidian | Level 7 in SAS Programming
‎04-02-2025 02:16 PM
‎04-02-2025 02:16 PM
I have run this in both. My remote is open_ed-1146 and local is utf-8 ... View more

Re: Encoding issue while Extraction from Z/OS in SAS Studio

by Obsidian | Level 7 in SAS Programming
‎04-02-2025 06:27 AM
‎04-02-2025 06:27 AM
It is open_ed-1146. However, your options dont work. it fails . Here is the log 144 data test2x /*view=test2x*/; 145 infile "PZLN.VMO00.POL1501" dsd encoding='utf8' recfm=s370v termstr=nl; ------- 23 ERROR 23-2: Invalid option name TERMSTR. 146 input @1 KEY $8. 147 @9 STATUS1 $1. 148 @10 STATUS2 $1. 149 150 @19 RECTIME $8. 151 @27 CKEY $13. 152 @40 RECADTE $8. 153 @48 RECATME $8. 154 @56 CERTRTRN $1. 155 @57 MEDDIABC $1. 156 ; 157 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEST2X may be incomplete. When this step was stopped there were 0 observations and 9 variables. WARNING: Data set WORK.TEST2X was not replaced because this step was stopped. NOTE: The DATA statement used 0.00 CPU seconds and 26458K. NOTE: The address space has used a maximum of 1004K below the line and 33612K above the line. NOTE: Remote submit to PROD_UX complete. ... View more

Encoding issue while Extraction from Z/OS in SAS Studio

by Obsidian | Level 7 in SAS Programming
‎04-02-2025 12:07 AM
‎04-02-2025 12:07 AM
We need to extract data from z/os mainframe. We are able to download the datasets. However, data looks unreadable.  Here is the code we are using  %let PROD_UX=ram189prd.gwd.grpinf.net 5668; %let MF=PROD_UX; signon &MF. user="abcd" password="welcome2sas"; libname rwork slibref=work server=PROD_UX; rsubmit &MF.; data test2x /*view=test2x*/;     infile "PZLN.VMO00.POL1501" dsd; input @1 KEY $8. @9 STATUS1 $1. @10 STATUS2 $1. @19 RECTIME $8. @27 CKEY $13. @40 RECADTE $8. @48 RECATME $8. @56 CERTRTRN $1. @57 MEDDIABC $1. ; run; endrsubmit;   Dataset is generated , however it looks  like this  ���� R � ��� ��� M240N24021201 �N������ ������ � � ���� Q A 13:08:17 M240N24021201     Y � ���� A M 13:08:17 M240N24021201     N � ���� Q A 13:08:17 M240N24021201 ��*D50 00000000 0 � ���� R � ��� ��� K620S36102402 �N������ ������ � � ���� P A 09:14:34 K620S36102402     N � ���� A M 09:14:34 K620S36102402     N � ���� A M 09:14:34 K620S36102402     N   Here is Proc contents output    Data Set Name RWORK.TEST2X Observations 304317 Member Type DATA Variables 9 Engine REMOTE9 Indexes 0 Created 02/04/2025 04:57:48 Observation Length 49 Last Modified 02/04/2025 04:57:48 Deleted Observations 0 Protection   Compressed NO Data Set Type   Sorted NO Label       Data Representation MVS_32     Encoding open_ed-1146 United Kingdom (OpenEdition)         I am running the code on SAS Studio. How do i encode this dataset in readable format. Any help is appreciated ... View more

Re: Transitive Dependency Finder using code

by Obsidian | Level 7 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-30-2022 09:07 PM
‎03-30-2022 09:07 PM
@RobPratt.. u r GOD... super awesomely working..... ... View more

Re: Transitive Dependency Finder using code

by Obsidian | Level 7 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-30-2022 09:07 AM
‎03-30-2022 09:07 AM
@Ksharp   The code works correctly as per requirement for given sample but it doesnt work for the actual data. Attached is the actual dataset. I should have flag for 21-BSE-CUST_WBC-00001  However, it doesnt show anything . Can you please check where I am doing wrong  ... View more

Re: Transitive Dependency Finder using code

by Obsidian | Level 7 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-30-2022 06:19 AM
‎03-30-2022 06:19 AM
It means if any of the element depends back to parent then it's transitive dependency. So third case has one element which points back to parent so it's not OK. First case does not have any dependency or missing dependency so it's OK ... View more

Transitive Dependency Finder using code

by Obsidian | Level 7 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-30-2022 05:06 AM
‎03-30-2022 05:06 AM
Hi,   Its plain transitive dependency finder task for me but somehow I am not able to generate the proper code E.g. A depends on B and B depends on A so this combination is transitive . C depends on D , D depends on E and F , E depends on C so this combination is also transitive. So I need to flag out such records irrespective of how much is the depth Below is the sample data  data have; input col1: $1. col2: $1.; datalines; A B P Q B A C D D E D F E C R  ; run;     Below is the output I want col1 col2 flag A B NotOk P Q Ok B A NotOk C D NotOk D E NotOk D F NotOk E C NotOk R   Ok   Any help is really appreciated ... View more

Re: Finding common value for a group

by Obsidian | Level 7 in SAS Programming
‎03-21-2022 10:15 PM
‎03-21-2022 10:15 PM
Here is the sample dataset data have; infile datalines delimiter=","; input Flow_Name: $256. Job_Name: $256. Dependency: $1024.; cards; CE_B3_STACK,90-IDM-STK_FMTS-00001, CE_B3_STACK,91-IDM-STK_FW-00001, CE_B3_STACK,92-IDM-STK_PRTY-00001,91-IDM-STK_FW-00001 CE_B3_STACK,93-IDM-STK_PRXY-00001,91-IDM-STK_FW-00001|92-IDM-STK_PRTY-00001 CE_B3_STACK,94-IDM-STK_B3_ASSET_CLASS-00001,90-IDM-STK_FMTS-00001|92-IDM-STK_PRTY-00001|93-IDM-STK_PRXY-00001 CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00001, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00002, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00003, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00004, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00005, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00006, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00007, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00008, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00009, CE_BSE_CUST_SGB,20-BSE-CUST_SGB-00010, CE_BSE_CUST_SGB,21-BSE-CUST_SGB-00001,20-BSE-CUST_SGB-00001|20-BSE-CUST_SGB-00002|20-BSE-CUST_SGB-00003|20-BSE-CUST_SGB-00004|20-BSE-CUST_SGB-00005|20-BSE-CUST_SGB-00006|20-BSE-CUST_SGB-00007|20-BSE-CUST_SGB-00008 ; run; ... View more

Finding common value for a group

by Obsidian | Level 7 in SAS Programming
‎03-18-2022 03:10 AM
‎03-18-2022 03:10 AM
Hi , I have table which has flow name , job name and dependency as columns, I need to find if same job is present in any of the dependency column.    Below is the Sample   Flow Name Job Name Dependency CE_B3_STACK 90-IDM-STK_FMTS-00001   CE_B3_STACK 91-IDM-STK_FW-00001   CE_B3_STACK 92-IDM-STK_PRTY-00001 91-IDM-STK_FW-00001 CE_B3_STACK 93-IDM-STK_PRXY-00001 91-IDM-STK_FW-00001|92-IDM-STK_PRTY-00001 CE_B3_STACK 94-IDM-STK_B3_ASSET_CLASS-00001 90-IDM-STK_FMTS-00001|92-IDM-STK_PRTY-00001|93-IDM-STK_PRXY-00001 CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00001   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00002   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00003   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00004   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00005   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00006   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00007   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00008   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00009   CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00010   CE_BSE_CUST_SGB 21-BSE-CUST_SGB-00001 20-BSE-CUST_SGB-00001|20-BSE-CUST_SGB-00002|20-BSE-CUST_SGB-00003|20-BSE-CUST_SGB-00004|20-BSE-CUST_SGB-00005|20-BSE-CUST_SGB-00006|20-BSE-CUST_SGB-00007|20-BSE-CUST_SGB-00008     Flow CE_B3_STACK is perfectly alright. However, CE_BSE_CUST_SGB has 2 issues. It has job name  21-BSE-CUST_SGB-00001 entry twice and also 21-BSE-CUST_SGB-00001 job shows it is dependent on the same job 21-BSE-CUST_SGB-00001.     So  I need to know and flag out such entries where job is dependent on same job within a flow . Something like below output is expected .. Flow Name Job Name Dependency Flag CE_B3_STACK 90-IDM-STK_FMTS-00001   ok  CE_B3_STACK 91-IDM-STK_FW-00001     CE_B3_STACK 92-IDM-STK_PRTY-00001 91-IDM-STK_FW-00001 ok  CE_B3_STACK 93-IDM-STK_PRXY-00001 91-IDM-STK_FW-00001|92-IDM-STK_PRTY-00001 ok  CE_B3_STACK 94-IDM-STK_B3_ASSET_CLASS-00001 90-IDM-STK_FMTS-00001|92-IDM-STK_PRTY-00001|93-IDM-STK_PRXY-00001 ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00001   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00002   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00003   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00004   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00005   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00006   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00007   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00008   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00009   Not ok  CE_BSE_CUST_SGB 20-BSE-CUST_SGB-00010   Not ok  CE_BSE_CUST_SGB 21-BSE-CUST_SGB-00001 20-BSE-CUST_SGB-00001|20-BSE-CUST_SGB-00002|20-BSE-CUST_SGB-00003|20-BSE-CUST_SGB-00004|20-BSE-CUST_SGB-00005|20-BSE-CUST_SGB-00006|20-BSE-CUST_SGB-00007|20-BSE-CUST_SGB-00008 Not ok      Any help is really appreciated  ... View more

Re: How to retain indexes after using set statement

by Obsidian | Level 7 in SAS Programming
‎02-28-2022 10:13 PM
‎02-28-2022 10:13 PM
Problem is , there are about 16 datasets and I dont know what index is present on which dataset ... View more

How to retain indexes after using set statement

by Obsidian | Level 7 in SAS Programming
‎02-28-2022 08:57 PM
1 Like
‎02-28-2022 08:57 PM
1 Like
I have input dataset which has one index, I need to create replica of input and need to maintain the indexes also. But when i use set command, indexes are getting lost.   Here is my input dataset have in inbound library  ACCOUNT_ID DATA_DATE TCE TOT_LMT SOURCE_SYSTEM_CODE BASEL_RETAIL_CORP_CODE RAM3000007 31-Jan-22 1000 3400 RAM CONS RAM3000015 31-Jan-22 12000 4600 RAM CONS     Below is the describe statement    proc sql; create table INBOUND.CE_RAM_PIT( compress=BINARY bufsize=131072 ) ( ACCOUNT_ID char(30) format=$30. label='Account Identifier', DATA_DATE num format=DATE9. label='Data Date', TCE num format=17.2 label='Total Committed Exposure', TOT_LMT num format=17.2 label='Total Limit', SOURCE_SYSTEM_CODE char(3) format=$3. label='Source System Code', BASEL_RETAIL_CORP_CODE char(10) format=$10. label='Basel Retail Corporate Code' ); create index ECL_MODEL_GROUP_CODE on INBOUND.CE_RAM_PIT(ACCOUNT_ID); quit;     Now , I need to create new dataset in other directory and retain indexes, when use set indexes are lost. I have tried Proc datasets , in that case indexes are retained, however, I need to do certain dataset operations using datastep like below   data outbound.CE_RAM_PIT; set inbound.CE_RAM_PIT; new_field1=TCE*70; new_field2=TCE/20; new_field3=put(new_field2,8.); new_field4=TOT_LMT/ 3400; run;   when i run above code, my indexes are lost. Any help on either retaining index or rebuilding indexes using same proc sql would help       ... View more

Re: Replace individual characters

by Obsidian | Level 7 in SAS Programming
‎02-24-2022 06:45 AM
‎02-24-2022 06:45 AM
Looks like I messed up while giving the input . Let me simplify it.   Input : War started Output: 12345623689   W>1,a->2,r->3,space->4,s->5,t->6,a->2,r->3,t->6,e->8,d->9 Kindly suggest. If any other approaches then that also suggest. My objective is just to mask the data and i should be able to unmask it later      ... View more

Replace individual characters

by Obsidian | Level 7 in SAS Programming
‎02-21-2022 12:08 PM
‎02-21-2022 12:08 PM
Hi,   I have set of rules to be applied to individual characters    data have; input str $34.; cards; my name is john ; run;     Below is translation rule   Letter translation m 12 y 45 n 89 a 22 e 87 i 90 s 24 j 88 o 64 h 32 n 8   Hence my output should look like this  124589221287902488643258     I tried using translate and tranwrd , but somehow could not get individual letters replacement correct.    Any help is really appreciated     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-14-2025 10:03 AM
Likes from
View All
Quick links