About shami

shami · ‎08-19-2024

I would like to create a table that looks like this: Demographics Identified Missing Total N % N % PATIENT_COUNTY1 PATIENT_RACE1 PATIENT_ETHNICITY1 PATIENT_BIRTH_SEX1 PATIENT_DOB1 I have the following code below, I don't know how to proceed from here or if I'm doing the right thing or if this step is even necessary. Thank you. DATA WANT; SET HAVE; LENGTH PATIENT_COUNTY1 $20 PATIENT_RACE1 $50 PATIENT_ETHNICITY1 $50 PATIENT_BIRTH_SEX1 $20 PATIENT_DOB1 $50 GENDER_IDENTITY1 $20; IF PATIENT_COUNTY = '' THEN PATIENT_COUNTY1 = 'MISSING'; ELSE PATIENT_COUNTY1 = 'IDENTIFIED'; IF PATIENT_RACE = '' THEN PATIENT_RACE1 = 'MISSING'; ELSE PATIENT_RACE1 = 'IDENTIFIED'; IF PATIENT_ETHNICITY = '' THEN PATIENT_ETHNICITY1 = 'MISSING'; ELSE PATIENT_ETHNICITY1 = 'IDENTIFIED'; IF PATIENT_BIRTH_SEX = '' THEN PATIENT_BIRTH_SEX1 = 'MISSING'; ELSE PATIENT_BIRTH_SEX1 = 'IDENTIFIED'; IF PATIENT_DOB = '' THEN PATIENT_DOB1 = 'MISSING'; ELSE PATIENT_DOB1 = 'IDENTIFIED'; IF GENDER_IDENTITY = '' THEN GENDER_IDENTITY1 = 'MISSING'; ELSE GENDER_IDENTITY1 = 'IDENTIFIED'; RUN; The above code gives me the following table: ID PATIENT_COUNTY1 PATIENT_RACE1 PATIENT_ETHNICITY1 PATIENT_BIRTH_SEX1 PATIENT_DOB1 1 IDENTIFIED IDENTIFIED MISSING IDENTIFIED MISSING 2 IDENTIFIED IDENTIFIED MISSING IDENTIFIED MISSING 3 IDENTIFIED IDENTIFIED MISSING IDENTIFIED MISSING

shami · ‎08-06-2024

I have a date variable that's numeric in the format ddmmyy10. in my data. How do I filter my data to show data say between 1 Jan 2024 and 30 June 2024. Thank you.

shami · ‎07-16-2024

Noted.

shami · ‎07-15-2024

I would like to count the number of tests collected. For each observation, a sample collected would be counted as 1. For example if visit_id 01 had samples 1, 2, 3 and 4 collected that would be counted as one. If visit_id 06 has zero samples collected that would be 0. I'm guessing I have to create a new variable that does that, I'm just not sure how. Thank you. DATA COUNT; INPUT VISIT_ID SAMPLE_1 SAMPLE_2 SAMPLE_3 SAMPLE_4; CARDS; 01 1 1 0 1 02 1 0 1 1 03 0 0 1 0 04 1 1 1 1 05 1 0 0 0 06 0 0 0 0 ; RUN;

shami · ‎07-15-2024

My apologies for the unclear subject line. The body describes exactly what I'm trying to do. I don't want to count across. I'm sorry for the confusion.

shami · ‎07-15-2024

I would like to count the number of tests collected. For each observation, a sample collected would be counted as 1. For example if visit_id 01 had samples 1, 2, 3 and 4 collected that would be counted as one. If visit_id 06 has zero samples collected that would be 0. I'm guessing I have to create a new variable that does that, I'm just not sure how. Thank you. DATA COUNT; INPUT VISIT_ID SAMPLE_1 SAMPLE_2 SAMPLE_3 SAMPLE_4; CARDS; 01 1 1 0 1 02 1 0 1 1 03 0 0 1 0 04 1 1 1 1 05 1 0 0 0 06 0 0 0 0 ; RUN;

shami · ‎07-12-2024

Hi everyone, I would like to convert a numeric YYMMDD10. to a numeric Date9. I have the following code but I'm not getting a result. DATA WANT; SET HAVE; DATE = INPUT(tdy_date,YYMMDD10.); FROMAT DATE DATE9.; RUN;

shami · ‎07-05-2024

@PaigeMiller Thank you so much for the detailed explanation, this worked. Moving forward I'll also make sure that my data is presented as a working SAS data step code.

shami · ‎07-03-2024

I'm new to SAS and have cleaned my dataset and have it as follows: VxDate Moderna Pfizer Spikevax Total Year VxMonth 07/05/2023 0 1 0 1 2023 July 08/07/2023 0 1 0 1 2023 August 09/05/2023 1 1 1 3 2023 September I would like to create a report that summarizes the vaccines by month and the total vaccines administered each month. The above only shows 3 dates, my data has dates from Jan 2023 to Dec 2023. I would like data in the following format: VaxType July August September Total Moderna Pfizer Spikevax Thank you

shami · ‎04-11-2024

I have the following date variable: Collection_date 1/1/2023 5:27:00 PM 2/2/2023 2:40:00 PM 3/4/2023 12:02:00 PM 4/6/2023 11:59:00 AM And I would like to convert it or create a new date variable and have it in the following format: Date 01Jan2023 02Feb2023 04Mar2023 Kindly help with the appropriate code for this.

shami · ‎04-09-2024

Thank you this is helpful

shami · ‎04-08-2024

I merged the dataset with the following code by the patient ID: data raw3; merge raw1 raw2; by patient_local_id; run; I'm not sure how I'd code after this to get the missing observations...

shami · ‎04-08-2024

I've got two datasets that are similar. I've run frequency counts for the same variable, however I noticed that one dataset has two less observations. What's the best way/approach to identify what those two observations that are missing from the other data set are?

shami · ‎11-18-2022

I've been wondering if there's a way to convert a code that I've run in SAS studio to an interactive report or if it's possible to interface a code I've run in SAS studio with SAS Viya to generate interactive visuals and graphics ? If this is possible kindly provide steps. Thanks.

Online Status	Offline
Date Last Visited	‎08-28-2024 01:20 PM

Summary table of missed and identified entries

Filtering data with a date range

Re: Creating new variable that counts number of visits

Creating new variable that counts number of visits

Re: Creating new variable that counts across each observation

Creating new variable that counts across each observation

Converting numeric YYMMDD10. to numeric Date9.

Re: How do I create the following report?

How do I create the following report?

Date variable

Re: Importing sas7bdat file

Re: Filtering data with a date range

Re: Creating new variable that counts across each observation

Re: How do I create the following report?

Re: Date variable

Summary table of missed and identified entries

Filtering data with a date range

Re: Creating new variable that counts number of visits

Creating new variable that counts number of visits

Re: Creating new variable that counts across each observation

Creating new variable that counts across each observation

Converting numeric YYMMDD10. to numeric Date9.

Re: How do I create the following report?

How do I create the following report?

Date variable

Re: Missing observations

Re: Missing observations

Missing observations

Convert SAS code into an Interactive report