About muratatik

muratatik · ‎10-20-2018

Hi, You use weekday function and it's returns integer that represents day like 1=Sunday 2=Monday etc. Then you format with this day varible with weekdate9. Thats meaning you getting which day of 4 June 1960 when day=3 I suggest you directly convert lastappt variable, Day=put(lastappt,weekdate9.)

muratatik · ‎10-17-2018

I just want to do filter huge table with only getting my ID's. Firstly, i tried macro variable but it's exceed macro variables capacities. So i discovered the call execute method thanks to sas communities. Add your system option's code and then log likes below, ORACLE_4: Prepared: on connection 3 SELECT * FROM ORACLE_TABLE but different first name*.(Names with generic username for oracle connection) ORACLE_5: Prepared: on connection 3 SELECT VAR1,VAR2 ... VAR15 FROM ORACLE_TABLE WHERE ( ("ID IN ( ID1 , ID2 ,ID3 ) ) ) because i tried only three ID. ORACLE_6: Executed: on connection 3 SELECT statement ORACLE_5

muratatik · ‎10-17-2018

Sorry for late response, There is a generic user that created by SAS system admin and this is a oracle library when i connect SAS Server. I use SAS EG 7.1 I can use proc sql with basic queries with these oracle tables. I try to figure out password information with SASTRACE system option but it didn't work. So simply, when i use these oracle tables, sas know this password but i don't 🙂

muratatik · ‎10-17-2018

Hi, I've unique ID table include 90k rows. I want to filter ID's in oracle table. This table is quite huge approximately 100 Mio. I don't know exact observations because i guess proc contents can not show oracle table observation or index column. By the way, i can't use libname oracle because i dont know password or username so i cant use pass through sql. I tried below code but its running so slow. What should I do that make it faster? DATA _NULL_; SET UNIQUE_ID_TABLE END=EOF; IF _N_=1 THEN DO; CALL EXECUTE("PROC SQL _METHOD;"); CALL EXECUTE("CREATE TABLE WANT AS"); CALL EXECUTE("SELECT * FROM ORACLE_TABLE"); CALL EXECUTE("WHERE ID IN "); CALL EXECUTE("("); END; CALL EXECUTE(QUOTE(STRIP(ID))); IF EOF THEN DO; CALL EXECUTE(");"); CALL EXECUTE("QUIT;"); END; RUN;

muratatik · ‎10-02-2018

Yes exactly the same result 🙂 But I didnt get it. I looked some documents but couldn't find anything.

muratatik · ‎10-01-2018

Hi @ChrisNZ; I tried your solution but i didn't get the result. Your Code Result: jomjk It looks like _V[2] is John's second letter 'o'.

muratatik · ‎09-30-2018

data name ; input (v1-v5) ($) ; array _v(5) $ v1-v5; length want $8.; do i= 1 to 5; want=catt(want,substr(_v(i),1,1)); end; drop i; cards ; john peter max jann kiyaa ; run;

muratatik · ‎09-25-2018

You can use Z format. DATA HAVE; INPUT X; Y=PUT(X,Z4.2); Z=PUT(X,Z5.3); DATALINES; 6 6.1 6.12 ; RUN;

muratatik · ‎09-05-2018

You can use infile and dsd options. But your name variable sould be in quote marks. data want; infile datalines dsd dlm=","; input Name :$15. age sex $; datalines; 'kalyan,reddy',27,M 'Goutham,reddy',28,M ; run;

muratatik · ‎08-28-2018

DATA TOTAL_SALES; FORMAT DATE MMDDYY10.; INPUT DATE :MMDDYY10. AMOUNT :COMMA5.3; DATALINES; 09/05/2000 1,382 10/19/2000 1,235 11/30/2000 2,391 ; RUN;

muratatik · ‎08-27-2018

I assumed you are trying to extract numeric value of indsname. data combined; set tbl1807 tbl1806 tbl1712 indsname=ds; dsname=ds; mon=compress(dsname,,'ap'); run;

Online Status	Offline
Date Last Visited	‎01-22-2019 01:49 AM

Re: Days of the week

Re: Join Sas Data Set with Oracle Table

Re: Join Sas Data Set with Oracle Table

Join Sas Data Set with Oracle Table

Re: how to concatinate all variables of first letter

Re: how to concatinate all variables of first letter

Re: how to concatinate all variables of first letter

Re: How do I save Number to Character

Re: Importing coma delimeted text

Re: Date format not stored properly

Re: Dynamic code on basis of dataset variable values

Re: Dynamic code on basis of dataset variable values

Re: Dynamically coding using PROC SQL to select dynamic number of colu...

Re: Error with computed char variable in PROC REPORT

Re: How to copy multiple variables with transpose

Re: Days of the week

Re: Join Sas Data Set with Oracle Table

Re: Join Sas Data Set with Oracle Table

Join Sas Data Set with Oracle Table

Re: how to concatinate all variables of first letter

Re: how to concatinate all variables of first letter

Re: how to concatinate all variables of first letter

Re: How do I save Number to Character

Re: Importing coma delimeted text

Re: Date format not stored properly

Re: Trouble with indsname