About Gieorgie

tinton · ‎04-17-2023

It's working for me! Thanks for this code

Kurt_Bremser · ‎05-18-2022

Datetimes and times are counts of seconds in SAS, while dates are counts of days; so datetime = date * 86400. Always keep this in mind when working with such values. The functions you need for the conversions are DATEPART - extracts the date from a datetime TIMEPART - extracts the time from a datetime DHMS - builds a datetime from a date, hours, minutes and seconds; to build a datetime from a date and a time, use DHMS(date,0,0,time)

andreas_lds · ‎04-29-2022

Have a closer look at Step-by-Step Programming with Base SAS ® 9.4. You need two statements: one assigns the value to the variable run_date, another to attach the format to the variable. format run_date date9.; run_date = today(); EDIT: Link inserted

Patrick · ‎04-04-2022

proc sql; create table BH_D_ZAB_X_ALOK as select max(DATA_DANYCH) as DATA_DANYCH from cmz.BH_D_ZAB_X_ALOK_&thismonth where DATA_DANYCH eq intnx('month',DATA_DANYCH,0,'e') ; quit;

PaigeMiller · ‎02-01-2022

Use the CALL MISSING function in a DATA step if variablename=0 then call missing(variablename);

Gieorgie · ‎01-31-2022

It is as you say, thanks for the advice;)

Gieorgie · ‎01-28-2022

Thanks ! its working ! I have last quesiton, can i use proc export and use dbms like xlsx or keep ods excel ?

Kurt_Bremser · ‎01-21-2022

@Gieorgie wrote: Ok, im trying to do like ODS EXCEL, when it generates the file it is created but empty ods excel file = "&glb_path2./reports/mth_ak/COREP_CR_&gv_tbl_date..xlsx"; proc print data=COREP_CR_&gv_tbl_date; ods excel close; You have no RUN statement to create a step boundary, and global statements (like ODS) are executed immediately when encountered, so the Excel destination is closed before PROC PRINT writes any output to it. See Maxim 49.

Kurt_Bremser · ‎12-22-2021

You won't be able to do this automatically, as your formatted value "OLD" can't be recognized by Excel as a date. Change your SQL: proc sql; create table final_wygasle as select put(policy_vintage,vintf.) as policy_vintage ,TODAY ,PREV_MONTH ,PREV_WEEK ,DIFF_WEEK ,DIFF_MONTH from diff_policy_exp ; quit; so that the data ends as character in Excel.

PaigeMiller · ‎12-21-2021

I would imagine something like this would work where your_date_variable ne intnx('month',your_date_variable,0,'e')

Gieorgie · ‎12-21-2021

Thanks Kurt very much ! Happy xmass 🙂

Tom · ‎11-30-2021

So you seem to have clarified your request. I would like to add PLN = 1 to each date Why not just add them when you create the dataset? create table kursy as select DATA_DANYCH , CURRENCY_SHORT_NAME as WALUTA , REVAL_RATEMID as KURS from kondor.K_FXRATES where DATA_DANYCH between '24Apr2016'd and &gv_date_kon. and CURRENCY_SHORT_NAME in ("EUR", "USD") union select distinct DATA_DANYCH , 'PLN' as WALUTA , 1 as KURS from kondor.K_FXRATES where DATA_DANYCH between '24Apr2016'd and &gv_date_kon. and CURRENCY_SHORT_NAME in ("EUR", "USD") order by DATA_DANYCH ; Now if you want to add a record for every date from '24Apr2016'd to &gv_date_kon rather than just those that appear in kondor.K_FXRATES then you might want a different approach. data extra ; if 0 then set kursy ; WALUTA = 'PLN' ; KURS=1; do DATA_DANYCH = '24Apr2016'd to &gv_date_kon. ; output; end; run; proc append base=kursy data=extra; run;

Kurt_Bremser · ‎11-19-2021

%let date_dly = 15nov2021; %let gv_date_dl = %sysfunc(intnx(month,%sysevalf("&date_dly."d),-1,e)); %put &=gv_date_dl; %put %sysfunc(putn(&gv_date_dl.,yymmdd10.)); The last two statements are for control purposes only.

Reeza · ‎11-09-2021

You need to show the full list.

ballardw · ‎11-05-2021

@Gieorgie wrote: Maybe because the proc format I have old and other and moving do date format like a below ? proc format; value vintf low-&date_old = 'old' other=[yymmd7.]; run; proc summary data=diff nway; class policy; format policy vintf.; var date_today date-1; output out=newdiff sum=; expired_date is not a date other has date format It does not matter what the format is for a variable when you use a WHERE or similar statement that does comparisons unless you explicitly use Put(somevar, someformatname.) in the comparison. And I really don't get why a POLICY would use a DATE format to begin with. But the values to exclude use the same rules. You still haven't shown a data step of any of the data involved.

Online Status	Offline
Date Last Visited	‎05-18-2022 08:13 AM

Change data format in dataset

How to add today() date do data

How to show one result in record

SAS how to replace 1960-01-01 with a blank field

Re: Problem with showing results after creating a column

Problem with showing results after creating a column

Re: Import to excel using ods with two decimal places

Import to excel using ods with two decimal places

Re: Show result numbers with two decimal places

Re: Show result numbers with two decimal places

Re: How to add today() date do data

Re: SAS how to replace 1960-01-01 with a blank field

Re: Problem with showing results after creating a column

Re: Import to excel using ods with two decimal places

Re: Aggregate to show results for the current year only

Re: Removing the .bak with proc export

SAS how to replace 1960-01-01 with a blank field

Re: Show result numbers with two decimal places

Re: Removing the .bak with proc export

Re: Change data format in dataset

Re: How to add today() date do data

Re: How to show one result in record

Re: SAS how to replace 1960-01-01 with a blank field

Re: Problem with showing results after creating a column

Re: Import to excel using ods with two decimal places

Re: Show result numbers with two decimal places

Re: Changing the date from numeric to date format before exporting to ...

Re: exclude last day of each month

Re: Aggregate to show results for the current year only

Re: Problem with insert into

Re: Selection of the previous date and comparison of the result with t...

Re: Problem with set up graph

Re: Line graph problem with xlabel