topic Re: Modifying variable value in SAS Programming

Modifying variable value

Dhana18 — Wed, 13 Feb 2019 16:25:44 GMT

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?

Re: Modifying variable value

Reeza — Wed, 13 Feb 2019 16:33:56 GMT

Test your conditions individually and see which is not catching the record.

DATA SUBMTWO.Clinicdata29_1;
SET SUBMTWO.Clinicdata29;
IF CL_PATIENTID='50055' then flag1=1;
if visdate="11/27/2017" flag2=1;
RUN;

You should also show the output you did get from the PROC PRINT.

@Dhana18 wrote:

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?

Re: Modifying variable value

novinosrin — Wed, 13 Feb 2019 16:36:11 GMT

Modifying variable value

You wanted to modify the value (from blank to 1) in one of the records. This is how i coded. Visdate is a character variable.

Log shows no erreor.

I am unable to understand your question

EDITed:

Assumption

some leading/trailing banks?

If yes use strip

IF Strip(CL_PATIENTID)='50055' and strip(visdate)="11/27/2017" THEN TOC_VIS='1';

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 16:42:27 GMT

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;

-----

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.

Re: Modifying variable value

ballardw — Wed, 13 Feb 2019 16:45:54 GMT

@Dhana18 wrote:

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?

Check your data set. I bet you have now have a variable named toc_viss that only has one value of '1' and blank for the rest. This would likely be the rightmost column if you use the table viewer or the last column in a proc print output.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 16:48:50 GMT

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 😞

Re: Modifying variable value

Reeza — Wed, 13 Feb 2019 16:50:19 GMT

It's missing the THEN, add it to the second IF condition. And paste your whole log, including from the PROC PRINT, BallardW is likely correct in his answer.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 17:10:01 GMT

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.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 17:13:26 GMT

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

Re: Modifying variable value

Reeza — Wed, 13 Feb 2019 17:31:03 GMT

You'll notice that flag2 is never set.

Show a proc contents on your main data set, how you're specifying the date appears to be part of the issue.

And you've never shown your log including the PROC PRINT step. Include both of these in your next response please.

@Dhana18 wrote:
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.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 17:42:56 GMT

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.

Re: Modifying variable value

ballardw — Wed, 13 Feb 2019 18:05:45 GMT

@Dhana18 wrote:

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

Please post Code or log entries by copy from the editor or log and paste into a code box opened using the {I}. That will preserve code and error message formatting.

Example:

2297  data work.junk;
2298     set sashelp.class;
2299     if sex='F' flag=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, ^=,
              |, ||, ~=.

2300  run;

Now we can see the underscore characters under the word FLAG and that gives us the hint that the 'THEN' is missing when you want to assign the value.

Also when you pasted this bit:

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

There is no set statement. So there is nothing read. Your output for this data would have 1 record and 4 variables because there was not instruction to create more records and you only use the names of 4 variables.

When you show this output:

proc print data=SUBMTWO.Clinicdata29_1;
var flag1 flag2 cl_patientid TOC_VIS;
where cl_patientid="50055";
run;

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.

The Proc Print output shows that all of your TOC_VIS values are blank for the records where CL_Patientid is 50055.

Perhaps you need to Print VISDATE instead of TOC_VIS to check your data. That is the variable you are supposedly using to set the Flag2 variable.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 18:11:58 GMT

Reeza,

Proc contents here. I removed the other variables.

Alphabetic List of Variables and Attributes
#	Variable	Type	Len	Format	Informat	Label
1	CL_PATIENTID	Char	7	$7.00	$7.00	CL_PATIENTID
57	TOC_VIS	Char	1	$1.00	$1.00	TOC_VIS
4	VISDATE	Char	10	$10.00	$10.00	VISDATE

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 18:18:00 GMT

I used this datastep

DATA SUBMTWO.Clinicdata29_1;

SET SUBMTWO.Clinicdata29;

IF CL_PATIENTID='50055' then flag1=1;

if visdate='11/27/2017' then flag2=1;

RUN;

then used this proc print statement, and this is the output

Obs VISDATE CL_PATIENTID83910851203

2017/10/17	50055
2017/11/27	50055
2017/12/11	50055

Re: Modifying variable value

novinosrin — Wed, 13 Feb 2019 18:19:31 GMT

try this and let us know the results

DATA check;

SET SUBMTWO.Clinicdata29;

IF CL_PATIENTID='50055' or visdate='11/27/2017' then output;

RUN;

Lets do some tests

Re: Modifying variable value

Reeza — Wed, 13 Feb 2019 18:46:35 GMT

@Dhana18 wrote:

I used this datastep

DATA SUBMTWO.Clinicdata29_1;

SET SUBMTWO.Clinicdata29;

IF CL_PATIENTID='50055' then flag1=1;

if visdate='11/27/2017' then flag2=1;

RUN;

then used this proc print statement, and this is the output

Obs VISDATE CL_PATIENTID83910851203

2017/10/17 50055

2017/11/27 50055

2017/12/11 50055

Show the full log (including the proc print) and include the flags in the PROC PRINT. Without them, you can't see where the issue is coming from.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 18:48:33 GMT

OR does not work I need both conditions patient id and visit date. Thank you.

Re: Modifying variable value

Dhana18 — Wed, 13 Feb 2019 18:55:27 GMT

DATA SUBMTWO.Clinicdata29_1;

SET SUBMTWO.Clinicdata29;

IF CL_PATIENTID='50055' then flag1=1;

if visdate='11/27/2017' then flag2=1;

RUN;

12 DATA SUBMTWO.Clinicdata29_1;

13 SET SUBMTWO.Clinicdata29;

14 IF CL_PATIENTID='50055' then flag1=1;

15 if visdate='11/27/2017' then flag2=1;

16 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.10 seconds

cpu time 0.00 seconds

proc print data=SUBMTWO.Clinicdata29_1 ;

var flag1 flag2 CL_patientid toc_vis;

where cl_patientid="50055";

run;

25 proc print data=SUBMTWO.Clinicdata29_1 ;

26 var flag1 flag2 CL_patientid toc_vis;

27 where cl_patientid="50055";

28 run;

NOTE: There were 3 observations read from the data set SUBMTWO.CLINICDATA29_1.

WHERE cl_patientid='50055';

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

Re: Modifying variable value

novinosrin — Wed, 13 Feb 2019 19:04:38 GMT

The idea of OR was to see if there are records actually present in your data

Re: Modifying variable value

Reeza — Wed, 13 Feb 2019 20:18:54 GMT

Can you show the PROC PRINT results please as well?