About ywon111

ywon111 · ‎11-09-2021

Hi, I have a large dataset that feeds into a monthly report. How do I format the dates so it has hyphen between month and year and also, simplify it to only show first letter (e.g. J 20, F 20, M 20, A 20, M 20, etc). E.g. data report; input date date9.; format date date9.; datalines; 1JAN2021 2JAN2021 1FEB2021 ; run; Thanks

ywon111 · ‎11-02-2021

Thanks, that's exactly what I needed.

ywon111 · ‎11-02-2021

Thanks, all worked great. Adding this into title for proc report also and looks like when export to excel then the space in between day, month and year disappeared (e.g. 31OCT2021) instead of 31 OCT 2021. Any trick to fix this? This is what I have Title1 j=left "Graph1 blah blah blah as at &day &month &year"; proc report data=want ...

ywon111 · ‎11-02-2021

Latest_month is a macro to get the previous month (e.g. 31OCT2021) and I am trying to get the day (31) and abbreviated month (Oct) based on this macro,.

ywon111 · ‎11-02-2021

I have a macro to get the latest month as below and trying to use this to get day and month. %let Latest_month = %sysfunc(intnx(month, %sysfunc(today()), -1, END), date9.);; This is what I have tried: %let day = %sysfunc(month("&Latest_month"d),DAYw.); %let sysmonth= %sysfunc(put(month("&Latest_month "d),monname3.));

ywon111 · ‎10-29-2021

Is there a step by step process to add UTF8 encoding to allow other users running the code to show the macrons?

ywon111 · ‎10-27-2021

Thanks!! Threw an error but almost there I think. Any help will be much appreciated. if Ethnic_group="Maori" then Ethnic_group="Māori"; Error: An error occurred executing the workspace job "XXX". Integration technologies failed to submit the code. [Error' Failed to transcode data from U_UTF8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process.

ywon111 · ‎10-27-2021

I actually have a big dataset with people's ethnicity and Maori, NZ Pākehā is the two that needs to be reformatted so it can be presented in a proper way.

ywon111 · ‎10-26-2021

Hi Hoping to get some help. Is there a way to create a dataset that convert from Maori to Māori? data one; length name $30; input name; datalines; Maori ; run;

ywon111 · ‎10-12-2021

I have two large datasets, where variables are different but shares similar id (or name in this example), how do I find out which obs are common and not? data one; length name $30; input name; datalines; mary peter john ; run; data two; length name $30; input name; datalines; mary peter luke ; run;

ywon111 · ‎09-21-2021

Thanks it ran fine but it's missing one part. I receive data quarterly which contains the latest three quarters (e.g. Dec 2019, Mar 2020, Jun 2020), these numbers gets updated so it needs to be appended to the base and overwrite as it contains data from June 1999 to March 2020 (the Dec 2019 and Mar 2020 in base will need to be removed and overwritten with the newly updated data). Hope this makes sense...

ywon111 · ‎09-21-2021

I get records of three quarters' worth of data (e.g. Jun20, Sep20 and Dec20) that needs to be appended and overwrite the base dataset which has historical data tracking from Jun96 plus other quarters except latest Dec20. The latest three quarters need to overwrite existing ones in base as the values there gets updated. Month Value Jun19 100 Jun19 100 Sep19 100 Sep19 100 Sep19 100 Dec19 100 Dec19 100 Dec19 100 Dec19 100 Mar20 100 Mar20 100 Jun20 100 Sep20 100 Sep20 100 Sep20 100 Dec20 100

ywon111 · ‎09-20-2021

You always start with 12 observations and always want to replace the last 3 ? No. There are more month/year data further up the table but will receive last three months so need to keep the historical data while append & overwrite the latest three months. Your data has no identifiable order to it? No year variable? No ordered value for month like a value from 1 to 12? The data is currently order by month. I guess it's something more like this Month Values Aug-19 100 Sep-19 100 Oct-19 100 Nov-19 100 Dec-19 100 Jan-20 100 Feb-20 100 Mar-20 100 Apr-20 100 May-20 100 Jun-20 100 Jul-20 100 Aug-20 100 Sep-20 100 Oct-20 200 Nov-20 200 Dec-20 200

ywon111 · ‎09-20-2021

Hi, I receive a new dataset each month and hoping to append this to the base dataset and overwrite the latest three months. What is the best way to code this? Thanks Base: Month Values Jan 100 Feb 100 Mar 100 Apr 100 May 100 Jun 100 Jul 100 Aug 100 Sep 100 Oct 100 Nov 100 Dec 100 Second dataset: Month Values Oct 200 Nov 200 Dec 200 This is what I want Month Values Jan 100 Feb 100 Mar 100 Apr 100 May 100 Jun 100 Jul 100 Aug 100 Sep 100 Oct 200 Nov 200 Dec 200

ywon111 · ‎09-07-2021

I think this is a simple one. This is what I have date Type Count Jan-21 A 100 Jan-21 B 200 Feb-21 A 300 Feb-21 B 400 This is what I want date Type Count Jan-21 A 100 Jan-21 B 200 Jan-21 C 300 Feb-21 A 300 Feb-21 B 400 Feb-21 C 700 Thanks

Online Status	Offline
Date Last Visited	‎05-18-2023 02:15 AM

Proc sql: merging two datasets and possibly two columns

Count cumulative by groups

Re: Sort by datetime

Sort by datetime

Lag function help

Proc transpose?

What is the "month12.7" format?

Convert year and month columns to a date in one column

Re: proc transpose with some records missing

Re: proc transpose with some records missing

Re: Lag function help

Re: Convert year and month columns to a date in one column

Re: Proc sql to subtract numbers from another dataset

Re: Proc report

Re: proc transpose with some records missing

Re: proc transpose with some records missing

proc transpose with some records missing

Convert character to date

Add hypen in month year dates (e.g. Jan-20) and another format to J 20

Re: Get day and abbreviated month of a date (e.g. 2 Nov)

Re: Get day and abbreviated month of a date (e.g. 2 Nov)

Re: Get day and abbreviated month of a date (e.g. 2 Nov)

Get day and abbreviated month of a date (e.g. 2 Nov)

Re: Adding a macron (e.g. café)

Re: Adding a macron (e.g. café)

Re: Adding a macron (e.g. café)

Adding a macron (e.g. ā)

Compare two large datasets and see which observations are missing

Re: Append and overwrite a second dataset to the base

Re: Append and overwrite a second dataset to the base

Re: Append and overwrite a second dataset to the base

Append and overwrite a second dataset to the base

proc sql & sum