About alepage

alepage · ‎03-05-2024

Hello, our operating system is Unix and I am interested by a pipe command to read the file directly. Could you please provide an example. I the same line of though, it is possible to retreive a line into a dataset without unzipping it?

alepage · ‎03-05-2024

How to read how to read dat.z file and .sas7bdat.z file without unzipping it /folder1/haauto.prm.oct1995.dat.Z /folder2/avr1991.sas7bdat.Z Please provide SAS code example.

alepage · ‎02-29-2024

Hello, I have found duplicate spde file into many folder. For example, in sas2023 folder, I see ha_auto_inforcefev2023.dpf.00010aa2.215.1.spds9 April 4, 2023 ha_auto_inforcefev2023.dpf.0000c9da.15.1.spds9 February 28, 2023 I have the same issue with premium dataset ha_auto_prmfev2023.dpf.0000c9da.67.1.spds9 April 4, 2023 ha_auto_prmfev2023.dpf.00010aa2.23.1.spds9 February 28, 2023 I would like to delete those on April 4. How do we do that ?

alepage · ‎02-27-2024

Hello, I would like to know if someone has already developped a SAS scprit to estimate the last time an oracle table was updated. Please provide an example. Regards, I have tried that in Toad: SELECT (MAX(ora_rowscn)) from MRKT_???.QUALTRIX_??????; The response is: 6479526695024 select scn_to_timestamp(6479526695024) as timestamp from dual; ora-08181; specific number is not a valid system change number ora-06512 : at sys.scn_to_timestamp, line 1 How can I get the last updated date

alepage · ‎02-23-2024

Hello Kurt, I have used exactly a script similar to yours but I found that some files have very large file extension that I am not famillar with. What's the maximum length for a file extension. I am scanning files that have been created since 2010, therefore I am getting very large file extension, and some file name does not have a dot. So when I scan for file extension, I am getting the complete file name. Any idea how to solve that issue. Thank in advance for your help.

alepage · ‎02-23-2024

Hello, I have made a listing of all the folders and all the files from the root (/folder1/...) using two different find command. But after, reviewing the files listing, I have found that some files have does not have file extension. Is there a Unix command that I can use in SAS to get the file extension. Please provide a sample example. libname dest1 base "/.../Data_Retention/data"; filename folderls pipe "find /folder1/sasdata/ -type d "; data dest1.folderslisting; length text $2000.; infile folderls; input; text=_infile_; run; filename filelist pipe "find /folder1/sasdata/ -type f "; data dest1.fileslisting; length text $1000.; infile filelist; input; text=_infile_; run;

alepage · ‎02-22-2024

A colleague suggested me to use the option dlm='|' to force to read the complete line. But I wonder if there is a better option or combined options to do that . Here's the code : filename filelist pipe "find /folder1/sasdata/TestActuariat/ -type f "; data fileslisting2; length text $1000.; infile filelist dlm='|'; input text; run; Here's an observation of fileslisting2; Does the option dlm='|' is a good one or can we do better? /folder1/sasdata/TestActuariat/Conversion Classic/Cycle3/gc/habi/gc_res_prop_jul2018.dpf.00010f97.0.1.spds9 Without the good option we get: /folder1/sasdata/TestActuariat/Conversion

alepage · ‎02-20-2024

No, 2/1/2024 , I dont' know where does come from this date ?

alepage · ‎02-19-2024

Hello, In my SAS dataset, the content of the variable HRDEBTRA look like : 14:50:05 Then if the Oracle table does not exist, I am using a proc append proc append base=&libref..&table_name data=&table_name; run; where &libref is the name of the oracle schema, and table_name is the table name (target table) work.&table_name (source table) if the Oracle table exist the we update the table using the script below: options sastrace=',,;d' sastraceloc=saslog nostsuffix; proc sql; connect to oracle (AUTHDOMAIN=ORACLE_&OWNER._&Database. PATH=&Database. readbuff=1000); execute( MERGE INTO &schema..&TblName1. pt USING &SCHEMA..&TblName2. ps ON (pt.recordId = ps.recordId) WHEN NOT MATCHED THEN INSERT VALUES (&varlist1.) WHEN MATCHED THEN UPDATE SET &varlist2. ) BY ORACLE; DISCONNECT FROM ORACLE; quit; However, the variable HRDEBTRA in the Oracle table is like a date. What's the best way to convert that funzy date to HH24:mm:ss ex: 14:50:05 2/1/2024 2:50:05 PM

alepage · ‎02-16-2024

data _null_; set filelisting; infile unix pipe filevar=unixcommand end=eof; do while (not eof); input; put _infile_; end; run; I might be wrong but what I think, is: set filelisting; is use to select the dataset that I want to use do while (not eof); ... end will execute what at in between until the end of the file. input statement read the file filelisting one record at the time which is put into _infile_; infile unix pipe ????

alepage · ‎02-16-2024

Few days ago, someone from the community propose me the script below to send multiple unix command to our unix server. It works well. However the purpose of my request today is could someone explain me in details how does it works because it is not clear in my mind. Please note that the filename is filelisting, the variable unixcommand contains the unix commands to be sent to the unix server. Could you please explain each step of this piece of code data _null_; set filelisting; infile unix pipe filevar=unixcommand end=eof; do while (not eof); input; put _infile_; end; run;

alepage · ‎02-13-2024

Thank you very much

alepage · ‎02-13-2024

Hello, I have a dataset name filelisting. One of its variable is unixcommand and the first observation look like below sed -i 's/"prod@test.net"//g' /.../sasmacro/email.sas if I execute the above unix command directrly on the terminal via winscp, its works very well and it erase the sting "prod@test.net" from email.sas How do we passed this unix command using data _null_; set filelisting; call execute('something'); run;

alepage · ‎02-06-2024

Hello, I am using the script below to put all the values into macro variables but it reads only the first value. Why? How to solve that Issue. Vartable 3 first observations only name1 name2 ps.startDate, pt.startDate = ps.startDate, ps.endDate, pt.endDate = ps.endDate, ps.status, pt.status = ps.status, proc sql noprint ; select strip(name1), strip(name2) into :varlist1, :varlist2 from vartable; Quit; %put &=varlist1.; %put &=varlist2.;

alepage · ‎02-05-2024

You got a good point Mr. Bremser, but do you think that I will still need a pass trough facility to drop the table, ie. something that will produce that string: 'drop table myoracle.ALPSOURCE'; %macro check_oracletbl (owner,database,schema,tablename); proc sql; connect to oracle (AUTHDOMAIN=ORACLE_&OWNER._&database. PATH=&database. readbuff=1000); execute( DECLARE tbl_count number; var1 varchar2(100); BEGIN SELECT COUNT(*) INTO tbl_count FROM &SCHEMA..&tablename.; IF tbl_count <> 0 THEN var1:= "' "||"DROP TABLE "||"&SCHEMA."||"."||"&TABLENAME."||" '"; /* var1:= 'drop table myoracle.ALPSOURCE'; */ EXECUTE IMMEDIATE var1 ; END IF; END; ) BY ORACLE; DISCONNECT FROM ORACLE; quit; %mend check_oracletbl; %check_oracletbl(&owner., &Database.,&schema.,&TblName2.);

Online Status	Offline
Date Last Visited	Wednesday

Re: How to use a macro variable in a if else condition

Re: How to use a macro variable in a if else condition

Re: How to use a macro variable in a if else condition

How to use a macro variable in a if else condition

Re: How to use a proc datasets move statement but with a password

How to use a proc datasets move statement but with a password

Re: Not famillar with _IORC_

Re: Need two run the SAS code two time to get the marcro variable valu...

Need two run the SAS code two time to get the marcro variable value. ...

Re: What's the best and more efficient method to map / define one vari...

Re: How to use a macro variable in a if else condition

Re: How to use a proc datasets move statement but with a password

Re: How to use a proc datasets move statement but with a password

Re: How to use a proc datasets move statement but with a password

Re: Need two run the SAS code two time to get the marcro variable valu...

Re: how to get a bearer token using SAS

case when else end as varname is not working properly when the variab...

Re: Searching a specific value in many dataset then putting some info ...

Re: Searching a specific value in many dataset then putting some info ...

Re: How to rename a file using unix command mv

Re: how to read dat.z file and .sas7bdat.z file without unzipping it

how to read dat.z file and .sas7bdat.z file without unzipping it

how to delete spde files on a specific date

how to know when an Oracle table was last updated

Re: Unix command to get file extension

Unix command to get file extension

using the good option with infile statement

Re: How to convert hh:mm:ss from a SAS dataset to an Oracle Table

How to convert hh:mm:ss from a SAS dataset to an Oracle Table

Re: how to send a unix command to a unix server using a pipe command

how to send a unix command to a unix server using a pipe command

Re: how to use a call execute to pass a unix command

how to use a call execute to pass a unix command

Put all values of a variable into macro variable using proc sql into b...

Re: How to check if an Oracle table exist using sas code