About Norman21

Norman21 · ‎10-03-2017

"How can I retrieve my data? " Restore from backup. You do have a backup, don't you ...?

Norman21 · ‎10-01-2017

It looks like the WHERE approach (your second example) is best, according to section B in this document: http://www.phusewiki.org/docs/2010/2010%20PAPERS/CC03%20Paper.pdf

Norman21 · ‎10-01-2017

Try the BODYTITLE_AUX option in the ODS RTF statement. If this gives you the sort of result you are after, you will then have to deal with the page number. One way to do this is described here: http://analytics.ncsu.edu/sesug/2009/RV010.Haworth.pdf

Norman21 · ‎10-01-2017

The following might help you find an answer: "Count the distinct values of a variable" http://support.sas.com/kb/36/898.html

Norman21 · ‎09-30-2017

Actually, the program written by pchen002 could be described as one-to-one reading: "One-to-one reading combines observations from two or more SAS data sets by creating observations that contain all of the variables from each contributing data set. Observations are combined based on their relative position in each data set, that is, the first observation in one data set with the first in the other, and so on. The DATA step stops after it has read the last observation from the smallest data set." http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p15jvywi5avt3cn1bee8r6c33ux1.htm&docsetVersion=9.4&locale=en

Norman21 · ‎09-30-2017

There is a spelling mistake in the second line of code: define statgraph mypraphs.pie;

Norman21 · ‎09-30-2017

Some things you might like to try have been discussed here: https://communities.sas.com/t5/General-SAS-Programming/ERROR-Physical-file-does-not-exist/td-p/112009

Norman21 · ‎09-30-2017

One way to look at this: The values in the first data set are "replaced" by the values in the second data set (if they exist). So, all the VarX in the first data set have been replaced by all the VarX in the second data set. All the VarY have made it to the end, as there are no VarY in the second data set. Similarly, the VarZ appear in the final data set, as there is nothing to replace them.

Norman21 · ‎09-30-2017

Missing + 100 + 0 = 100 If you move your IF statement further down, the answer will be 200.

Norman21 · ‎09-29-2017

What procedure are you using? PROC SCORE? PROC LOGISTIC? PROC TPSPLINE? PROC PLM? Do you have some code that you can share?

Norman21 · ‎09-24-2017

What code have you written? Where do you need help?

Norman21 · ‎09-21-2017

I get errors in the log when I run your code, but output in results viewer. Have you checked your log to make sure the program is running as it should?

Norman21 · ‎10-30-2016

Hi, I have a file containing responses to a questionnaire, and want to assign the values of some of the variables to new variables, so that I can make use of a macro (more details here: https://medicine.umich.edu/dept/urology/research/epic). Everything works well, except that the new variables don't inherit the labels from the old variables, which is slightly annoying. Is there a way to make this work? Just to spell it out: attrib SC_EPICB_EPICBQ1 length=$2 label='1. Rectal Urgency'; ... EPICBQ1 = SC_EPICB_EPICBQ1 ; ... q42 = input(EPICBQ1, 1.); ...

Norman21 · ‎10-09-2016

With simple linear regression, by default the "Parameter Estimates" table contains the estimates of and together with the t statistics and the corresponding p-values for testing whether each parameter is significantly different from zero. http://support.sas.com/documentation/cdl//en/statug/68162/HTML/default/viewer.htm#statug_reg_gettingstarted01.htm

Norman21 · ‎10-09-2016

When I do this, I prepare a SAS file where each row corresponds to the row that you want to see in the final output. This file of pre-processed data is read into PROC REPORT. To make the file, you might need to use the output from PROC MEAN or PROC FREQ, then "assemble" the text in a DATA step.

Online Status	Offline
Date Last Visited	‎04-25-2025 04:45 AM

Re: Wide PROC REPORT and Page Numbering

Re: Import data from Excel file that contains rows with merged cells

Re: Import data from Excel file that contains rows with merged cells

Re: Import data from Excel file that contains rows with merged cells

Re: Import data from Excel file that contains rows with merged cells

Re: How to create a new column in Proc Report?

Re: How to create a new column in Proc Report?

Re: Rename variable in proc summary

Re: ods excel - row_heights and page break height

Re: How to remove variables in a Data set that contain a certain perce...

Your Toolbox for Unsupervised Machine Learning in SAS Viya

Generating Synthetic Data Using Generative Adversarial Networks

AI Generated Synthetic Data in Healthcare

Re: how to pad character variable with leading zeroes?

Re: adding leading zeros and changing to string

Re: How to create a new column in Proc Report?

Re: Four Histograms on One Page

Re: How to conduct the Two-way ANOVA study when the data was non-norma...

Re: How to calculated the sample size for three groups (or >2 groups) ...

Re: PROC EXPORT * MS-Excel \ SHEET TAB NAME "&" - Wanted: ICD9 & HCC

Re: my tables (with all data) appear corrupted following installation ...

Re: Deleting rows in a SAS large datasets

Re: Proc Report

Re: Count unique variables associated with one firm

Re: interleaving

Re: ERROR: Unable to restore <Template> from template store!

Re: Import Excel file into SAS

Re: interleaving

Re: if-then

Re: When scoring data, can I not only score the probability, but also ...

Re: Need help writing code

Re: Confidence interval for a relative risk in a 2x2 table - using PRO...

Can a variable inherit attributes?

Re: Regression Analysis

Re: ODS for the clinical trial report (Appendix 16.2.5 and 16.2.6)

SAS Analytics Explorers