About VDD

VDD · ‎08-31-2019

Excel does funny stuff to your numbers. are you sure those results are correct that Excel provides. Did you use a calculator, to confirm both results?

VDD · ‎08-31-2019

Works for me, please try again.

VDD · ‎08-29-2019

@crawfe are there always 2 records for each calculation? if so then the solutions provided work. If not then the solutions provided may give unexpected results if your data is like this. data have; input Name$ Var$ Value; cards; Name1 Var1 4 Name1 Var2 2 Name1 Var3 1 Name2 Var1 8 Name2 Var2 2 Name3 Var1 4 Name3 var2 5 ;

VDD · ‎08-21-2019

looks like this output out=main.out p=pvar r=rvar; may need to be something like this output out=main_out p=pvar r=rvar;

VDD · ‎08-21-2019

without seeing your code it is a best guess. I would say you are applying a format to the column that contains a date value. create a new column that contains the string value that represents the day of the week and use that new column in your report.

VDD · ‎08-17-2019

try weekday x=weekday('16mar97'd); put x; here is a link to SAS date formats http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm

VDD · ‎08-16-2019

you have to fix the record that doesn't meet you constrants. ic create Low_ck = check(where=(Low is not missing)) message = "Low price must not missing" msgtype = user; you data has 1 record with missing low price.

VDD · ‎08-16-2019

or have a title statment ods html file='E:\class.html' ; title "Demographic"; proc report data=sashelp.class nowd; column name (sex age height) ; run;

VDD · ‎08-16-2019

ods escapechar='^' ; title '^demographic^details' ; title2 'my second title line' proc report data=sashelp.class nowd; column name sex age height; run;

VDD · ‎08-16-2019

this paper will tell you how to span columns and such that will suppress and or remove the empty cell you want to remove. https://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf

VDD · ‎08-16-2019

change this column name ('demgraphic' sex age height) ; to this column name (sex age height) ;

VDD · ‎08-14-2019

@1477979 have a rounding issue where using best32. may not be the best format for your large numbers. This link may have a format the fits your needs. http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001263753.htm

VDD · ‎08-11-2019

data have; input num x1 x2 x3; datalines; 1 . . . 2 . . . 3 . . . ; run; data want; set have; array x{*} $ x1-x3; do i=1 to 3; x[i] = num*i; if i = 3 then output; end; run;

VDD · ‎08-11-2019

@alexgouv please don't post the same question more that once. you spam the community when you double post. https://communities.sas.com/t5/Administration-and-Deployment/SAS-on-iPad/m-p/580413

VDD · ‎08-11-2019

colaxis label='label' min=1 max=100 grid values=(1 to 60 by 5);

Re: Holidays

Re: Holidays

Holidays

Re: valid varnames

valid varnames

SAS on Demand

Re: if you have NA in all character variables then you should delete ...

Re: available options to create dummy ID??

Re: Issue using MOD incorrectly and holding data records for correct d...

Re: Need assistance with SAS array’s summing within the by group only

Re: How to run different groups of data steps based on distinct criter...

Re: Lopping for categorize the variable

Re: mixing up data

Re: Append a string to a macro variable for name of output data set.

Re: How to take hour and minutes of the current time into macro variab...

Re: Reading multiple .sas7bdat files from folder and select only requi...

Re: Reading multiple .sas7bdat files from folder and select only requi...

Re: Filepath not found?

Re: How to speed up a program ?

Re: Difference between NODUPKEY and NODUPRECS?

Re: Different means between PROC MEANS and EXCEL

Re: SASStudio not loading

Re: Difference between row values within multiple groups

Re: Sas Viya Libname

Re: Day of Week shows up weird in report!

Re: Multiple conditions

Re: integrity constraints to an existing data set

Re: how to keep variable in single box

Re: how write 2 titles with single statement

Re: how to keep variable in single box

Re: how to keep variable in single box

Re: Convert large number

Re: accessing variable names through loop

Re: SAS on iPad

Re: proc sgapenel / how to eliminate empty space before 0 on the x-axi...