About UcheOkoro

UcheOkoro · ‎07-03-2020

Please, could you send a link? I could not find it online. Thank you.

UcheOkoro · ‎07-03-2020

I would like to use the SAS array statement to create 3 new variables(yes or no) from 48 variables that contain just 3 drug classes, Benzos, Opioids and Anticholinergics. So the 48 variables are listed as drugflag1-drugflag48. The new variables 1-3 are Benzo_rc, Opioid_rc and Antichol. For variable Benzo, if drugflag1- drugflag48 has Benzo then the Variable Benzo_rc="Yes" if not Benzo_rc Data Merged_data3; Set Merged_data3; array drugname $DrugFlag1-DrugFlag48; do i = 1 to 48; IF drugname[i]= BENZO THEN benzo_rc = 1; ELSE benzo_rc = 0;End;Run; ="No". I have tried the following code but it is not working. Please, I need help.

UcheOkoro · ‎06-12-2020

I tried this and it worked. LIBNAME myperm "C:\temp\Merged\"; data myperm.Merged_data4; set Merged_data4; run; Based on your statement, I took out the "sashelp" and it worked. Thank you so much for your assistance.

UcheOkoro · ‎06-12-2020

The code is not part of a macro definition. The Merged_data4 is a data set resulting from the merging of 3 other data sets and creation of additional variables from existing ones. That is why I have 2700 lines posted.I also ran some parts of the codes repeatedly. As a result of the above reasons, I cannot run the code alone. The "sashelp" was not part of my code prior to this point. I saw it online and thought it could help me save the dataset. Thank you.

UcheOkoro · ‎06-12-2020

My sincere apologies. I did not see the portion of the message requesting for the log. This is the log for the codes and the unedited codes below. Thank you. 2769 LIBNAME myperm "C:\temp\Merged\"; -- 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 2778 LIBNAME myperm "C:\temp\Merged\"; 2779 data myperm.Merged_data4; 2780 set sashelp.Merged_data4; 2781 run; 2782 Libname Merged 'C:\Users\Uokoro.HEALTHCARE\Desktop\Delirium\'; 2783 proc datasets library=work; 2784 copy in=work out=Merged; 2785 select Merged_data4; 2786 run;quit; LIBNAME myperm "C:\temp\Merged\"; data myperm.Merged_data4; set sashelp.Merged_data4; run; Libname Merged 'C:\Users\Uokoro.HEALTHCARE\Desktop\Delirium\'; proc datasets library=work; copy in=work out=Merged; select Merged_data4; run;quit;

UcheOkoro · ‎06-12-2020

The above codes could not save the dataset to my desktop. I need a code that works and some explanation for it to help me understand how to use it. Thank you.

UcheOkoro · ‎06-12-2020

Please, I need help exporting or saving a SAS dataset to a folder on my desktop. I have tried the following codes but they did not work: LIBNAME myperm "C:\temp\Merged\"; data myperm.Merged_data4; set sashelp.Merged_data4; run; Libname Merged 'C:\Users\Jking.HEALTHCARE\Desktop\Apple\'; proc datasets library=work; copy in=work out=Merged; select Merged_data; run;quit; Thank you

UcheOkoro · ‎06-07-2020

Thank you so much!

UcheOkoro · ‎06-07-2020

Hello, I have a list of variables titled "Pain_score1 - Pain_score48". I need to create a new Pain_score_new which is the highest pain score for each individual from Pain_score1 -Pain_score48. Please, I need some help. Thank you.

UcheOkoro · ‎05-28-2020

I am trying to create a variable using an array statement. I have a dataset with variables Drug1 - Drug48. The drugs include opioid, benzo, anticholinergic and antibiotics. I want to create 3 new variables that are Opioid, benzo and anticholinergic will be " yes" or "no" . I need help. I tried using this code below but it did not help. DATA Merged_data3; Set Merged_data2; array Drug_list [*] DrugFlag1-DrugFlag48; All_Drugs= catx(' ', of Drug_list[*]); run;

UcheOkoro · ‎05-15-2020

Thank you so much!

UcheOkoro · ‎05-15-2020

I cannot tell the time but I am using the dates from other variables such as the arrival date and departure date to estimate the date. the date is 01JAN2014. It is not an interval but a fixed time. Now, I am not sure if it actually includes date or just time. Thank you.

UcheOkoro · ‎05-15-2020

Thank you so much for your prompt response. The date is 01JAN2014 . Thank you.

UcheOkoro · ‎05-15-2020

Thank you, Reeza for your prompt response. I used the following codes because I wanted the datetime: DATA Pain2; SET Pain; format medtime_sec DATETIME.; However, it gave me date as 01Jan1960 for all the observations and different times. The year is 2014 and not 1960. Thank you.

UcheOkoro · ‎05-15-2020

Hello, I have datetime written like this " 19724.704861"and I need to convert it to the SAS datetime format. I used the following code but it did not work DATA Pain2; SET Pain; Drugtime = datepart(medtime_sec); format Drugtime DATETIME.; RUN; Please, I need some help. Thank you.

Online Status	Offline
Date Last Visited	‎10-04-2023 03:36 PM

Re: Creating a variable from comparing consecutive values

Re: Creating a variable from comparing consecutive values

Re: Creating a variable from comparing consecutive values

Creating a variable from comparing consecutive values

Re: Picking values from an array of variables

Re: Picking values from an array of variables

Re: Picking values from an array of variables

Picking values from an array of variables

Re: Converting data from wide to long with missing variables in the ar...

Converting data from wide to long with missing variables in the array ...

Re: MEMSIZE adjustment

Re: I need a macro command that will give me row percent and not colum...

Re: Merging data by name and date

Re: Convert character datetime to numeric datetime

Re: Convert character datetime to numeric datetime

Re: SAS programming

Re: SAS programming

SAS programming

Re: Exporting SAS dataset

Re: Exporting SAS dataset

Re: Exporting SAS dataset

Re: Exporting SAS dataset

Exporting SAS dataset

Re: Creating variables

Creating variables

Create Indicator Variables

Re: Converting formatted datetime to datetime formatt

Re: Converting formatted datetime to datetime formatt

Re: Converting formatted datetime to datetime formatt

Re: Converting formatted datetime to datetime formatt

Converting formatted datetime to datetime formatt