topic Re: Proc Print ID when flag=1 in SAS Programming

Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:35:22 GMT

Hi! I'm trying to find the unique identifiers that correspond to when the flag variable I made=1. I haven't been able to find a way to write a proc print of ID if flag=1? I basically want a list of the IDs when flag=1

Sample Data:

ID Flag

1 1

2 0

3 0

4 1

Enterprise Guide will not allow this:

proc print data=clean2;
where Flag=1;
run;

Re: Proc Print ID when flag=1

novinosrin — Tue, 12 Mar 2019 16:59:04 GMT

Are you seriously asking how to write a where statement in proc print?

data have;
input ID            Flag ;
cards;
1                1
2                0
3                0
4                1
;
proc print;
where flag=1;
run;

Re: Proc Print ID when flag=1

PeterClemmensen — Tue, 12 Mar 2019 17:11:58 GMT

proc print data=have;
   where flag=1;
run;

Re: Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:32:37 GMT

No. I'm asking because I only want the ID to print (there are a dozen other variables) and this code will not run:

proc print data=clean2;
var ID;
where flag=1;
run;

or even this code:

proc print data=clean2;
where flag=1;
run;

A 'where' statement is not compatible with the proc print command.

Re: Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:33:39 GMT

This is in Enterprise Guide, which may be why.

Re: Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:36:16 GMT

This code will not run in Enterprise Guide; not sure why?

Re: Proc Print ID when flag=1

PeterClemmensen — Tue, 12 Mar 2019 17:36:17 GMT

What does your log say?

Re: Proc Print ID when flag=1

Astounding — Tue, 12 Mar 2019 17:36:37 GMT

Both of these programs are perfectly fine, whether using EG or not. Here are some issues to look for.

Is FLAG actually a character variable? Then you would need to use:

where flag="1";

Does FLAG exist in CLEAN2 or was it created and then dropped?

Re: Proc Print ID when flag=1

andreas_lds — Tue, 12 Mar 2019 17:43:18 GMT

Look at the log! If you don't understand the log, post it here using the {i} icon to preserve formatting.

Re: Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:45:08 GMT

Thank you, I actually just realized that for the flag variable I was running there were no flags that=1, they were all =0, therefore there was no output.

Re: Proc Print ID when flag=1

jmmedina25 — Tue, 12 Mar 2019 17:47:10 GMT

Thanks, it wasn't working because there were no values of the flag variable that=1, they all =0. Still confused why the code was red but whatever.