About alepage

alepage · ‎06-11-2025

Hello, I have tested the code below and it works well. But I found that if we run the script again the anonymized dataset cannot be generated by append. How can we do that. Here's the orginal code data dest1.&filename dest2.&filename._Anonym; /* Clean dataset and anonymized dataset */ merge source4.&filename. (in=inbase) /* premium dataset in the subfolder related to Data_Retention*/ src1.&dsname. (in=inlist where=(filename = "&filename.")) ; /* The polices of the Master List and their location into the various premium dataset */ by ORGNL_SAS_DS_ROW_NBR; if inlist and inbase then output dest2.&filename._Anonym; else if inbase then output dest1.&filename.; run; So, I need to replace the if inlist and inbase then do; proc append base= dest2.&filename._Anonym data=??????;run;end;

alepage · ‎06-11-2025

I am using the yearlist in a loop like this one below. I am using this approach because the other loop use a list of define cie subfolder and so on. %let yearlist=2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025; %macro test; %do k=1 %to %sysfunc(countw(&yearlist.)); %put %scan(&yearlist.,&k); %end; %mend test; %test; So I am looking for a way to generate the yearlist. This one seems a good way data _null_; length yearlist $500; do year=2001 to year(date()); yearlist=catx(' ',yearlist,year); end; call symputx('yearlist',yearlist); run; other idea ?

alepage · ‎06-11-2025

Hello, I have a macro variable yearlist. Is there a way to define / upgrade it until the current year ? %let yearlist=2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023; I would like to have: some thing like %let yearlist2=2001--year(date());

alepage · ‎06-06-2025

I have added end=eof and the if eof and _infile_=' ' then delete; at the end of the input statment as you did and it works fine

alepage · ‎06-05-2025

Hello, Here's the last line of my csv file read with notepad++ 960-6217|AAA-AAA|RE|QC|B|010|BEL||CLAS||2008-05-01|2010-05-01|011047fd-c0d6-485f-9712-b5e8068b7b49cflf A12-3358|AAAA-BBBBB|AUP|QC|A|001|3143||CLAS||2005-03-01|2006-03-01|crlf crlf The last crlf cause to get an empty row that I would like to eliminate during the input statement. How to do that? data dest1.%scan(&csvFile,1,'.'); attrib POLICY_NUMBER label="Policy Number" length=$25. format=$char25. informat=$char25. POLICY_NUMBER_SRC label="Policy Number Source" length=$25. format=$char25. informat=$char25. LINE_OF_BUSINESS label="Line of Business" length=$3. format=$char3. informat=$char3. PROVINCE label="Province" length=$10. format=$char10. informat=$char10. LEGACY_UNDERWRITING_COMPANY label="Legacy Underwriting Company" length=$10. format=$char10. informat=$char10. UNDERWRITING_COMPANY label="Underwriting Company" length=$10. format=$char10. informat=$char10. DISTRIBUTOR_NUMBER label="Distributor Number" length=$10. format=$char10. informat=$char10. DISTRIBUTOR_NUMBER_SRC label="Distributor Number Source" length=$10. format=$char10. informat=$char10. SOURCE_SYSTEM label="Source System" length=$15. format=$char15. informat=$char15. DATASOURCE_BACKEND_REFERENCE label="Data Source Backend Reference" length=$10. format=$char10. informat=$char10. LAST_TERM_EFFECTIVE_DATE label="Last Term Effective Date" length=8 format=YYMMDD10. informat=YYMMDD10. LAST_TERM_EXPIRY_DATE label="Last Term Expiry Date" length=8 format=YYMMDD10. informat=YYMMDD10. CONTRACT_UUID label="Contract UUID" length=$36. format=$char36. informat=$char36. ; infile "&csvinputpath/&csvFile." LRECL=32767 TERMSTR=CRLF DLM='|' MISSOVER FIRSTOBS=2 DSD; INPUT POLICY_NUMBER : $char25. POLICY_NUMBER_SRC : $char25. LINE_OF_BUSINESS : $char3. PROVINCE : $char10. LEGACY_UNDERWRITING_COMPANY : $char10. UNDERWRITING_COMPANY : $char10. DISTRIBUTOR_NUMBER : $char10. DISTRIBUTOR_NUMBER_SRC : $char10. SOURCE_SYSTEM : $char15. DATASOURCE_BACKEND_REFERENCE : $char10. LAST_TERM_EFFECTIVE_DATE : YYMMDD10. LAST_TERM_EXPIRY_DATE : YYMMDD10. CONTRACT_UUID : $char36. ; run;

alepage · ‎06-05-2025

Hello, Here,s my data creationdate creationtime filesize 2024-09-11 14:41:09 112252063 2024-10-31 15:59:49 109152507 2024-10-31 15:59:49 556 2024-11-15 10:14:06 111706769 2025-01-07 10:02:14 112484453 2025-01-28 14:26:40 112503907 2025-05-01 15:15:33 1934 data foldercontents2; set foldercontents2; crdate = input(trim(creationdate), mmddyy10.); format crdate yymmdd10.; run; crdate is empty

alepage · ‎06-02-2025

Hello, I have may sas datasets into sub folder sas2001 until sas2024 and I looking for a Unix command to protect the folder and the sas datasets from being deleted. I have executed the Kernel scirpt below # Change directory to the target directory cd /finsys/.../LEGO_6141_Restore_sasdatasets_in_sasdata_folder/Notes_LEGO_6141_test.txt # Set permissions for all files find . -type f -exec chmod 644 {} \; # Set permissions for all directories find . -type d -exec chmod 755 {} \; But I was able to delete the file directly from winscp Any suggestion ?

alepage · ‎05-20-2025

The find function is not working ???? %macro find_example1(); %let my_string =This is a test string; %let substring =test; %let position = %sysfunc(find(&my_string, &substring)); %put Position = &position; /* Expected output: Position = 11 */ %mend; %find_example1; %macro find_example2(); %let my_string ="This is a test string;"; %let substring ="test"; %let position = %sysfunc(find(&my_string, &substring)); %put Position = &position; /* Expected output: Position = 11 */ %mend; %find_example2; How to solve this issue

alepage · ‎05-15-2025

I have many folders such as sas2000 sas2001 ... sas2025 and in each sas????, I have other subfolder What I would like to do is to copy only the premium dataset containg the string _prm Is it possible to do that with proc copy

alepage · ‎05-15-2025

One way to copy a dataset from let's say path1 to path2 is to use the libname and data statement as below %let path1= something; %let path2=something else; %let fname=be_auto_prmjun2024; libname source spde "&path1."; libname dest spde "&path2"; data dest.&fname.; set source.&fname; run; if we have many files, we coud use a filelist and a call execute and repeat the above script What will be the unix command that we could use to copy spde file containing only the string prm (stand for premium) from many subfolders to other subfolders and of course only spde file. Please provide the good unix command Please p

alepage · ‎05-14-2025

If I understand, this altlog options need to be configured by the SAS admin. Then I can you something like proc pritto altlog="alternatepath/logfile.log new";run; Is it correct. Please provide and example.

alepage · ‎05-14-2025

Hello, It is possible to reroute the sas log using this statement. proc printto log='alternate-log-file' new; run; But by doing that, in SAS EG, we are loosing the log into the various tabs. Is there a way to keek the log in SAS EG as it is and to make a copy of it somewhere else for documentation per say.

alepage · ‎05-07-2025

Hello, I have a text file like that: PB.PXDWXBX.SEDWVPAB.MP0|2918951|255186908| Here's the code: %let path1=/****/control/ ; proc import datafile = "&path1./control/be_MAR2025_premcntrlfile.txt' out = classic_control_file dbms = dlm replace ; delimiter = '|'; run; I have tried the above sas code and I am getting the error: Unable to sample external file, no data in first 5 records. ERROR: Import unsuccessful. See SAS Log for details How to solve that issue

alepage · ‎05-07-2025

I was checking just in case. Is there a way to send a return code from SAS program to have the Control-M job to failed

alepage · ‎05-05-2025

Hello, usually, control-M will execute a Kernel Script hosted on our Unix server, then passed few parameters such as the order date, and finally, we use a sysparm command to pass the order date and execute a specific sas code. I wonder if there is a way to trigger a control-M job such a file transfer, via a SAS code. If so, please provide an example.

Online Status	Offline
Date Last Visited	yesterday

Re: Not famillar with _IORC_

Not famillar with _IORC_

How to keep the original numeric format while converting SAS dataset t...

Re: The variable never been referenced in the keep statement %3F%3F%3F...

Re: The variable never been referenced in the keep statement %3F%3F%3F...

The variable never been referenced in the keep statement %3F%3F%3F%3F

Re: Reading a text file but not able to use the custom format

Reading a text file but not able to use the custom format

Re: How to execute a proc compare in a Kernel Script on a Unix server

How to execute a proc compare in a Kernel Script on a Unix server

Re: Not famillar with _IORC_

Re: The variable never been referenced in the keep statement %3F%3F%3F...

Re: do while is not working

Re: do while is not working

Re: how to exclude a directory with a find command within a pipe comma...

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

how to replace a output statement by a proc append in a if condition

Re: how to update a list of year in a macro variable automatically

how to update a list of year in a macro variable automatically

Re: Reading a csv file with input statement - how to deal with two con...

Reading a csv file with input statement - how to deal with two consecu...

converting string date to date format yyyy-mm-dd

how to protect sas datasets from being deleted accidently on a Unix se...

find function is not working into a macro function

Re: how to copy spde file from on path1 to another path

how to copy spde file from on path1 to another path

Re: Print the same SAS Log to BOTH the log window and external file at...

Routing the SAS Log to an Alternate Location

How to proc import a text file containing just one line

Re: Is there a way to start a control-M job via a SAS Code

Is there a way to start a control-M job via a SAS Code