I'm attempting to  transform my if logic into something more concise. The sample I provide is much smaller than the real data:   data have; infile datalines; input list $ 1-3 id $ 5-7 price $ 9-10; datalines; BAC BB8 4a BAC 22C BAC DDD 5b CBA 6c CBA 22A 4b CBA 10B 4b CBA 11A 5f DAC 2CC DAC 11C 2e DAC 3e ; run; data want; set have; if list='BAC' and id='BB8' and price='4a' then code='BBB'; if list='BAC' and id='22C' and price=' ' then code='CCC'; if list='BAC' and id='DDD' and price='5b' then code='DDD'; if list='CBA' and id=' ' and price='6c' then code='FFF'; if list='CBA' and id='22A' and price='4b' then code='FFF'; if list='CBA' and id='10B' and price='4b' then code='GGG'; if list='CBA' and id='11A' and price='5f' then code='HHH'; if list='DAC' and id='2CC' and price=' ' then code='III'; if list='DAC' and id='11C' and price='2e' then code='BBB'; if list='DAC' and id=' ' and price='3e' then code='BBB'; run; So I use those if statements to create a new field. But I don't want to have tons of if statements for every variation - I'd rather automate it somehow. Is this possible? ... View more

    First I am putting a list of IDs in a macro variable from a dataset, then I'm using that macro variable in a where dataset option for an different incoming dataset:   proc sql noprint; select ID into :ID_List_2010 separated by ' ' from New_ID where date < '01jan2011'd; quit; data want; set have(where=(ID in(&ID_List_2010))); run; But I get this error:  WHERE clause operator requires compatible variables.   -ID in have is char of 15 length. -ID in New_ID is a char of 7 length. -Some IDs start with a 0.   How do I get around this error? Thanks. ... View more

I've imported an excel sheet into SAS EG using the import wizard and the date values are character values that look like 2013/03/01. I need to convert these to SAS Date values, but when I try to use input the values just come out as missing values. How can I properly convert these character dates to SAS date values? Thanks. ... View more

I have a two datasets that I'm trying to join that have three variables that either have conflicting formats or values or both:   Dataset One  FILL_DT: DATETIME18. (values look like 11JAN17:03:00:00) RX_NBR: 12. (values look like 1038484) NCPDP_ID: 15. (values look like 4542646)   Dataset Two FILL_DT: MMDDYY10. (values look like 01/10/2017) RX_NBR: $12. (values look like 000008829507) - notice this has leading zeros where as in the other dataset it doesnt, I want to get rid of these leading zeros. They don't all have the same number of leading zeros either. NCPDP_ID: $15. (values look like 1482152)   So what I'd like is: FILL_DT needs to be MMDDYY10. format in both datasets RX_NBR needs to be 12. format in both datasets AND I need to get rid of leading zeros (from values from dataset 2) NCPDP needs to be 15. in both datasets   I've tried using input and put but keep running into different errors like when I tried to convert from DATETIME to MMDDYY10. I get the message "Date value out of range". When I try to use input to convert from $15. to 15. the format becomes blank when I do a proc contents and when I try and join it tells me its of a different type.   ... View more

Here is some sample data:   data have; infile datalines; input list $ id price; datalines; DAC 22 2 DAC 11 3 DAC 33 1 BAC 11 4 BAC 33 2 BAC 22 5 CBA 33 5 CBA 22 4 CBA 11 7 ; run; An ID will pay off one of the lists, for example 22 will be paid off of DAC at a price of 2. What I want to figure out is what the ID would have been priced at if it paid off of a different list. So if it paid off of CBA, the price would be 4, but I need a way to automate this with a program to figure out for all ids and lists. ... View more