Hi everyone,    im looking for an efficient way to replace values in a table in a SAS work.library. This data was imported from excel, and there are many variables in multiple columns that im looking to change. For example: in column1, column2, column3, I would like to replace their values from "somewhat negative" and "extremely negative" to simply "negative".   Any ideas?    thanks! ... View more

Hi everyone, I'm having some troubles regarding a procedure using Proc Freq.   I am creating tables based on survey questions that are organized by sex, and would like to combine some of the rows that have similar responses to create more general row labels.   For example: Question 1: rate your level of satisfaction with your current living arrangement A) Extremely Dissatisfied B) Dissatisfied C) Neutral D) Satisfied E) Somewhat Satisfied   I would like a table that combines responses from A and B to create one row being "dissatisfied", and do the same for responses D and E.   I have created my code using proc freq:   proc freq data = work.living; table '1-Rate your Satisfaction with y'n*'What is your gender?'n / nocum nocol norow; run;   all data is organize by gender of the respondent. any help is appreciated!   Thanks! ... View more

Hi,  in creating  report, I am trying to list the first and last names of individuals with a  count of surveys completed. In my report, one individual may be listed more than once, however proc report leaves a blank space (to represent a duplicated name). Is there any way to have the name printed again, instead of leaving  blank?   proc report data=ITr out=ITre(drop=_break_) nowd; column ID LName FName survey n; define ID/Group; define LName/Order 'Last'; define FName/Order 'First'; define survey/across 'surveys for 2018'; rbreak after / dol skip summarize ; compute after; ID='Total'; endcomp; run; ... View more

Hi everyone,    I am currently using Proc report to create a report consisting of numeric and character values.    At the moment, I am trying to suppress any cells that show "." representing an empty numeric cell. Is there any way to take these away using proc report?   thanks. ... View more

PROC IMPORT DBMS=ACCESSCS DATATABLE='RVDEC'     ... View more