I have the following data set and I want to get the desire data set data one; input num name$ one$ two$ three$ four$ five $ ; cards; 1 day1 NICE seeinn three four five 2 day1 one two three four3 five 3 day1 nice 1SEEInn2 GFL dlov dfdf 4 day23 one two thd ruhld hfdlhf 5 dfjdh Nice lseeinn fkdjf djfkd kjklj 6 dhhk one two dkfd alkdf aldkf 7 day1 ONE seeinn thde khf fllj ; run; below.  I want to get these record in my output :   2 day1 one two three four3 five 4 day23 one two thd ruhld hfdlhf 6 dhhk one two dkfd alkdf aldkf   I tried following code, but wasn't successful getting the records I want.  proc sql; create table want as select * from one where name not in ( select name from one where ((upcase(name)='DAY1' AND UPCASE(ONE)='NICE') OR (upcase(name)='DAY1' AND UPCASE(TWO) LIKE '%SEEINN%'))); QUIT; THANKS IN ADVANCE ... View more

Hi all,           I am trying to get multiple transactions happened with customer accounts with travel agent to a single travel account. But, I don't want to see the same customer having the same travel account transactions (single or multiple transactions). The data looks like this   data have; input date mmddyy10. cust_account_id$ travel_agent$ trasfer_amount travel_account_id$; format date mmddyy10.; cards; 1/15/2018 wxyz dave 1000 abcd 2/14/2017 wxyz dave 2000 abcd 8/17/1998 mnop jason 8521 defg 05/24/1999 klmn greg 8754 opqr 11/30/2000 ryan greg 12548 opqr 06/25/2011 mall greg 1487 opqr 12/25/2013 john molly 2594 matt 10/28/2019 jim molly 5000 matt 12/23/2019 jim molly 10000 matt ; run;   I want the output dataset to look like  05/24/1999 klmn greg 8754 opqr 11/30/2000 ryan greg 12548 opqr 06/25/2011 mall greg 1487 opqr 12/25/2013 john molly 2594 matt 10/28/2019 jim molly 5000 matt 12/23/2019 jim molly 10000 matt   I used following steps: proc sort data=have ; by travel_account_id travel_agent; run; data want1; set have; by travel_account_id ; if first.travel_account_id and last.travel_account_id then delete; else output want1; run; proc sort data=want1; by cust_account_id; run; data want2; set want1; by cust_account_id; if first.cust_account_id and last.cust_account_id then output; else delete; run; I am unable to get the output i want. Could you please share your thoughts on this please??   ... View more

Community,             I am just trying to figure out how to write a string to .csv file. Here is my attempt. data one; input (acct_id gender)($) charge $20.; datalines; 101 M 20000,10000,20000 102 F 20000,21000,11000 103 F 50000,18000,49000 ; run; data _null; set one; file 'C:\statements\expenses.csv'; if _n_=1 then do; put "Acct_id,Gender,Expenses"; end; put Acct_id ',' gender ',' charge ; run; The output in csv file I want it to look like exactly how the input data looked like. The commas are breaking in each cell (for example the first row with charge should look like 20000,10000,20000 in a single excel cell instead of showing up as 20000 10000 20000 in 3 different cells). I can't think of a way to do it. Any suggestions please  Thanks,       ... View more

Dear community,                I am trying to import this short data and I am unsuccessful with this code. Can anyone help me to import the data either proc import or any other way?  proc import datafile="C:\newfolder\class.csv" out=check dbms=csv replace; getnames=yes; namerow=4; datarow=5; run;   Thanks ... View more