About tinton

tinton · ‎05-17-2023

Thanks for the reply! I've figure it out by using proc sort with nodupkey DATA NO_DUP_TABLE; SET DUP_DATA; KEY = CATT(ID); RUN; PROC SORT DATA= NO_DUP_TABLE NODUPKEY DUPOUT=TAB_DUP; BY KEY; RUN;

tinton · ‎05-17-2023

PROC SQL; CREATE TABLE T1 AS SELECT * FROM BOOK WHERE PORTFOLIO=''; // the output will show around 1,142,678 data PROC SQL; CREATE TABLE T2 AS SELECT DISTINCT ID FROM T1; // the output will show only 68 id- 68 rows. If I use above code, i will only get the distinct ID in T2. How can I get all the info in T1 by select distinct id? Meaning that i want T2 to show 68 id along with all column.

tinton · ‎04-17-2023

It's working for me! Thanks for this code

tinton · ‎02-09-2023

It's okay, I've figure it out. Just use Select * from actual where mfcust14 like '%HFI';

tinton · ‎02-09-2023

PROC SQL; CREATE TABLE V1 AS SELECT * FROM ACTUAL WHERE SUBSTR(MFCUST14,-3,3) IN ('HCI','CIW','HFI','FIW); Why there's empty output eventhough MFCUST14=M9005FIW is in the table?

Online Status	Offline
Date Last Visited	‎05-25-2023 02:59 AM

Re: Combined select * statement along with select distinct statement?

Combined select * statement along with select distinct statement?

Re: Removing the .bak with proc export

Re: Select all with condition

Select all with condition

Re: Combined select * statement along with select distinct statement?

Re: Removing the .bak with proc export

Re: Select all with condition

Re: Combined select * statement along with select distinct statement?

Combined select * statement along with select distinct statement?

Re: Removing the .bak with proc export

Re: Select all with condition

Select all with condition