If you want to format a character variable to return another character value you can use the PUTC function. PROC FORMAT; VALUE $MSDRG "001"-"017"="1" OTHER="0"; RUN; DATA FINAL_WITH_MSDRG; FORMAT CODE; CODE = "001"; OUTPUT; CODE = "140"; OUTPUT; RUN; DATA ELECTIVE_SURGICAL; SET FINAL_WITH_MSDRG; ATTRIB STUFF FORMAT=$1.; STUFF=PUTC(CODE, "$MSDRG.")="1"; RUN; ... View more

Apart from a redundant comma in your proc format your code works fine for me. If you want to see the leading zeros in your initial numeric values, simply use the z3. format as below. PROC FORMAT; VALUE MSDRG 001-017, 020-042, 113-117, 129-139="1" OTHER="0"; RUN; DATA FINAL_WITH_MSDRG; FORMAT CODE Z3.; CODE = 001; OUTPUT; CODE = 140; OUTPUT; RUN; DATA ELECTIVE_SURGICAL; SET FINAL_WITH_MSDRG; WHERE PUT(CODE, MSDRG.)="1"; RUN; ... View more

If '..' is not an acceptable value in any of the previous observations you could.use the following: DATA A; INPUT NAME $ @; IF NAME = '..' THEN STOP; DATALINES; AA BB CC TRAILER .. ; RUN; The trailing @ holds the input record so that you can process the item conditionally.  In this case we are telling SAS to stop processing once a '..' is read. Alternately you could use: DATA A; INPUT NAME $ @; IF NAME = '..' THEN DELETE; DATALINES; AA BB CC TRAILER .. RUN; This will delete any occurrence of '..'. I hope this helps. Regards, Scott ... View more

Sorry I must have got confused about what you were looking for.  I thought you wanted only ID's with one OBS. How about this DOW loop example?  Just customize the output statement to alter the number of obs you want to keep or remove, which will be contained in the count variable. DATA WANT;   DO UNTIL (LAST.ID);   SET HAVE;   BY ID;   IF FIRST.ID THEN COUNT = 1;   ELSE COUNT + 1;   END;   DO UNTIL (LAST.ID);   SET HAVE;   BY ID;   IF COUNT ~= 2 THEN OUTPUT;   END; RUN; ... View more

Use by group processing with if first.id and last.id then delete. proc sort data=have; by id; run; data want; set have; by id; if first.id and last.id then delete; run; ... View more

Are you running SAS on your local machine or on a server? If you are running on a server then your code is attempting to access the CSV on the servers default location.  Copy the file to a network drive that SAS has access to, alter your code to reflect this and run it again. Hopefully that will do the trick. ... View more

Have you checked tnsnames.ora to ensure that the connection has been set up? ... View more

Even though the following is more keystroke intensive than you would like, it is quite resource efficient as it uses the Datasets Procedure.  Proc Datasets can make modifications to variable attributes, without reading in the entire dataset. DATA TEST; INPUT ID NAME $ GENDER $ PUBLIC SALARY; DATALINES; 1 A M 1 10000 2 B F 0 20000 3 C M 1 10000 4 D F 0 20000 5 E M 1 10000 6 F F 0 20000 RUN; %MACRO RENAME(LIB,DSN); %LET A = %NRSTR(%MEND;); PROC CONTENTS DATA=&LIB..&DSN; TITLE 'BEFORE RENAMING'; RUN; PROC SQL NOPRINT; SELECT NVAR INTO :NUM_VARS FROM DICTIONARY.TABLES WHERE LIBNAME="&LIB" AND MEMNAME="&DSN"; SELECT DISTINCT(NAME) INTO :VAR1-:VAR%TRIM(%LEFT(&NUM_VARS)) FROM DICTIONARY.COLUMNS WHERE LIBNAME="&LIB" AND MEMNAME="&DSN"; QUIT; PROC DATASETS LIBRARY = &LIB; MODIFY &DSN; RENAME %DO I = 1 %TO &NUM_VARS.; &&VAR&I = VAR&I. %END; QUIT; PROC CONTENTS DATA=&LIB..&DSN.; TITLE 'AFTER RENAMING'; RUN; %MEND RENAME; %RENAME(WORK,TEST); I hoe that you find this useful. Regards, Scott ... View more

Here is a post from 2006 that Cynthia wrote on the matter. ... View more

Can you provide the code you are using at present, so I can recreate exactly what you are attempting to do?  Some simulated data would be great too. Regards, Scott ... View more