Hello,   I have two tables:   Table1 Date Classifier Count 2017 A 2016 A 2017 B 2016 B   (Note, that the Count column is empty in Table1.)   Table2 Date Classifier Count 2017 A            100   I wanted to copy the Count value from Table2 into Table1, where Date and Classifier are matching, so that I get as an updated table: Updated Table1 Date Classifier Count 2017 A             100 2016 A 2017 B 2016 B   Therefore, I tried the following query:   PROC SQL; Update Table1 Set t1.Count = t2.Count FROM Table1 t1, Table2 t2 WHERE t1.Date = t2.Date ANDt1.Classifier = t2.Classifier: QUIT;   However, i only got a syntax error. How can I solve this? Thanks a lot!   ... View more

Hello,   I wanted to create a dataset called timestamps that lists the last day of each month of the preceding 6 months. My solution for this is: DATA timestamps; d = today(); format d date9.; DO i=0 TO 5; d = intnx('month',d,-i)-1; output; END; run;   However, I get this as result:   If I "rerun the loop manually", I get the day I expect. E.g. this code DATA timestamps; d = today(); format d date9.; d = intnx('month',d,-1)-1; run; gives: 31MAY2017   Why do I get 30APR2017 for i =1 in the loop? What is wrong in my loop? Thanks for the help! Kind regards, philip ... View more

I wanted to create a matrix with nested loops where elements have numeric values but also concatenated string values, however I get this error: "ERROR: (execution) Invalid argument to function."    I built a small example that expresses the problem: proc iml; /* data example */ pds = {0.3, 0.4, 0.8}; M = J(3,1,0); do i=1 to 3; M[i,1] = 'PD' + char(pds[i]); end; print M; quit; As I understand it: it is not possible to write a string to a matrix element?   Thank you for suggestions how to solve this! ... View more

I am trying to translate code from R into SAS. In R I can evaluate the normal quantile function on the [0,1] intervall. E.g. qnorm(1) [1] Inf However, if I do this in SAS with the following code y=QUANTILE("NORMAL", 1); I get an error message and the result is a missing value. (Note: between 0 and 1 the function works fine)   Is there a possibility to get Inf (.I) as a result (without manually capturing the cases)? ... View more