About sdevenny

sdevenny · ‎04-26-2022

Hello, My data looks something like this: var1 var2 1 2 3 3 1 3 I need to keep only the data points that match, such as when var1 and var2 both have a value of 3, and I can get rid of the rest of the data. How could I do this?

sdevenny · ‎12-16-2020

You could do this: DATA new; SET old; FullName = LastNm || ',' || FirstNm; RUN;

sdevenny · ‎12-15-2020

The code worked for me, just make sure that you're checking the dropdown menu under output (if you are on Studio, not sure how this works for other versions). Or, you could include a PROC PRINT in the macro, and then it should print all 3 means as different tables.

sdevenny · ‎12-08-2020

Hello I know this is probably a simple fix, but I cannot get the program to work. I need to make a VBAR graph based off a table sort of like this. Data work.whatever; INFILE DATALINES DELIMITER = ','; INPUT StateCd :$8. ColPercent; DATALINES; Ohio,0.51 Delaware,0.0 Alaska,0.59 ; I need the graph to show StateCd as the x-axis and the values of ColPercent as the y-axis, but no matter how I try to code it, I always wind up with each bar showing the frequency (1) and not the value of the variable. How do I get the Ohio bar to show as 0.51 etc?

sdevenny · ‎11-27-2020

I've tried the WHERE statement, and got this in the log: ERROR: WHERE clause operator requires compatible variables.

sdevenny · ‎11-27-2020

I'm trying to create a table using specific variables from a dataset. The issue I'm having is that I need to use a certain subset of one specific variable and cannot figure out how. Here is a sample of the original dataset: DATA Study; INPUT SSN $11. WtLb BMI SBP CODCd $13.; DATALINES; 999-99-9999 150 22.7 176 Stroke 000-00-0000 130 26.5 160 Heart Failure ... ; For the table, I want to use only the values where CODCd is Heart Failure. Here is the code I already have, which essentially only formats the table: TITLE1 "Subjects Dead from Heart Failure"; PROC PRINT DATA = Study ID SSN; VAR WtLb BMI SBP; RUN; TITLE; How can I print only the observations where CODCd is Heart Failure? I'm not sure if it matters, but in the actual original dataset the variable CODCd is numeric.

sdevenny · ‎11-08-2020

Hello I am attempting to apply a new format to my data, but whenever I try and use the format, I get "Unexpected Value" in the output. However, when I change the format name by even one letter - adding one, deleting one, or changing one in the middle - I get the results I am looking for. This is a project for a class which requires a specific format name ($StateCd), otherwise I would accept the results as they are and not be as picky. I thought maybe the fact that it is the same name as the renamed variable, but even when I do not rename the variable, the format still does not work. If anyone has any input on why and how to fix it, I would really appreciate it! Code: PROC FORMAT; VALUE $StateCd ' ' = 'Unknown' 'Ohio' = 'OH' 'Delaware' = 'DE' 'Alaska' = 'AS' OTHER = 'Unexpected Value'; RUN; DATA WORK.Contact_Ohio; SET HypImpt.OhioResidents (RENAME= (Initials= Inits State=StateCd) ); KEEP SSN Inits City StateCd ZipCd; Inits = CATS( SUBSTR(Inits, 1, 1), SUBSTR(Inits, 3, 1), SUBSTR(Inits, 4, 1) ); RUN; PROC PRINT DATA = WORK.Contact_OH; FORMAT StateCd $StateCd.; RUN; There are no errors or warnings in the log. Thanks in advance

Online Status	Offline
Date Last Visited	‎05-01-2022 08:17 PM

How to keep data from two matching variables

Re: How do I turn a name into last,first from 2 variables of firstnm l...

Re: Multiple Macro Runs

Specifying a variable for the y axis in SGPLOT

Re: Printing only a few observations from a variable

Printing only a few observations from a variable

Applying a specific (user created) format name