hi there   how to I define in my where clause to get yesterdays date?   For example in SQL it would be 'where DateBought = (getdate() - 1)'   what would be the getdate() equivalent in SAS? ... View more

hi there   i pull data from a SQL environment into SAS. There is a date field in the table which changes to a 5 digit numeric value. How can I get the date to display as dd/mm/yyyy? ... View more

hi there   i am not sure whether to use group by or whether to use tabulate. Either way i'm not sure if those 2 are the correct options on how to do this: I want to count the number of claims per region and get the total of all regions as follows: Region   Number Pta         5 Jhb        6 Kzn        6 total        17 ... View more

hi there   i get the below error when trying to run my code Error 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, THEN, ^, ^=, | Syntax error, statement will be ignored code: proc sql; select reference, case when age >= 0 and age<= 10 then '0-10' when age>=11 and age<=20 then '11-20' end as AgeBucket ;quit;   ... View more