Hi All, I am getting one error that was meeting with the condition what I passed in the below code  Req: is I have a file it contains header, detail and trailer records and it's in CSV format and I need to make it fixed format and check the record type if it in proper order then the results have been print to outfile, if the record type is not matching with the condition then it has to show the error code please find below the input records    input Recods in csv format :   H2019101813450000002 D,case#,brinsten,62005,cafitira,netherlands, T2019101813450000002 (instead of T place I used given E then it must show the error code in spool) above the input values i converted it into fixed format by using format and input and put function  {"moreover i need to split those headers and trailer rec into one file and details rec has to move another file} kindly give sum suggestion to rectify the error i getting    {Chktlr: INFILE LSFIACEI End=EOFPCEI Missover; Input @1 Tlrrtype $char1. @2 Tlrdate $char8. /* Header date */ @10 Tlrtime $char4. /* Header time */ @14 Tlrqty 8.; /* Records in file */ /* Validate record type */ If Tlrrtype¬= 'T' Then Do; Errcode = 11; Link SasAbend; End;}   and below the  error code    When (11) Do; Put '* Expected Records Mismatches Actual read ?.'; Put '* Expecting (T)railer record as last entry '; Put '* in input file. Found record type = ' Tlrrtyp; Put '* '; Put '* The number of data records read was '; Put '* based on the number of expected '; Put '* records read from the header.'; Put '* The header value was : ' Hdrqty; End;   but i am not able getting the exact error code    kindly give the solution for the above code  Thanks & regards  rohit ... View more

Hi All, I have data issue while making reshape of the below data, kindly someone help me out for this scenario   {     data _nu;    infile datalines;    input num1    datalines;    1 2 3 4 5 ;   run; my expecting results should be    num1  1  2  3  4  5 I want to reshape horizontal to vertical    Thanks & regards Rohit        ... View more

Hi All, I'm facing one issue in current sas mainframe code while running the using option obs = 10 it extracting from 2 to 10 rec only means 9 rec only getting into the output in the log it shows "Invalid Parameter Name or Value" but remaining 9 rec are extracted only first rec itself showing that error, please find below the code and suggest sum solution for the problem    {  options missing = ' '; %Include MACRO(L*MDBSS); %Include MACRO(L*MBDTE); %L*MDBSS; %L*MBDTE; Proc Access Dbms=DB2; Create adlib.SASV8*11.Access; Ssid = &Xdbssid; TABLE &XDBSSOWN..*L*8*11_ORG_N**E; Assign=Yes; List All; /* Create View Defining the data from DB2 table */ Create vlib.SASV8*11.View; Select ORG_ID ORG_N**E DE*T_N**E; Run; %Macro L*MV8*11(Viewid); options obs = 10; DATA _null_; FORMAT Num8 8. Char8 $Char8.; FORMAT recout $varying4000. len 5.; RETAIN table '*L*8*11_ORG_N**E'; RETAIN Reccount 0; RETAIN delimtr ','; Reccount + 1; SET Vlib.Sas&Viewid. END=EOF; FILE LSFV8571; If _N_ = 1 Then LINK Header; ORG_N**E = "'" || trim(ORG_N**E) || "'"; DEPT_N*m = "'" || trim(DEPT_N**E) || "'"; Org_N**e = TRANSLATE(Org_N**e,' ','00'x); dept_n**e = TRANSLATE(dept_n**e,' ','00'x); recout= 'D' || Delimtr || trim(left(Org_Id )) || Delimtr || trim(left(Org_N**e )) || Delimtr || trim(left(DEPT_N*M )) || Delimtr; len = length(trim(recout)); PUT recout $varying4000. len; If EOF Then LINK Trailer; Return; /* Create Header. Format :- H LAMM 1997 355 .CXA 01.00 */ Header: Hdte = "&Bdtejull"; Hdr_rec = 'HLAMM' || COMPRESS(HDTE) || '.CXA' || COMPRESS(SCAN(Sysparm(),3,'.')); Hdr_rec = TRANSLATE(Hdr_rec,'.','/'); PUT @1 Hdr_rec; File LSFHDATA; Return; Trailer: * File LSFTDATA; PUT @1 'T' @2 Reccount Z10.; Return; /* Invoke the Macro to transform data */ %Mend; Run; %L*MV8*11(V8*11);   } ERROR: ZIP191E Invalid Parameter Name or Value: ZIP191E --> 504 ZIP191E Invalid Parameter Name or Value: ZIP191E --> 'A    the first record has missing in the output it shows above error so kindly help to resolve the problem Thanks & regards  rohit ... View more