About Tri_Luong

Tri_Luong · ‎01-29-2019

It worked. Thank so much.

Tri_Luong · ‎01-29-2019

Thank for your response, About "X", I meant it is fixed value will be declared manually by user depending on their purpose in certain situation. Thanks.

Tri_Luong · ‎01-28-2019

Hi everyone, I wanna use Proc SQL to create a new table in which I would like to get the observations with condition "WHERE" that REPORT_DATE between "first date of x+1 month(s) ago" and "2 days after last date of x month(s) ago". For eg. If x = 1 --> data from 01/11/2018 to 03/01/2019. Thank you so much for your help. Tri Luong.

Tri_Luong · ‎11-20-2018

Dear all, I am trying to write a code with Proc Import to import a *.txt file, in which there is a variable containing "card numbers" (field name: [T:L:100]CARD_NO) with 16 digits. However, after importing, the values showed in the variable are numeric as "4.69672E15". Please help to instructing me to: PROC IMPORT OUT= WORK.PORTFOLIO_TODAY DATAFILE="&rprt_cust_info.CC Customer Info &RPRT_TODAY..TXT" DBMS=DLM REPLACE; GETNAMES=YES; GUESSINGROWS=10000; DELIMITER="09"X; RUN; 1/ Keep the format of the variable as "character" when importing instead of changing the format with "data steps" after the importing. or 2/ Import all the variable as "character" format. Thank you so much.

Tri_Luong · ‎10-31-2018

Dear experts, I am trying to filter observation for latest 3 months with the condition in variable "Report_Month", I did manage to filter for currently month (October) with the code: Where REPORT_MONTH = PUT(DATE(),MMYYS10.); Would you mind instructing us, how can I filter the observations from a period (let say AUG/2018 to OCT/2018) ? Notes: the value format of the variable looks like "08/2018", "09/2018","10/2018", etc. Thank you for your helping.

Tri_Luong · ‎08-14-2018

Thank Mr. KurtBremser, If I would like to utilise the code below: %let report_date=%sysfunc(today(),ddmmyyn8.); to turn "report_date" is: + 1 previous working day (WHITHOUT holiday and weekend between) + 1 previous working day (WITH holiday and weekend between) Could you please instruct me the code for the 2 situations above!? I have tried below code: %let rprt_today = %SYSFUNC(TODAY(),yymmddn8.); %let rprt_yesterday = put(intnx('DAY',today(),-1),yymmddn8.); data temp; today = &rprt_today; yesterday = &rprt_yesterday; run; 　 PROC IMPORT OUT= LOAN_OVERDUE_YESTERDAY DATAFILE="&RPRT_DIR_LOAN.OVD-LN-&rprt_yesterday. - COPY.XLS" DBMS=XLS REPLACE; SHEET="SHEET"; RUN; but I got the notification: "ERROR: Physical file does not exist, z:\reports\loan collections\daily loan overdue report\OVD-LN-put(intnx('DAY',today(),-1),yymmddn8.) - COPY.XLS." From my observation, it might be because "rprt_today" turned out numeric value whilst "rprt_yesterday" turned out character value. Is it true?

Tri_Luong · ‎08-13-2018

Dear KurtBremser, Could you please instruct me how to define "report_date" as previous working day since today (one working day before today, excluded holidays and weekends) ?! I know that I have to declare holidays somewhere but I don't know how to do it. Thank you.

Tri_Luong · ‎08-09-2018

Thank you very much. It was what I am looking for. My scripts have worked.

Tri_Luong · ‎08-09-2018

Thanks. As I am quite newbie. Would you mind show me the detailed codes?

Tri_Luong · ‎08-09-2018

Thanks for your instruction but I would like to keep proc import. 🙂

Tri_Luong · ‎08-09-2018

Hi everyone, If I have 2 datasets having the same variables and both of them having the variable named "report_date": 1. Daily_Data (imported into LIB "Work") 2. Consolidated_Data (stored at LIB "Mylib") On daily basic, after importing "Daily_data", I am using the scripts: data Mylib.consolidated_data; set Mylib.Consolidated_data work.daily_data; run; to extend the dataset "Consolidated_data". However, to avoid combining the same source data twice or 3 times unintentionally, can we put a condition some thing like that: Let say, the dataset "Daily_data" with the variable "Report_date" having one same value. For eg. 09/08/2018. Accordingly, if the variable "Report_date" in dataset "Consolidated_data" contains at least one observation equal to 09/08/2018, the combining step will be skipped. Thank you,

Tri_Luong · ‎08-09-2018

Hi KurtBremser, What a helpful and detailed answer! It worked. However, if I would like to change "rprt_date" = today(), how can I do with the same purpose?!

Tri_Luong · ‎08-09-2018

Hi all, I trying to import one excel file in folder: D:\/SAS Practice\Input data\data_testing09082018.xls using dynamic path as below method: %let data_source = "D:\/SAS Practice\Input data\" %let report_date = '09082018'd.; proc import out=imported_data datafile= data_source report_date dbms=xls replace; sheet="sheet1"; run; data new_data; set imported_data; date_create = report_date; format date ddmmyyn8. run; My purpose is that: 1. Variable "date_create" is formatted "dd/mm/yyyy" with the value as declared "report_date" above (09/08/2018). 2. Change the files to be imported when I change the value of "report_date". 3.I am able to use "report_date" = today() if needed. Thank everyone.

Tri_Luong · ‎08-08-2018

Hi Astounding, Did you mention that I should create one more variable which is "new value" = "original_value"/1,000,000 before proc freq with weight for "new value"? If I don't want to create new variable, what should I do?!

Tri_Luong · ‎08-08-2018

Thank Astounding for your prompt feedback. However, is there any way to change the format directly on the report instead of creating new data set?

Online Status	Offline
Date Last Visited	‎01-31-2019 05:15 AM

Re: Proc SQL - Get data in a dynamic rage of days.

Re: Proc SQL - Get data in a dynamic rage of days.

Proc SQL - Get data in a dynamic rage of days.

PROC IMPORT/EXPORT - Import long-digit number as character variable.

How to filter observation from month to another month?

Re: Import file with variable directory

Re: Import file with variable directory

Re: Check data before combining datasets

Re: Check data before combining datasets

Re: Check data before combining datasets

Re: Proc SQL - Get data in a dynamic rage of days.

Re: Import file with variable directory

Re: Format results of Pro Freg

Re: Import file with variable directory

Re: Proc SQL - Get data in a dynamic rage of days.

Re: Proc SQL - Get data in a dynamic rage of days.

Proc SQL - Get data in a dynamic rage of days.

PROC IMPORT/EXPORT - Import long-digit number as character variable.

How to filter observation from month to another month?

Re: Import file with variable directory

Re: Import file with variable directory

Re: Check data before combining datasets

Re: Check data before combining datasets

Re: Check data before combining datasets

Check data before combining datasets

Re: Import file with variable directory

Import file with variable directory

Re: Format results of Pro Freg

Re: Format results of Pro Freg