About MerAgSo

Tom · ‎07-18-2022

@MerAgSo wrote: Sorry, the format is DDMMYY10. considering separators (/). I know this a date format but I want the numeric value given for SAS date value (The numeric value which counts days from January 1st, 1960). I need this in order to estimate several day differences among dates. It is the number of days already. To get the difference in days between two dates just subtract. days_since = date2 - date1 ; days_since_1960 = date ; days_since_2000 = date - '01JAN2000'd ;

Rick_SAS · ‎05-15-2022

Use ODS OUTPUT to create a data set that contains the statistics. Then use PROC PRINT to display the value in whatever format you want. For example, the following captures two output tables and uses the 20.16 format to print the numerical values of the statistics: data corregida; call streaminit(123); do i = 1 to 100; edad=rand("normal",0,1e-10); output; end; run; ods trace on; proc univariate data=corregida normaltest; var edad ; ods output Moments=Moments BasicMeasures=BM; run; proc print data=Moments; format nValue1 nValue2 20.16; run; proc print data=BM; format locValue VarValue 20.16; run;

Reeza · ‎08-25-2021

Set this option and reimport your data to avoid the issue entirely. options validvarname = v7; If you have this option set, when you import data SAS will automatically add the underscores to the variable names as necessary. @MerAgSo wrote: Hello everybody I have existing dataset covid which has space in variables name like below: numero expediente del paciente I tried renaming them assuming SAS would turn spaces into underscores but when I run the program it sends a warning that the variable does not exist in the dataset. I have run PROC CONTENTS and the variables are there, but the variable name appears without underscores. The original data came from an excel file but I changed it into SAS data. Here's the code: libname COVIDBD '/home/mercedesaguilars0/sasuser.v94/SASMer'; data base; set covidbd.covid; run; NOTE: There were 398 observations read from the data set COVIDBD.COVID. NOTE: The data set WORK.BASE has 398 observations and 199 variables. data base2; set base (rename=(numero_expediente_del_paciente=numexp)); run; Variable numero_expediente_del_paciente is not on file WORK.BASE2 Thank you

MerAgSo · ‎01-25-2019

*Code* PROC GENMOD DATA= QUARTILESIMP; CLASS NEWQUART2(REF='0') SMOKE(REF='Never') SITIO(REF='Monterrey') IND(REF='0') / param=effect; MODEL LIMT= NEWQUART2 EDADM TOTMET08 SITIO SES2 SMOKE IND NEWQUART2*IND/ link=identity TYPE3; CONTRAST 'LRT' NEWQUART2*IND 1 1, NEWQUART2*IND 2 1, NEWQUART2*IND 3 1; RUN; TITLE; Log; NOTE: PROC GENMOD is modeling the probability that SCVD2='1'. NOTE: The Pearson chi-square and deviance are not computed since the AGGREGATE option is not specified. NOTE: Algorithm converged. NOTE: The scale parameter was held fixed. WARNING: Some rows of the L matrix for the CONTRAST statement LRT are linearly dependent. These rows will be ignored. NOTE: The PROCEDURE GENMOD printed pages 282-283. NOTE: PROCEDURE GENMOD used (Total process time): real time 0.12 seconds cpu time 0.13 seconds

StatDave · ‎09-13-2018

It's best to explicitly specify the reference level in the REF= option. Specify the value you want as the reference in quotes - for example, REF="MyRefLevel". Quotes should be used regardless of whether the variable or it's values are numeric or character. Also, if the variable has an associated format, you must specify it's formatted value rather than it's internal, unformatted value.

Reeza · ‎03-20-2018

Well, you likely destroyed your original data so you'll first need to recreate avg1. After you do that, please run the code (below) and post your log and explain what isn't working. data AVG2; set WORK.AVG1; IF LPLAQUE=1 OR RPLAQUE=1 OR PLAQUE=1 OR PLAQUE1=1 THEN TPLAQUE=1; ELSE IF LPLAQUE=0 OR RPLAQUE=0 OR PLAQUE=0 OR PLAQUE1=0 THEN TPLAQUE=0; RUN;

Reeza · ‎03-07-2018

If you really want table names like that you can add an N to the end, this is known as a name literal. proc sql; create table "AVG1"n as SELECT *, AVG(weight) AS AVG1 FROM sashelp.class; QUIT; I don't recommend doing that though, because then you have to type more (3 extra characters) per data set name and it makes it harder to use short cut references to data sets.

Online Status	Offline
Date Last Visited	‎07-19-2022 05:03 PM

Re: Date format to SAS date trouble

Re: Date format to SAS date trouble

Date format to SAS date trouble

PROC UNIVARIATE turns output in scientific notation

Renaming in data step not working

Re: PROC GENMOD Warning

PROC GENMOD Warning

Proc Logistic Class Statement Not Using Reference Variable

Creating a column with IF procedure

Re: User does not have appropiate authorization level for libary WC000...

Re: Date format to SAS date trouble

Re: PROC UNIVARIATE turns output in scientific notation

Re: Renaming in data step not working

Re: PROC GENMOD Warning

Re: Proc Logistic Class Statement Not Using Reference Variable

Re: Creating a column with IF procedure

Re: User does not have appropiate authorization level for libary WC000...