, HI, I will like to create a query using PROC SQL or a DATA Step and have SAS gave me an output dataset with only 10 records. For example, I have a dataset named 'have' with 1 million records and I am running an certain functions ans if/then statements.  I am limiting my output if certain conditions are met. Can I limit processing based on the number of records present in the output dataset?  When output dataset "want" has 10 observations then stop processing and output. Thank you for your help; ... View more

Hi, I have tables with character columns for SSNs. I will like to build a format to have those numbers look like actual SSNs with the dashes, but still be a chracter column, not numeric. SSNs_as_I_have_them SSNs_as_I_want_them 001234567 001-23-4567 123456789 123-45-6789 999999999 999-99-9999 I have never build a format before.  Any help? Thanks! ... View more

Function, I am trying to use the PUT function to chance numeric to character and also right align the results.  I dont know why is not right aligining.  Can anyone help? this is my code: DATA WANT; PHONE= 9999999999; PHONE_C= PUT(PHONE, 10. -R); SSN= 999999999; SSN_C= PUT(SSN, SSN11. -R); RUN; This is the results I get: What do I need to do to have PHONE_C and SSN_C right align? Thanks! ... View more

Hi, I have one variable I want to compare to 21 others.  I only want IF the variable CONTROL NOT EQUALS variables CONTROL1 to CONTROL21.  Anyone has a better, simpler way of doing it than this? IF CONTROL NE CONTROL1 AND CONTROL NE CONTROL2 AND CONTROL NE CONTROL3 AND CONTROL NE CONTROL 4.................. AND  CONTROL  NE CONTROL 21; Thank you for the help; Ismael ... View more

Hi, I am trying to use PROC TRANSPOSE to transpose from wide to narrow and entire dataset. This is what I have. ID SALARY NAME HIRE_DATE BONUS DEPT 001001 100,000 JONES SMITH 01012010 10,000 ADMIN 001002 58,362 HARRY WIZARD 02052005 5,600 SALES 001003 85,254 JOHN ADAMS 10102009 3,055 SALES This is the expected outcome I need. ID 001001 001002 001003 SALARY 100,000 58,362 85,254 NAME JONES SMITH HARRY WIZARD JOHN ADAMS HIRE_DATE 01012010 02052005 10102009 BONUS 10,000 5,600 3,055 DEP ADMIN SALES SALES I am trying to use PROC TRANSPOSE, but I havent been able to obtain the expected result.  Any help? ... View more

HI, I am trying to find a way to find character fields that contains some special keywords.  I tried using something like this: IF TINT='2' and NAME CONTAINS (' TRUST ', ' TR '); TINT NAME 1 JOSEPH BROWN TRUST 2 THE TRUSTWORTHDY TRUST CORP 2 JOHN ADAMS TR I would like to find a way to identify , in this example, the last two observations because they meet the conditions I listed on the IF statement.  I do have millions of records, so this is just an example. Any ideas how to make this easy? Thanks... ... View more

HI, I have a variable for names and some of those names have some keywords I would like to take out.  I was trying using TRANWRD and it works, but I have to do so many TRANWRDS statements to eliminate all the possible keywords I have in my list.   I was trying to do a loop, but I am having problems.  Can anyone help? Example Data: ID ORIGINAL_NAME 1 Jose L Smith JR 2 Angel P Jones SR 3 Susan DECD White III Trust 4 Henry West IV 5 John Adams 6 Jose DECD Hernandez Words I want to eliminate: 'JR', 'SR', 'III', 'IV', 'DECD'. This is the last code I tried: DATA WORK.NEWTABLE (KEEP=ID ORIGINAL_NAME NEW_NAME); SET LIBRARY.NAMES_ID; NEW_NAME=ORIGINAL_NAME; ARRAY KEYWORDS{*} $ _TEMPORARY_ ('JR', 'SR', 'III', 'IV', 'DECD'); DO i=1 TO 5;      NEW_NAME{i+1}=TRANWRD(NEW_NAME{ i }, KEYWORDS{ i }, '');      END; RUN; Desired Results ID ORIGINAL_NAME NEW_NAME 1 Jose L Smith JR Jose L Smitn 2 Angel P Jones SR Angel P Jones 3 Susan DECD White III Trust Susan White Trust 4 Henry West IV Henry West 5 John Adams John Adams 6 Jose DECD Hernandez Jose Hernandez ... View more