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: 
Arin
‎02-13-2018
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Access for IMS DB: Unable to Print Records

by Fluorite | Level 6 in SAS Data Management
‎02-02-2018 10:37 AM
‎02-02-2018 10:37 AM
Thanks much @JBailey! I finally have reached out to the SAS Tech Support.   However before that, following I tried without success: 1. DFSRRC00 IMS program was found missing, perhaps because DFSRESLB is not a supporting DD for SAS PROC. So, tried to pass RESLIB as LOAD, and it failed as a different IMS system module DFSVCI00 wasn't accessible; it seemed to be in a NON-APF Library.    2. Above mentioned error is usually received in IMS Jobs when RESLIB is not passed. So, DFSRESLB was added again, beside using the LOAD too. This time it failed with error: "UNABLE TO INITIALIZE DL/I BUFFERING SERVICES" Reason Code 04.   I understand that these are more IMS issues than that of SAS, but how these IMS PARMs and LIBs to be passed to SAS properly is still unknown to me. ... View more

SAS Access for IMS DB: Unable to Print Records

by Fluorite | Level 6 in SAS Data Management
‎01-24-2018 10:51 AM
‎01-24-2018 10:51 AM
I'm trying connect to IMS to read a HDAM DB (DB1) segment (SEG1) and print first 5 records of it, but getting following error while executing PROC PRINT: IMS has terminated. Return code = 9991   Here is my code: //SASIMS   EXEC SAS                                                   //SAS.WORK DD UNIT=(SYSDA),SPACE=(CYL,(100,99),RLSE),                 //            DCB=(RECFM=FS,LRECL=6144,BLKSIZE=6144,DSORG=PS)         //MYLIB    DD DSN=TEST.DUMMY.DSN,                                     //            DISP=(NEW,CATLG,DELETE),                                //            SPACE=(CYL,(50,50),RLSE),UNIT=SYSDA,                    //            LABEL=EXPDT=2019/365,                                   //         DCB=(MODELDCB,RECFM=FS,LRECL=27648,BLKSIZE=27648,BUFNO=20) //*                                                                   //IMS      DD  DSN=TEST.PSBLIB,DISP=SHR                               //         DD  DSN=TEST.DBDLIB,DISP=SHR                               //DFSRESLB DD  DSN=TEST.RESLIB,DISP=SHR                               //*                                                                   //SYSIN    DD *                                                      OPTIONS NODATE LINESIZE=120;                         PROC ACCESS DBMS=IMS;                                 CREATE MYLIB.DB1.ACCESS;                              DATABASE=DB1 DBTYPE=HDAM;                             RECORD='TEST REC' SEGMENT=SEG1 SEGLNG=756;            ITEM='FLD1' LEVEL=2 DBFORMAT=$16.  SEARCH=FLD1 KEY=Y; ITEM='FLD2' LEVEL=2 DBFORMAT=$135. SEARCH=FLD2;       AN=Y;                                                 LIST ALL;                                                                                                   CREATE MYLIB.SEG1.VIEW PSBNAME=PSB1 PCBINDEX=3;       SELECT 'TEST REC';                                    LIST VIEW;                                            RUN;                                                 PROC DATASETS LIB=MYLIB;                              CONTENTS DATA =_ALL_; QUIT;                           RUN;                                                 PROC PRINT DATA=MYLIB.VSLPTAP(OBS=5);                 RUN;                                                   I'm unable to get to the root cause. Can someone please advise?    Ref used to develop this code: http://support.sas.com/documentation/cdl/en/acims/59519/PDF/default/acims.pdf ... View more

Re: Using a Macro Variable inside a Datastep

by Fluorite | Level 6 in SAS Programming
‎10-07-2016 05:23 PM
‎10-07-2016 05:23 PM
@Shmuel Thanks much! ... View more

Using a Macro Variable inside a Datastep

by Fluorite | Level 6 in SAS Programming
‎10-07-2016 04:42 PM
‎10-07-2016 04:42 PM
Requirement here is to have a global variable (var1) with a default value (1) that may be manipulated (conditional new value = Y) under 1st datastep (data1) and then to use it under 2nd datastep (_null_) to perform some other action conditionally.   Problem is, under the _null_dataset though var1 is carrying correct value (Y) from data1, it's not satisfying the IF-condition, rather going to ELSE-part.   Here is the code:   %global var1;          %let var1 = 1;                                data data1;            var2 = 3;              if var2 = 3 then do;   %let var1 = Y;         end;                   run;                                          proc print data=data1; run;                                          %put &var1;                                   data _null_;           varz= symget('var1'); file OUTF;             put @1 'start';        if varz = Y then do;      put @1 'yes';      end;                   else do;                  put @1 'no';        end;                   run;                    My expectation is that it should print "yes" from IF-part, not the "no" from ELSE-part. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-13-2018 04:33 PM
Likes given to
View All
Quick links