About ANKH1

ANKH1 · ‎02-02-2023

Hi, I´m trying to display three variables, two are type character and one is numeric. I get the following warning for var3 which type is numeric and format is YESNO. proc report data= test; column var1 var2 var3; define var1 / display "Group"; define var2 / display "Number"; define var3 / display "Checked"; run, I run it and I get this warning: var3 is not in report definition

ANKH1 · ‎11-15-2022

It worked! Thank you so much! This is extremely helpful.

ANKH1 · ‎11-15-2022

Thanks for your reply. I added the word OF as advised and I am getting this error in the log:

ANKH1 · ‎11-14-2022

This is the code: data want; set have; where cmiss(var1 -- zvariable) <5; run; Where zvaribale is a character variable. I get this error in the log: ERROR: WHERE clause operator requires numeric values.

ANKH1 · ‎11-14-2022

This is very helpful. I would want to include character variables as well. But "where" with cmiss() is not working for character variables.

ANKH1 · ‎11-14-2022

I want to merge multiple datasets based on matching ids in one them. See image:

ANKH1 · ‎11-14-2022

Thanks! I had to list all variables like the first option you gave. And when I ran it, I realized that in the middle of the range there is a character variable. Say yname3 is a character and not numeric. How will you handle that?

ANKH1 · ‎11-14-2022

Yes, missing all values from var 1 to 4.

ANKH1 · ‎11-14-2022

Thank you. It didn't work. I forgot the add that the variable names can have different names. For example the names are var1 xvar2 yname3 zvariable. These are all numeric variables.

ANKH1 · ‎11-14-2022

Hi, I want to delete rows that have missing values for a list of consecutive variables. For example, from a the a dataset like: id cat var1 var2 var3 var4 stop 42 a 1 0 0 1 Y 43 b . . . . Y 44 a 1 . 0 1 N 45 b 0 . . 1 Y I want to delete row 43 which is missing data from var1 to var 4. Thank you!

ANKH1 · ‎10-31-2022

Thanks! The link is not working for some reason.

ANKH1 · ‎10-30-2022

Thank you! I used the first solution you mentioned.

ANKH1 · ‎10-25-2022

Hi, I would like to merge more than two datasets using PROC SQL. I want to merge them by ID (all datasets have this variable in common). These datasets (around 10) all have different number of columns. I've only found a way to join two datasets (example below). PROC SQL; SELECT A.*, B.* FROM STATES AS A, CITYS AS B WHERE A.ID=B.ID;

ANKH1 · ‎07-12-2021

Thank you so much!

ANKH1 · ‎07-09-2021

Thank you very much for your response and explanation. I was wondering if the random intercept model can also be applied to proc glimmix when the study design is the same?

Online Status	Offline
Date Last Visited	‎09-28-2025 09:47 AM

Re: What do when referencing a macro variable which value is 0?

What do when referencing a macro variable which value is 0?

Re: Using proc report how can you generate a pdf with repeated columns...

Re: Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 ...

Using proc report how can you generate a pdf with repeated columns and...

Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 by I...

Re: Median and confidence intervals missing when using proc lifetest

Re: Median and confidence intervals missing when using proc lifetest

Re: Median and confidence intervals missing when using proc lifetest

Re: Combine multiple columns into one

Re: Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 ...

Re: Median and confidence intervals missing when using proc lifetest

Re: Filter data by multiple variables

Re: porc phreg output interpretation

Re: porc phreg output interpretation

PROC REPORT Warning: variable is not in report definition

Re: How to delete rows with all missing numbers from a range of variab...

Re: How to delete rows with all missing numbers from a range of variab...

Re: How to delete rows with all missing numbers from a range of variab...

Re: How to delete rows with all missing numbers from a range of variab...

Merging multiple datasets by including only ids that match with one of...

Re: How to delete rows with all missing numbers from a range of variab...

Re: How to delete rows with all missing numbers from a range of variab...

Re: How to delete rows with all missing numbers from a range of variab...

How to delete rows with all missing numbers from a range of variables

Re: Use PROC SQL to merge more than two datasets by one common variabl...

Re: Use PROC SQL to merge more than two datasets by one common variabl...

Use PROC SQL to merge more than two datasets by one common variable

Re: Analyzing a two way anova with proc mixed

Re: Analyzing a two way anova with proc mixed