Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: qchac
  • Order by date
  1. qchac

    ERROR: Variable COD_PRD has been defined as both character and numeric

    I've set COD_PRG as char in the attrib instruction and I eliminated the length in the sql. Thanks Chris. The problem now is with the message (I knew this will appear when trying to rewrite the same dataset while trying to read it at the same time, but I don't have this situation here)...
  2. qchac

    ERROR: Variable COD_PRD has been defined as both character and numeric

    you are right, there is COD_PRD defined as char in fidx121t. I had removed the length and now it looks like this: .... create view evt111 as select num_prog length=8, num_adh, num_scp length=6, num_evt length=6, typ_evtv length=4, val_evt length=4, val_pue length=4, date_cre, date_evt...
  3. qchac

    ERROR: Variable COD_PRD has been defined as both character and numeric

    sry chris. I'd to put it fast and I've forgotten the elementary rules. 33 The SAS System 17:41 Thursday, July 6, 2006 length=6 COD_OEVT length=4 COD_PRD length=5; MPRINT(ACHATS): merge r99d1.fidx004t(in=x) r99d1.evt111(in=y); ERROR: Variable COD_PRD has...
  4. qchac

    ERROR: Variable COD_PRD has been defined as both character and numeric

    hello. I have the following error when I've tried to run the program. ERROR: Variable COD_PRD has been defined as both character and numeric. Can anybody help me ? Thanks. program: ............................................................ rsubmit &r_unix ; /*extraction des...
  5. qchac

    ERROR: There is no data set to modify.

    I have the following error: NOTE: Moving DONNEES.FIWM014C to WRKCHGT.FIWM014C (memtype=DATA). NOTE: There were 0 observations read from the data set DONNEES.FIWM014C. NOTE: The data set WRKCHGT.FIWM014C has 0 observations and 25 variables. NOTE: PROCEDURE DATASETS used: real time...
  6. qchac

    length problem

    Klaz, First thx for your help. I've added the following instructions in merge: rename SIG_CREA = SIG_CREA_TMP SIG_MOD = SIG_MOD_TMP; length SIG_CREA_TMP $3 SIG_MOD_TMP $3; SIG_CREA = SIG_CREA_TMP; SIG_MOD = SIG_MOD_TMP; drop SIG_CREA_TMP SIG_MOD_TMP...
  7. qchac

    length problem

    hi. I have to change the length of the variables SIG_CREA and SIG_MOD from 6 to 3 characters. The problem is that the length is still 6 and I don't know why. thx. the program: options mprint symbolgen mlogic; /* mise à jour table de pilotage */ %FIWXDATE(type=C, traitmt=FIWM60, statut=DB...
  8. qchac

    WARNING: Apparent symbolic reference ... not resolved.

    Thx guys. I've try the second method with %syslput and it worked.
  9. qchac

    WARNING: Apparent symbolic reference ... not resolved.

    Hello. My log file looks like this : NOTE: Remote submit to R55 commencing. 15 /* Mise au format DB2 de la date finsel_j => finsel_j_db2 */ 16 data _null_; 17 call symput ('FINSEL_J_DB2',"'"||put(&FINSEL_J,yymmdd10.)||"'")...
  10. qchac

    Eliminate duplicates

    Thx a lot Chris !
  11. qchac

    Eliminate duplicates

    Hello. I have this table : http://img.photobucket.com/albums/v622/qchac/table.jpg and I want to eliminate all the duplicate values and to preserve only the record with the most recent date_def or the weekest cli for each duplicate group. -> For example, in this table, from the first...

Part and Inventory Search

Back
Top