About Andygray

Andygray · ‎05-07-2018

@jenim514 You could mark the question as answered and close the thread

Andygray · ‎04-16-2018

http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0vxokxhv8lr84n10nrbnzp7gnba.htm&docsetVersion=9.4&locale=en The documentation above explains what index does Did it work. If yes, you could mark the question as answered and accepted to close the thread.

Andygray · ‎03-29-2018

Thank you everybody for your responses. @ballardw You are a star!!!!!!!!!

Andygray · ‎03-29-2018

How to use a proc box plot procedure to create a box plot for one variable where the syntax seems to require group variable in the plot statement besides the analysis variable? PLOT Statement PLOT (analysis-variables)*group-variable <(block-variables )> <=symbol-variable> </ options > ; I only want to see the spread for the variable height in the dataset sashelp.class

Andygray · ‎03-28-2018

@Astounding has already proposed "SameDay" in INTNX to @novinosrin solution. @ybz12003's 1st requirement is 1. Change the ProduceDate from Character to Date format as MMDDYYYY probably means his/her real data has a character date

Andygray · ‎10-07-2017

@desireatem I think it is unethical to mark your own answers as correct after seeking help on the forum and having got couple of suggestions. That's poor sport and so unprofessional.

Andygray · ‎09-30-2017

@pchen002 Although this is a open technical forum, Kindly do not consider this as school homework forum or education forum. The spirit of the discussions should be kept interesting for everybody, which means both the original poster as well as for responders. The questions that you post will add really no value to many if not all.

Andygray · ‎09-11-2017

@skibur I think your question has been answered. Please close the thread. It's way too simple question

Andygray · ‎08-12-2015

My understanding is Dictionary.tables and sashelp.vtable are the same. Am i right? If yes, I am using sashelp.vtable to retrieve certain information about the metadata. However, I am confused having seen two kinds of variables in the sashelp.vtable dataset. One has a name "Number of logical Observations" and the other with the name "Number of Physical Observations". 1. What is the difference between the two? 2. Which one is actually denotes the count of observations?

Andygray · ‎07-08-2015

Hi, I am finding it difficult to understand "how and when" the while or until expression is evaluated or checked in a iterative do loop statement. The documentation says something the optional while or until only evaluates when the index variable value happens to be the last item or something like that and in another google search I found either the index or the expression whichever comes first. do index-variable= start to stop by increment while(expression) or until(expression); Can someone please clarify my understanding. Thanks

Andygray · ‎07-01-2015

Beautiful. That clears all my doubts in my brain. Thanks Tom!

Andygray · ‎07-01-2015

I am just trying to learn and understand by asking how the condition is checked with and without parentheses and how the results differ. Thanks

Andygray · ‎07-01-2015

Hi, I would like to know what is the correct way to write or in other words use AND OR NOT operators in SAS? Let's us suppose we have 3 variables with names A B C in a dataset /*which way of syntax is correct*?*/ if missing(a) or missing(b) and missing(c) then..... is this correct? or if (missing(a) or missing(b)) and missing(c) then......is is correct, meaning with the parenthesis? another condition: if missing(a) and missing(b) and missing(c) then......is this correct? or if (missing(a) and missing(b)) and missing(c) then...is is correct, meaning with the parenthesis? Please clarify the need for parenthesis. Thanks

Andygray · ‎06-26-2015

Sorry and Thank you I will do that. I really do appreciate your high levels of tolerance and still willing to help. I will have a word with the business "what a valid address is" and get a RegEx and come back to you if you don't mind. Besides, to check email is it similar as you demonstrated for address using prxmatch?

Andygray · ‎06-25-2015

I need to run these rules against a SAS data set. Basically, like a quality check before the data loaded into database but no data quality server or anything. We have just base 9.3. Also, I have received the corrective action to include '+' for phone numbers. Can you help? Sample Data: Address Email Values: test.username@gmail.com 4HAWTHORNEWAY 47 SHUTTLE MEADOW AV 621 S 27TH AVENUE 5539 W. JACKSON BLVD 13011 SW 82ND ST 1770 TIGERTALE AVE 43857 VICKSBURG CT.

Online Status	Offline
Date Last Visited	‎03-29-2019 08:23 PM

Re: Return count of 0 in a Group By SQL Statement

Re: taking out dashes from ID

Re: Custom Date Format

Re: Use value of one variable to directly refer another variable

Re: Use value of one variable to directly refer another variable

Re: Need help with the sas code for specifying all numerical variables

Re: how to generate sequence number in sql

Re: data step read calculated value of row in next row

Re: Merging to files

Re: Merging to files

Re: Update

Re: Grouping dates

Re: Substract date variable which is in character

Re: AND OR NOT expressions logical way of writing correction please?

Re: SAS Interview problems

Re: Need help with the sas code for specifying all numerical variables

Re: Merging to files

Re: i am new to sas i have a data set with 5 variables i need the outp...

Re: Data Transformation SAS Help: from Rows to Columns

Please explain DSD and DLM=',' differences?

Re: extract string that varies in length and number of delimiters

Re: assign 1 to the variable Spacec when the value for country contain...

Re: How to create a box plot for univariate?

How to create a box plot for univariate?

Re: Date Calculation?

Re: To return the maximun

Re: if-then

Re: Rearranging a Character Strings Into alphabetical order

Dictionary tables variable information ?

Do loop iterative statement expression evaluation?

Re: AND OR NOT expressions logical way of writing correction please?

Re: AND OR NOT expressions logical way of writing correction please?

AND OR NOT expressions logical way of writing correction please?

Re: How to identify special characters in a character string?

Re: How to identify special characters in a character string?