About Banke

Banke · ‎10-05-2021

the variables in the two dataset i have created have similar names, so if i use merge command in my datastep, one will overwrite the other, do i have to rename the observations? they both have count and percentage of frequency count in common as variable names. do i also have to create a common variable like ID number to merge them ? thanks

Banke · ‎10-05-2021

Hello everyone, I have observed that my proc print does not show in my result output and my log doesnt show errors. i dont even know where to look for it. I didnt use to have this issue. can someone please help with this? this is an example of my syntax PROC PRINT DATA = WEEK6.PRINC_DIAG_CODE (OBS = 5); RUN; my log: PROC PRINT DATA = WEEK6.PRINC_DIAG_CODE (OBS = 5); 115 RUN; NOTE: There were 5 observations read from the data set WEEK6.PRINC_DIAG_CODE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds

Banke · ‎10-05-2021

Thank you so much, I wanted to do it all in one step.

Banke · ‎10-05-2021

Hello, i was asked to print obervations with 5 highest frequencies from a big dataset. i did this to order the frequency in descending order. PROC FREQ DATA = WEEK6.THCICSAMP ORDER = FREQ; TABLES ADMITTING_DIAG PRINC_DIAG_CODE; RUN; but i want to print , so i tried to create a new data set with only my frequencies for the 2 variables, sort by decreasing frequencies and use proc print : PROC FREQ DATA = WEEK6.THCICSAMP STACKODSOUTPUT NOPRINT; TABLES ADMITTING_DIAG PRINC_DIAG_CODE /OUT = WEEK6.FREQDIAG; RUN; i noticed that the new data set week6.freqdiaq i created has only one of the variable, PRINC_DIAG_CODE. how can i get all my variables out into the new dataset please?

Banke · ‎10-04-2021

It worked, thank you

Banke · ‎10-04-2021

Thanks, i do not know how to go about it. t hats why i dont have a data step, i dont know about proc sql yet, can you please explain to me:?

Banke · ‎10-04-2021

Thank you. Can you please show me the syntax? is it something like PROC FREQ DATA = WEEK6.THCICS; TABLES PROVIDER_NAME; OUTPUT OUT = MEANS MIN MAX; RUN; ?

Banke · ‎10-04-2021

Hello everyone, please i have to following dataset. The THCIC_ID variable is the unique ID of each hospital in PROVIDER_NAME variable column. Each observation per hospital is the inidividual patient that was admitted in that hospital. e.g austin state hospital, the first hospital, have 8 admissions. I am asked to provide the mean number of admissions across all hospitals. do i have to create a count ? i dont know how to go about it. There are 361 hospitals and over 9000 observations in the dataset. Thank you data set

Banke · ‎09-25-2021

It has worked! i added OPTIONS FMTSEARCH = (TCR.FORMATS); before the IF statement so it could locate the format. Thanks so much

Banke · ‎09-24-2021

Thanks a lot. when i used this: IF PSITE in ('C340', 'C341', 'C342', 'C343', 'C348', 'C349'); i got lots of error in my log DATA TCR.LUNG; 20 SET TCR.tx_ltd_use_9518_feb21; 21 IF PSITE = IN ('C340', 'C341', 'C342', 'C343', 'C348', 'C349'); 22 RUN; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 21:4 NOTE: Invalid numeric data, PSite='C447' , at line 21 column 4. is it because i did not convert to numeric variable? for your second suggestion, i was able to create the format but when i tried the second step, i got this: DATA TCR.LUNG; 48 SET TCR.tx_ltd_use_9518_feb21; 49 IF put(PSITE,$mygroups.) = 'Lung Cancer'; ---------- 48 ERROR 48-59: The format $MYGROUPS was not found or could not be loaded. 50 RUN; i dont know of any tables with such groupings identified or how to get the tables.

Banke · ‎09-24-2021

Hi everyone, I am working on a medical database. I will like to keep only selected observations from the dataset. How do i go about it please, expecially when it is a character variable? For instance, i want to select only patients with lung cancer from a list of all cancer types. The codes for lung cancer is C340 C341 C342 C343 C348 C349. I tried the following but it did not work: DATA TCR.LUNG; SET TCR.tx_ltd_use_9518_feb21; IF PSITE = 'C340' 'C341' 'C342' 'C343' 'C348' 'C349'; RUN; my log reads: DATA TCR.LUNG; 12 SET TCR.tx_ltd_use_9518_feb21; 13 IF PSITE = 'C340' 'C341' 'C342' 'C343' 'C348' 'C349'; ------ 388 200 ERROR 388-185: Expecting an arithmetic operator. ERROR 200-322: The symbol is not recognized and will be ignored. 14 RUN; RUN; thank you

Banke · ‎09-10-2021

ok. thank you. i uploaded the wrong picture, sorry about that. It actually created all the categories i wanted, i scanned through the dataset. i just observed that it grouped the categories into 2 instead of 5 in the frequency table whereas there are 5 categories in the created dataset. what does the "CHECKME" mean please?

Banke · ‎09-10-2021

Hello all, i want to create a frequencyt table for my newly categorized variables. there is no error in log but when i run the proc freq , it doesnt show all the categories i created for the first variable which is race. it showed just 2 instead of 5 here is my syntax DATA MEPSIS.RACEDU; SET MEPSIS.TEMP5; IF RACE = 1 THEN RACECAT = 'HISPANIC'; IF RACE = 2 THEN RACECAT = 'NON-HISPANIC WHITE ONLY'; IF RACE = 3 THEN RACECAT = 'NON-HISPANIC BLACK ONLY'; IF RACE = 4 THEN RACECAT = 'NON-HISPANIC ASIAN ONLY'; IF RACE = 5 THEN RACECAT = 'NON-HISPANIC OTHER RACE OR MULTI-RACE'; IF RACE < 1 THEN DELETE; IF EDUCATION = 1 THEN EDUCAT = '=<8TH GRADE'; IF EDUCATION = 2 THEN EDUCAT = '9TH TO 12TH GRADE'; IF EDUCATION = 13 THEN EDUCAT = 'GED OR HIGH SCHOOL DIPLOMA'; IF EDUCATION = 14 THEN EDUCAT = '>HIGH SCHOOL BUT WITHOUT 4 YEAR DEGREE'; IF EDUCATION = 15 THEN EDUCAT = 'COLLEGE OR BACHELORS DEGREE'; IF EDUCATION = 16 THEN EDUCAT = 'GRADUATE OR PROFESSIONAL DEGREE'; IF EDUCATION < 1 THEN DELETE; RUN; /** PRINTING TO CHECK**/ PROC PRINT DATA = MEPSIS.RACEDU (OBS = 5); VAR RACECAT EDUCAT; TITLE "CROSSCHECKING QUESTION 4"; RUN;

Banke · ‎09-08-2021

thanks. here is what i did i had initially converted recoded race and sex which had values of 0 and 1 in the original file into 'white and black' and male and female'/ i then noticed they showed as numeric variable when i ran the proc content. i then wanted to convert them into character variables using DATA BIOSTAT.KEEP7; SET BIOSTAT.KEEP2; SEX = PUT (SEX, BEST5.); RACE = PUT (RACE, BEST5.); RUN; it worked but showed up as rnew variables (race_character and sex_character in my file biostat.keep7) and the coding was the original 0 and 1 as shown in the first picture (blakc and white, male and female). i then wanted to convert back to the formatted style of black and white, male and female using the following syntax DATA BIOSTAT.KEEP10; SET BIOSTAT.KEEP7; OPTIONS FMTSEARCH= (BIOSTAT.FORMATS); FORMAT $SEX_CHARACTER $SEX_A. $RACE_CHARACTER $RACE_A.; RUN; $SEX_CHARACTER and $RACE_CHARACTER . are the new variable creater after conversion to character $SEX_A and $RACE_A are the formats i created (white and black, male and female)

Banke · ‎09-08-2021

thanks. I want to use chi square to find association between BMI and sex, race and age at the univariate level. Because race and sex are qualitative in nature, i thought i should convert them tom categorical variables. for my descriptive stats, will SAS run a bar chart with a numerical value?

Online Status	Offline
Date Last Visited	‎04-08-2024 09:45 PM

How to create a variable corresponding to the observations of a level ...

Re: creating a cummulative variable based on dates

creating a cummulative variable based on dates

Re: calculating mean dose taken for the first 6 months of therapy

calculating mean dose taken for the first 6 months of therapy

Re: computing age in years from SAS dates

computing age in years from SAS dates

Re: identifying diseases before a particular date

Re: identifying diseases before a particular date

identifying diseases before a particular date

Re: Checking Multicollinearity in Logistic Regression model

Re: Checking Multicollinearity in Logistic Regression model

Re: proc sgpanel define min and max values for x-axis

Re: fit panels from PROC SGPANEL

Re: How to create a variable corresponding to the observations of a le...

Re: Using macros to import ssp file

Re: outputing more than one variable in proc freq

my PROC PRINT is not showing in result output

Re: outputing more than one variable in proc freq

outputing more than one variable in proc freq

Re: How to obtain mean values for the observations in a dataset

Re: How to obtain mean values for the observations in a dataset

Re: How to obtain mean values for the observations in a dataset

How to obtain mean values for the observations in a dataset

Re: Keeping observations you need

Re: Keeping observations you need

Keeping observations you need

Re: My frequency table is not showing all variable categories

My frequency table is not showing all variable categories

Re: I see blank spaces when i convert from numeric to character

Re: I see blank spaces when i convert from numeric to character