I've a DS that can have multiple values in purpose column : it can be any combination of 'build', 'buy', 'construction', 'purchase' and so on.... I only need to keep the record if the purpose column has 'buy' or 'build' values or combination of both, but not the others or even a combination of buy or build with any other values. For instance" Acceptable values are: buy, build, buy & build, build & buy Unacceptable values: construction, purchase, buy & construction, buy & purchase, build & construction, build & purchase  How do I go about coding that in sas please ?  It's easy to write where condition when there is only one value in column but for multiple values, I'm needing some help thanks!  ... View more

Below is the pass-thru sql query in SAS that I am aiming to modify to display more than two customer records in the same row (by adding additional columns as Name_Example_3, Name_example_4 and so on). The output table below is only displaying two customer records at the moment (using the min and max function). Is there any way I can add more columns if say cus_count >2. proc sql; create table test as select ID_TYP, CUST_ID, count(distinct(a.number)) as cus_count, count(distinct(a.name)) as Name_Count, count(distinct(a.DOB)) as DOB_Count, min(b.NAME) as Name_Example_1, max(b.NAME) as Name_Example_2, min(a.number) as cus1, max(a.number) as cus2, min(a.ADDED_DT) as cus1_created_date, max(a.ADDED_DT) as cus2_created_Date, count(distinct(c.acc_id)) as acc_count   from a left join b on a.SK = b.sk   left join c on a.sk_from = c.sk   where *some condition* group by CUST_ID_TYP, CUST_ID having cus_count > 1 quit;   output table below (First row is the header with corresponding values in the second row):  ID_TYP CUST_ID cus_count Name_Count DOB_Count Name_Example_1 Name_Example_2 cus1 cus2 cus1_created_date cus2_created_Date acc_count NS ABC 2 2 1 Dummy_cus1 Dummy_cus 2 #1 #2 14072022 10022021 4 ... View more

Hi, my SAS program reads an excel file from a shared directory. There is a 'date' type field in the excel file which SAS sometimes reads as Date when it finds data in the first 8 rows (I reckon) and if there is no data in the first 8 rows then it automatically assigns char datatype(DT) to it. My program was working fine for the Char DT until SAS identified it as 'Date' for one of the excel files.    Could someone please advise how I can write SAS code to  : - first identify the data type in the SAS code (has to be done through code as it will part of an automated job), and - if it's Date, run an extra step to convert it to Char and then continue with rest of the program - if it's already char then do nothing   Alternatively, you may advise how to convert it to Date (if it has been identified as char) so I can then revise the rest of the code to align it with the same data type  Any help will be greatly appreciated as I'm a new SAS learner and have a deadline to make this code work. (by 24th Oct)   Thanks a lot in advance.    This is my proc import step:    proc import out = permlib.filename_&macro. datafile = "&macro_dir.\&macro" dbms = excelcs replace; server="&PCFilesServer"; port=&PCFilesPort; run;   ... View more