About sasecn

sasecn · ‎03-31-2023

Thanks for the explanation. I am using EG, will talk to the IT in my company.

sasecn · ‎03-31-2023

Thanks for the replay. I checked that my encoding is not set to UTF8. Then, how to set to UTF8? I tried to search some solutions, just don't know how to do it. e.g. at SAS invocation add the option, –encoding utf-8 add the system option to the SAS configuration file, ENCODING=UTF-8,

sasecn · ‎03-30-2023

I have a general question. I tried to import Excel file into SAS dataset. There are some special characters, e.g. Ōki. How to keep those special characters (not sure if they are called non ASCII or not)? I tried to use proc import. The char is just missing e.g. Ōki in Excel, but only shows "ki" in SAS dataset. I also tried to use libname pcfiles to load the Excel file into SAS dataset. But the special char was replaced by "?". e.g. Ōki in Excel, but shows "?ki" in SAS dataset.

sasecn · ‎03-09-2023

Thanks for your reply. It works on the sample data I provided. The real data I am working on has more other types of variables. And I cannot change the whole data structure to long data. Ideally, I would like just add quarterly active proportion variable after each quarter. Part of the data like: userID ac12022 ac22022 ac32022 acq12022 ac42022 ac52022 ac62022 acq22022 ac72022 1 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2 0.00 0.38 1.00 0.79 1.00 1.00 1.00 1.00 1.00

sasecn · ‎03-09-2023

I have a given data that indicates user active proportion for each month. It depends on the active days during each month. Given this, I tried to write loop to get active proportion for each quarter. Just cannot find a better way to index the loop. For example, one user active only in January, then the active proportion during first quarter (Jan. Feb. and March) would be 31/(31+28+31), or the average of active proportion for Jan, Feb and March. Thanks for any help! given data like: userID ac12022 ac22022 ac32022 ac42022 ac52022 ac62022 ac72022 ac82022 ac92022 ac102022 ac112022 ac122022 1 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2 0.00 0.38 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 wanted data like: (e.g. first quarter active proportion = (0 + 0.38 +1) / 3 userID acq12022 acq22022 acq32022 acq42022 1 1.00 1.00 1.00 1.00 2 0.46 1.00 1.00 1.00

sasecn · ‎10-23-2022

Sorry, my bad, I should capture that. The code works. Thanks! Some part of the code, I still don't understand, but I think I can figure it out by some additional readings. Thanks again!

sasecn · ‎10-23-2022

Thanks for your reply. I got an error when I tried the code. I first create the test data just like my first table: work_id work_start work_end 1 15-Jun-22 15-Jun-23 2 15-May-21 10-May-22 I called it "have", when I ran the code, I got this: Any idea, what it would be?

sasecn · ‎10-23-2022

I am trying to get work active flags for each month during past 2 years depending on work start and end dates. My sample is like: work_id work_start work_end 1 15JUN2022 15JUN2023 2 15MAY2021 10MAY2022 So, my result will add 24 work active flags from Jan. 2021 to Dec. 2022. Work is active for each month if start before last day of month and end after first of month, result looks like: work_id work_start work_end .... active_3_2022 active_4_2022 active_5_2022 active_6_2022 ... 1 15MAY2022 15JUN2023 ... 0 0 1 1 ... 2 15MAY2021 10MAY2022 ... 1 1 1 0 ...

sasecn · ‎06-03-2022

Thanks for your reply. I am using the variable "v1" in proc sql to create anther variable which is the substred value. Would call scan work in proc sql?

sasecn · ‎06-03-2022

This should be a simple question. I have a string, e.g a variable called "v1" that has value of "11-abc-def-1234-q111". I want to just keep all after the third hyphen. So, the result should be "1234-q111". I used scan(v1, 4, '-') it just gave me "1234". I tried to use catx (scan(v1, 4, '-'), scan(v1, 5, '-')). I still cannot get the result wanted. I felt it is about the position index i used, but not sure. Any help would be appreciated. Thanks.

sasecn · ‎03-06-2022

Thank you for all the help! Great explanation from everyone 😀

sasecn · ‎03-06-2022

Thank you!

sasecn · ‎03-06-2022

Thanks for the details!

sasecn · ‎03-06-2022

Thanks.

sasecn · ‎03-05-2022

No specific reason to keep the position. Our dataset is always arranged by different group of variables. Just wanted to keep the recoded var in the same group. like said wondered if there is an easy wat to do it without many additional codes.

Online Status	Offline
Date Last Visited	‎04-04-2023 02:16 PM

Re: How to keep special (non ascii) characters when import from Excel

Re: How to keep special (non ascii) characters when import from Excel

How to keep special (non ascii) characters when import from Excel

Re: given active proportion for each month, how to get active proporti...

given active proportion for each month, how to get active proportion f...

Re: create active flag based on start and end dates

Re: create active flag based on start and end dates

create active flag based on start and end dates

Re: keep all char after specific position of hyphen

keep all char after specific position of hyphen

Re: How to keep special (non ascii) characters when import from Excel

Re: create active flag based on start and end dates

Re: keep all char after specific position of hyphen

Re: keep all char after specific position of hyphen

Re: Recode variable keeping the same name and position

Recode variable keeping the same name and position

Re: SAS EG prompt manager: select values from static list

Re: SAS EG prompt manager: select values from static list

Re: How to keep special (non ascii) characters when import from Excel

Re: How to keep special (non ascii) characters when import from Excel

How to keep special (non ascii) characters when import from Excel

Re: given active proportion for each month, how to get active proporti...

given active proportion for each month, how to get active proportion f...

Re: create active flag based on start and end dates

Re: create active flag based on start and end dates

create active flag based on start and end dates

Re: keep all char after specific position of hyphen

keep all char after specific position of hyphen

Re: Recode variable keeping the same name and position

Re: Recode variable keeping the same name and position

Re: Recode variable keeping the same name and position

Re: Recode variable keeping the same name and position

Re: Recode variable keeping the same name and position

SAS Analytics Explorers