About CathyVI

CathyVI · ‎05-08-2019

@Reeza, what i mean by didn't work is that i can't get percent, cum_percent & cum_freq by using proc tabulate and i wanted percent.

CathyVI · ‎05-08-2019

So I tried this for a 2 x 2 table but didn't work For example; proc tabulate data=med; class name; table blank*name*n=''*f=32.; run; ??? I am using proc freq to find 2x2 and 2x3 table so how will I use the proc tabulate without getting an exponent in my result ?

CathyVI · ‎05-06-2019

Hi, I ran a prof freq and I got my results but i am trying to remove the Exponent (E) from my result. Example; proc freq data = income; table amount; run; Result ; amount frequency Percent Cum_freq Cum_persent 0 42344E12 60.20 3454E54 100.00 1 44535E33 34.44 5675E44 60.00

CathyVI · ‎05-03-2019

My difficulty is understanding this sentence so as to write the code. Identify encounters that are missing medication data by: Setting Source Hospital Identifier To my knowledge, I interpreted it as identifying missing values by setting so I thought about using "if then/else. The variables are char variables. I feel I did not interpret the statement correctly. Help !! data drug; set Im.med; if encounter_id = " " then setting = " "; else if enconter_id = " " then setting = " "; run;

CathyVI · ‎04-30-2019

Okay your information is helpful. Moving forward, how would you interpret this task. It's one of the final steps i am asked to analyze but am having difficulty simplifying into sas or analytical term. Find; Sample Dataset (Medication Level/Including all available data fields) 50 RxNorm observations 50 observations representative of other sources

CathyVI · ‎04-30-2019

This data have over four million records with almost 90 variables.

CathyVI · ‎04-30-2019

Thank you Reeza, You are right the 'no label' is blank in the data. This is a very large data and its my first time working on large real data. All your recommendations are very helpful, please. Also, do you recommend subseting the data to only variables i will be working on to minimize error as well as processing-time for the sas machine.

CathyVI · ‎04-29-2019

Thank you for your help, I think you gave me a good lead into where i should start. As for your question on meaning of code and label, the label is the drug name while the drug code represent the event of activity taking place. See the following deliverables MEDICATION_CODE: The code representing the event or activity taking place, such as the code for ibuprofen. MEDICATION_NAME: The text name of the medication or immunization involved in the encounter. The text is the standard label of the codes where a code is present or the text provided by a custom extract when a code has not been provided.

CathyVI · ‎04-29-2019

Hello, I am asked to do both summary analysis and exploratory analysis on a data. I am new to sas but so eager to learn. I need some help understanding how to create codes and analyze for the following variables. Summary Analysis (Encounter Level) Number of encounters that have any medication data by: Setting Source Hospital Identifier Code Systems Verified Code systems Identify encounters that are missing medication data by: Setting Source Hospital Identifier Exploratory Analysis (Drug Level) Number of medications with codes Number of medications with labels Number of medication with codes but no labels Number of medications with labels but no codes Number of medications with codes and labels Number of medication with neither codes and labels

CathyVI · ‎04-29-2019

The data is a medication data and i think the desired output is to measure the ROA of each specific drugs e.g ROA in aspirin overdose. The phrase is vary in terms of how it is presented in the data, but overall it appear in more than one variable and more than once in a single variable. Thank you

CathyVI · ‎04-17-2019

Thanks!

CathyVI · ‎04-17-2019

Am asked to identify where the statements and the number of times "route of administration" is present in the dataset. I need help knowing how to this in sas Thank you.

CathyVI · ‎02-08-2019

Hi @Joshg19 I am planning to take the SAS 9.4 base exam. Please do you have any materials i can study and advice you can give. Thanks

CathyVI · ‎01-03-2019

I am having an issue with my code its not running and this is the result from my log; Code: {proc import datafile="C:\Users\Adewumi\Documents\EPG194\data\np_traffic.dat" dbms=dlm out=traffic2 replace; guessingrows=200; delimiter="|"; run;} log; {NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 400 proc import datafile= "C:\Users\Adewumi\Documents\EPG194\data\np_traffic.dat" 400! DBMS= dlm 401 out= traffic2 replace ; 402 guessingrows=3000; 403 delimiter= "|"; 404 run;} How do i fix this;

CathyVI · ‎01-03-2019

@ r_behata: Thanks

Online Status	Offline
Date Last Visited	‎10-16-2025 09:08 AM

Re: check if the content of a variable is in another variable

Re: check if the content of a variable is in another variable

check if the content of a variable is in another variable

Find the count using proc tabulate

Re: Creating subtotal in Proc report

Creating subtotal in Proc report

Re: Bold subheading in proc report

Re: Bold subheading in proc report

Bold subheading in proc report

Re: merging data sets using set statement

Re: check if the content of a variable is in another variable

Re: check if the content of a variable is in another variable

Re: check if the content of a variable is in another variable

Re: check if the content of a variable is in another variable

Re: Bold subheading in proc report

Using proc report

How do I analyze the effect of repeated dose

Proc freq with multiple variables

variable categorization

Identifing date of encounters

Re: Convert exponent to real values in proc freq

Re: Convert exponent to real values in proc freq

Convert exponent to real values in proc freq

understanding how to interpret the statement

Re: Data analysis on drug data

Re: Data analysis on drug data

Re: Data analysis on drug data

Re: Data analysis on drug data

Data analysis on drug data

Re: How to flag/identify a statment

Re: Base Programming exam 2nd try

How to flag/identify a statment

Re: Base Programming exam 2nd try

Challenge Practice: Importing Data with a Specific Delimiter

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

SAS Analytics Explorers