I have a task that I need to accomplish. I have FirstName that I need to either switch around or assign random names to it. FirstName John Joseph Charles Charles John John Mary John FirstName (randomized) (Note: These are just random names) Bill Water Salt Salt Bill Bill Mark Bill The goal is to assign consistent random names or switch the characters around using a logic. This logic must however generate consistent translation. For instance, in the above dataset, all occurrences of John and Charles must be translated to Bill (or any name generated by your code) and Salt (or any name generated by your code) respectively as with the random test data Thanks and I look forward to hearing from you all. ... View more

Need help appending SAS data set into an oracle table. I'm having issues with regards to the date as the SAS data  dates gets converted to either December 31, 1959 or Jan 1, 1960 in the oracle table. For instance, I have a date 01/23/1999 in SAS but it gets converted to 01-Jan-1960 in oracle using the append process below proc append base= ORCL.base data=SAS.data; run; oracle base table has Process_date and SAS date has the same field. Note: When I did a direct load of SAS.data into a new table in Oracle using SAS/access to oracle, I noticed (connecting to oracle using SAS and using proc content) that the length format of the Process date changed to 8 from 4 (process date length =4) but results where fine except that the process_date was in a date timestamp format Any help/suggestion is welcomed Thanks ... View more

I need help with assigning a new id (proposed id).I'm trying to get the final data below based on the fact that If Admn_no  have same sch_ID and name, or sch_ID and Birth_Day or name and Birth_day, assign the same the same proposed ID throughout. The assumption is they are the same people. If that criterion is not met, then give it a new proposed id since the person is likely a new person. SAMPLE data Adm_no   Sch_ID   NAME        Birth_Day 1               6116    CALVIN        03/10/1970 2               6176    CALVIN        03/10/1970 3              6176     CALVIN       10/03/1970 4              0176     CALVIN        03/10/1970 5              6176                          10/03/1970 6              6176      MALVIN      03/10/1970 7              6176                          03/10/1970 8                         CALVIN          03/10/1970 9             6116                           03/10/1970 10          12345   JOHN             01/02/1978 11          6543      TOM              03/06/1977 12          2348     CALVIN Final Adm_no   Sch_ID   NAME        Birth_Day      Proposed_id 1               6116    CALVIN        03/10/1970    1 2               6176    CALVIN        03/10/1970    1 3              6176     CALVIN       10/03/1970     1 4              0176     CALVIN        03/10/1970    1 5              6176                          10/03/1970    1 6              6176      MALVIN      03/10/1970     1 7              6176                          03/10/1970    1 8                         CALVIN          03/10/1970    1 9             6116                           03/10/1970    1 10          12345   JOHN             01/02/1978    2 11          6543      TOM              03/06/1977   3 12          2348     CALVIN                               4 ... View more