Hi all, I'm facing some error in sas mainframe code could you help out for this problem below i mention the log results plz go through on it    1 ODS TAGSETS.EXCELXP FILE= "C:\USERS\IBM_ADMIN\DESKTOP\ODSFILE.XML";             _______________             _______________           180          180         180       ERROR 180-322: Statement is not valid or it is used out of proper order.      ERROR 180-322: Statement is not valid or it is used out of proper order.       ERROR 180-322: Statement is not valid or it is used out of proper order. 2 PROC TABULATE DATA=SASHELP.CLASS; 3 CLASS SEX AGE; 4 VAR HEIGHT; 5 TABLE AGE,SEX*HEIGHT*MEAN; 6 RUN; ! ODS TAGSETS.EXCELXP CLOSE; _______________ _______________ _______________ 180 180 180 180-322: Statement is not valid or it is used out of proper order. 180-322: Statement is not valid or it is used out of proper order. 180-322: Statement is not valid or it is used out of proper order. The SAS session used 0.02 CPU seconds and 6799K.   plz go through on the code kindly give some solution for that  Thanks & regards rohitkrishna    ... View more

Hi all, plz find below mention code and give me some suggestions to rectify the problem   Problem :    By using proc report I want to generate a report I able to get the observation only,  variables are not presented in the output file  kindly check with the code and try to resolve the issue    {        PROC REPORT DATA = _HED OUT= _OUT; COLUMN( H SEQNUM COUNT); DEFINE H / DISPLAY "HED"; DEFINE SEQNUM / DISPLAY "SEQNUM"; DEFINE COUNT / DISPLAY "COUNT"; BREAK AFTER H / SKIP; TITLE ' CURRENT DATE SEQNUM AND COUNT OF REC'; RUN; PROC PRINT DATA = _OUT; RUN;                                                                                                                                     }     And the results in spool  CURRENT DATE SEQNUM AND COUNT OF REC Obs H SEQNUM COUNT _BREAK_ 1 H 696 19121 2 T 0 96   and the output file it shows only observations variables are not there (H SEQNUM COUNT ) those three are not at present in the output file    ****** *************** 000001 H 696 19121 000002 T 0 96   kindly give the answer to that problem and one more I want to show in footnote next seqnum 697 how can I do by using sas code could u explain that one also    Thanks & regards  rohit Krishna ... View more

Hi all, i have dought on auto-update scenario  below I given an example plz look on it & plz suggest the solution  in sas mainframe    {     I get 2 sequnce_number  those are 421 & 422 while running the code it only picks one so by mistakenly it picks the second one so obesely  it gets an abend  while running next time  it mostly picks the second one so I want in sas coding to that scenario kindly plz suggest some solution  for this problem  }   thanks & regards  rohitkrishna   ... View more

hi all, I got stuck at one point of my sas code it all about  to retrieve only first and last record of my dataset  I tried in multiple ways in sas and SQL I succeed in SQL by using max and min statements in the code but till  now I didn't get in sas so kindly guide the current code for fetch only 2 records that are first and last record    in sas i tried if _n_ = 1; but i got only first rec i want the last one too       Thnaks & regards  rohitkrishna ... View more

Hi all, I'm facing some problems while running the sas mainframe code, { i want to bypass the null value in exsisting sas output }   that was the major task for me get out off it kindly help me to find the solution, below i mention the code kindly go through on it   quote(trim (left(translate(state_cmts,' ','00'x) ))) || delimtr || { that was the one input sas code to be in a qoute and with pipe delimter  and the output value is ++++++++{|" Next: Short End Dated."|}+++++++++ in browsing mode it shows like this ++++++++++++{|".Next: Short End Dated."|}  what i'm asking is how do i remove the dot befor the NEXT string kindly explay it    Thanks & Regards  N muralikrishna     ... View more

Hi All, I have query on sas mainframe, i want to convert numeric value to character value  so kindly help out for the solution so please find below  the sas code and give sum suggestions { and basically my requirement are, ls_address_id variable have binary values like  "õUA000000001250545 "    , and while reading the input i want it to be in readable format so i gave pib4 . format for that and i got the exact results and it's readable"4042322160" , now "i want to print the results in output file in a non readable format like in input " "õUA000000001250545 "  (like that) but while trying to assign $char12.  i'm getting error { ls_address_id has already defined has numeric } so kindly give the solution for that { {1 DATA RAM_; WARNING: The Base Product product with which DATASTEP is associated will expire installation representative to have it renewed. 2 INFILE karli2a DSD; 3 INPUT 4 @1 TEXT $CHAR60. 5 @61 LS_ADDRESS_ID PIB4. 6 ; 7 LS_ADDRESS_ID = PUT(ADDRESS_ID,12.); 8 RUN; Character values have been converted to numeric values at the places give 7:18 9 DATA VIG_; 10 SET RAM_; 11 FILE SYSOUT; 12 PUT 13 @1 TEXT $CHAR60. 14 @61 LS_ADDRESS_ID $CHAR12. + ________ + ________ + ________ 48 + 48 + 48 ERROR 48-59: The format CHAR was not found or could not be loaded. +ERROR 48-59: The format CHAR was not found or could not be loaded. +ERROR 48-59: The format CHAR was not found or could not be loaded. 15 ; WARNING: Variable LS_ADDRESS_ID has already been defined as numeric. } thanks & regards N muralikrishna   ... View more