About Dhana18

Dhana18 · ‎02-13-2019

Reeza, Here is the log. DATA SUBMTWO.Clinicdata29_1; 272 SET SUBMTWO.Clinicdata29; 273 274 IF CL_PATIENTID='50055' then flag1=1; 275 if visdate="11/27/2017" then flag2=1; 276 RUN; NOTE: There were 3414 observations read from the data set SUBMTWO.CLINICDATA29. NOTE: The data set SUBMTWO.CLINICDATA29_1 has 3414 observations and 59 variables. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.03 seconds 　 proc print data=SUBMTWO.Clinicdata29_1; var flag1 flag2 cl_patientid TOC_VIS; where cl_patientid="50055"; run; here is the result Obs flag1 flag2 CL_PATIENTID TOC_VIS83910851203 1 . 50055 1 . 50055 1 . 50055 I DONOT want to flag on all visit just one specific date.

Dhana18 · ‎02-13-2019

Thank you al for trying to help me. I tried all of the suggested codes, but so far it is not working.

Dhana18 · ‎02-13-2019

here is the output The SAS System Obs flag1 flag2 CL_PATIENTID TOC_VIS 839 1 . 50055 1085 1 . 50055 1203 1 . 50055 same patient visited the clinic multiple times and I only want to have 1 on a specific visdate. Please help.

Dhana18 · ‎02-13-2019

165 DATA SUBMTWO.Clinicdata29_1; 166 SET SUBMTWO.Clinicdata29; 167 IF Strip(CL_PATIENTID)='50055' and strip(visdate)="11/27/2017" THEN TOC_VIS='1'; 168 RUN; NOTE: There were 3414 observations read from the data set SUBMTWO.CLINICDATA29. NOTE: The data set SUBMTWO.CLINICDATA29_1 has 3414 observations and 57 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.01 seconds Did not work 😞

Dhana18 · ‎02-13-2019

Reeza, I ggot this error message and 137 DATA SUBMTWO.Clinicdata29_1; 138 IF CL_PATIENTID='50055' then flag1=1; 139 if visdate="11/27/2017" flag2=1; ----- 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. Then I di d this DATA SUBMTWO.Clinicdata29_1; IF CL_PATIENTID='50055' then flag1 = "1"; if visdate="11/27/2017" then flag2 = "1"; RUN; 149 DATA SUBMTWO.Clinicdata29_1; 150 IF CL_PATIENTID='50055' then flag1 = "1"; 151 if visdate="11/27/2017" then flag2 = "1"; 152 RUN; NOTE: Variable CL_PATIENTID is uninitialized. NOTE: Variable visdate is uninitialized. NOTE: The data set SUBMTWO.CLINICDATA29_1 has 1 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.06 seconds CL_Patientid can be repeated, because same patient may have come to the clinic multiple times in a year. That is why I used visdate.

Dhana18 · ‎02-13-2019

Good morning, I wanted to modify the value (from blank to 1) in one of the records. This is how i coded. Visdate is a character variable. DATA SUBMTWO.Clinicdata29_1; SET SUBMTWO.Clinicdata29; IF CL_PATIENTID='50055' and visdate="11/27/2017" THEN TOC_VIS='1'; RUN; proc print data=SUBMTWO.Clinicdata29_1; var cl_patientid toc_viss; where cl_patientid="50055"; run; Log shows no erreor. DATA SUBMTWO.Clinicdata29_1; 130 SET SUBMTWO.Clinicdata29; 131 IF CL_PATIENTID='50055' and visdate="11/27/2017" THEN TOC_VISs='1'; 132 RUN; NOTE: There were 3414 observations read from the data set SUBMTWO.CLINICDATA29. NOTE: The data set SUBMTWO.CLINICDATA29_1 has 3414 observations and 58 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds What am i doing it wrong?

Dhana18 · ‎02-06-2019

Hello, SAS community support is a great resource for me. Than you all. I need to convert multiple date variables into numeric and this is what I did. Is this right and is there a better efficient way to do this? /*FIXING CHARACTER DATE INTO NUMERIC DATE 8*/ data SUBMTWO.Labdata29_C; set SUBMTWO.Labdata29_B; FORMAT SPECCOLLECTDATE YYMMDD10.; SPECCOLLECTDATE = INPUT (SPEC_COLLECT_DATE, YYMMDD10.); DROP SPEC_COLLECT_DATE; RENAME SPECCOLLECTDATE=SPEC_COLLECT_DATE; FORMAT DATETEST_LAB YYMMDD10.; DATETEST_LAB = INPUT (DATETESTLAB, YYMMDD10.); DROP DATETESTLAB; RENAME DATETEST_LAB=DATETESTLAB; FORMAT DATE_DONE1 YYMMDD10.; DATE_DONE1 = INPUT (DATEDONE1, YYMMDD10.); DROP DATEDONE1; RENAME DATE_DONE1=DATEDONE1; FORMAT ETDATE_DONE YYMMDD10.; ETDATE_DONE = INPUT (ETDATEDONE, YYMMDD10.); DROP ETDATEDONE ; RENAME ETDATE_DONE=ETDATEDONE; FORMAT DATESENT_EC YYMMDD10.; DATESENT_EC = INPUT (DATESENTEC, YYMMDD10.); DROP DATESENTEC; RENAME DATESENT_EC=DATESENTEC; FORMAT DATESENT_GT YYMMDD10.; DATESENT_GT = INPUT (DATESENTGT, YYMMDD10.); DROP DATESENTGT; RENAME DATESENT_GT=DATESENTGT; FORMAT DATESENT_CLIN YYMMDD10.; DATESENT_CLIN = INPUT (DATESENTCLIN, YYMMDD10.); DROP DATESENTCLIN; RENAME DATESENT_CLIN=DATESENTCLIN; FORMAT DATEALTCDC_PGM YYMMDD10.; DATEALTCDC_PGM = INPUT (DATEALTCDCPGM, YYMMDD10.); DROP DATEALTCDCPGM; RENAME DATEALTCDC_PGM=DATEALTCDCPGM; FORMAT DATEALTCDC_LAB YYMMDD10.; DATEALTCDC_LAB = INPUT (DATEALTCDCLAB, YYMMDD10.); DROP DATEALTCDCLAB; RENAME DATEALTCDC_LAB=DATEALTCDCLAB; FORMAT DATESENT_ARLN YYMMDD10.; DATESENT_ARLN = INPUT (DATESENTARLN, YYMMDD10.); DROP DATESENTARLN; RENAME DATESENT_ARLN=DATESENTARLN; FORMAT DATESENT_CDC YYMMDD10.; DATESENT_CDC = INPUT (DATESENTCDC, YYMMDD10.); DROP DATESENTCDC; RENAME DATESENT_CDC=DATESENTCDC; RUN;

Dhana18 · ‎02-06-2019

I do have other variables with prefix cs_. So this might not work.

Dhana18 · ‎02-06-2019

i need to specify length on these variables. I am doing it this long way. DATA SUBMTWO.Casedata29_E; LENGTH var85 CS_DEMO_AGE 3.; LENGTH CS_PTR_INV_M 3.; LENGTH CS_PTR_INV_F 3.; LENGTH CS_PTR_INV_T 3.; LENGTH CS_PTR_MAIN_INV 3.; LENGTH CS_PTR_ANYM_INV 3.; LENGTH CS_PTR_CAS_INV 3.; LENGTH CS_GRP_SEX 3.; LENGTH CS_GRP_SEX_SIZE 3.; LENGTH CS_STDTEST_INV 3.; LENGTH CS_UNNAMED 3.; LENGTH CS_UN_MAIN 3.; LENGTH CS_UN_ANONY 3.; LENGTH CS_UN_CASU 3.; LENGTH CS_UN_SOC 3.; LENGTH CS_UN_RACE 3.; LENGTH CS_UN_HISPANIC 3.; LENGTH CS_UN_OLDER 3.; LENGTH CS_UN_YOUNGER 3.; LENGTH CS_UN_MULTISEX 3.; LENGTH CS_UN_GCCT 3.; LENGTH CS_UN_GCEXP 3.; SET SUBMTWO.Casedata29_D; RUN; Please tell me the efficient way to do it quickly.

Dhana18 · ‎01-29-2019

Hi Thank you for answering my question. I tried saving in CSV and used the import code but this is what happened. The output The log NOTE: SUBMTWO.CLINICDATAKA data set was successfully created. NOTE: The data set SUBMTWO.CLINICDATAKA has 3414 observations and 1 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.28 seconds cpu time 1.00 seconds

Dhana18 · ‎01-29-2019

Hi, I am importing an excel file with text variables but they changed to numeric after i imported into SAS. What did i do wrong? iused this Proc import datafile='L:\Bcdp_Std\EPI\DATA\SURRG\Copy of 2017_2018_SURRG_CaseData_Tables_From_Chris_01282019.xlsx' out=SUBMTWO.Casedata dbms=xlsx; GETNAMES=YES; run;

Dhana18 · ‎12-13-2018

Hi I am trying to convert character value to numeric used. this codes data datachek.mil_lab_2017_A; set datachek.MIL_LAB_2017; AZIMICDD = INPUT(AZI_MIC_DD, BEST8.); DROP AZI_MIC_DD; RENAME AZIMICDD=AZI_MIC_DD; RUN; log did not show any error 51 data datachek.mil_lab_2017_A; 52 set datachek.MIL_LAB_2017; 56 AZIMICDD = INPUT(AZI_MIC_DD, BEST8.); 57 DROP AZI_MIC_DD; 58 RENAME AZIMICDD=AZI_MIC_DD; 59 RUN; NOTE: There were 2406 observations read from the data set DATACHEK.MIL_LAB_2017. NOTE: The data set DATACHEK.MIL_LAB_2017_A has 2406 observations and 30 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds but the converted data has . value no numbers. Can some tell me why and how can i fix this. Also can I convert from character to numeric and change the length of the variable at once? I would be so grateful of your help? I have several variables value that need to be converted from character to numeric, how can i do it once?

Dhana18 · ‎11-02-2018

I did not get any note.

Dhana18 · ‎11-02-2018

I am trying to convert a numeric variable eg 123654 to character. i used this code data CDCDATA.Finaldata_CDC_ptid; set CDCDATA.Finaldata_CDC; patientid = put(cl_patientid,8.); run; th slog says; /*Reformating numeric Patient ID to Character format*/ data CDCDATA.Finaldata_CDC_ptid; set CDCDATA.Finaldata_CDC; patientid = put(cl_patientid,8.); run; the variable did not change to character. What is wrong with my code?

Dhana18 · ‎10-12-2018

Thank you Reeza. Yes I figured that out. I think it was because treat dataset was csv files and visit was an excel. The csv file was saved in excel and imported as visit dataset, and when I imported treatment date was not numeric and so I converted that into numeric and into date format then it worked just fine.

Online Status	Offline
Date Last Visited	‎08-16-2021 12:28 PM

Re: count

what is wrong with this code

Re: count

count

Re: How to calculate relative Risk and confidence Interval

How to calculate relative Risk and confidence Interval

Re: how do I get value form a event row to event row where value is mi...

how do I get value form a event row to event row where value is missin...

Re: How do i find days betten first and second and second and third ep...

Re: How do i find days between first and second and second and third e...

Re: Here are the values in thsoe tow vars

Re: Merging

Re: Modifying variable value

Re: Modifying variable value

Re: Modifying variable value

Re: Modifying variable value

Re: Modifying variable value

Modifying variable value

converting multiple character date into numeric

Re: Re coding multiple variables with three categories at once

Re coding multiple variables with three categories at once

Re: Importing an Excel spreadsheet into SAS.

Importing an Excel spreadsheet into SAS.

converting character value to numeric

Re: Converting numeric to character

Converting numeric to character

Re: merging