Thank you!
Yes, I have three variables ( ID, Status, Mod_date). the status contains obs (1, 2, 3). I am trying to find the number IDs missing status 1 but have status 2 and 3.
... View more
Hello,
I am trying to use the Where Statement in a proc freq to select specific subject but, my program is not working. please see the program below.
I am trying to find individ with no missing mod_date but missing status=1 but not missing status=2
proc frq data=temp;
where not(missing(mod_date))and missing(status=1) and status=2;
run;
... View more
Thank you! it worked. What if we want to compare more than one variable? For example, ID and start date? How would you modify the above code ?
... View more
I have three different datasets and I am trying to find same ID from the three datasets. I have used proc compare but, when using proc compare, you can only compare two datasets at a time. I was wondering if there is another way to compare the three data at the same time?
... View more
Hello,
I have a dataset formatted in mmddyy10. but when I run the data, it keeps on telling me its in a character format even though it looks like in numeric format. How can I fix this?
When I open the dataset this is what it looks like.
Data
03/20/1997
.
04/21/2002
05/7/2019
... View more
ID
COL1
CoL2
COL3
COL4
1
04/03/2020
I got a table like this after using proc transpose to convert horizontal variable to vertical. I wanted to know how to rename the variables COL1 COL2 COL3 COL4 to one variable name ''Date".
Thanks,
... View more
How do you remove space between a footnote and a table from Proc Freq, Proc Print, and Proc Report output. I have tables created using this 3 Procs and there is like 2 space between the footnotes and the tables.
... View more
How do you increase the width of a table in proc print output
Number of Survey participants
to
Number of survey participants
I used
proc print data=have;
table survey record / style (column)=[width=Full];
but I keep on getting error.
... View more
what I used looks something like this:
ODS rtf file="";
proc freq......;
proc report .....;
proc report....;
Proc report....;
ODS rft file close;
I have 4 tables as an output because I wanted them to be printed in one file.
this is what automatically opens when i run the program. I t says: we're sorry, we cannt open the doc because we found a problem with its content. If you click details, its says the file is corrupted.
... View more
