Hello team, I have a variable as date numeric as mm/did/yyyy. I want to use it in a where clause: where dob= 12/10/2021; SAS ignores it and returns other dates in the result, how can I fix this issue? Blueblue ... View more

Hello team, I have this: %If &syscc > 999 %then % do What does &syscc > 999 do/ mean?   I know &syscc is a read/ write automatic macro variable that enable us to reset the job condition code and to recover from conditions that prevent subsequent steps from running. Regards, blue & blue ... View more

Hello team, I have been given a code to dissect it and it has an array statement: what is the reason we use an array statement?   array mbrs(*) & mbr.;   Thanks, blue blue ... View more

Hello team, I have this: proc sql; select counts (*) into: avariableName from mytable; quit; Respectfully, blue & blue ... View more

Hello team why q is equal to 0. b = 'x=y'      trim(b) will be same, b doesn't have spaces that trim b takes that out!! data _null_; length a b $14; a='ABC.DEF (X=Y) '; b='X=Y'; q=index(a, b); w=index(a, trim(b)); put q= w=; run; q=0 and w=10 /*log shows it*/  thanks for the response. b&b  ... View more

Hello all, Year function return year as character, how to prevent this or how to convert it back to number? Thanks, b&b ... View more

Hello team, data mydata (keep = plan id orderenddate year month); set mydata1; year = year(orderenddate); month = month(oorderenddate); run; /*Year and months are not in dataset, I added them for the functions that I have use*/ data mydata2; set mydata1; where year =2022; run; where year = 2022 give errors. orderenddate is numeric data type which is formatted as a date in dataset: 2022-03-13. How can I overcome this error? Regards, b&b ... View more

Hello team, I have a date variable of numeric data type. I put this variable in a year function to get the year portion of the date. The result is 2022 as a character. Then I use this 2022 in a single quote in a where clause in a proc sql that groups the data, as soon as I put a.year = '2022', it returns 0 rows back.   proc sql; create table mytable as select a,*, b.id, b.event, b.year, b.codetype, count(a.event) from thattable a inner join thistable b on a.id=b.id where a.year ='2020' and b.codeType = 'hhhh' group by a.id, b.id, b.codetype,b.year; quit; Regards, blue & blue ... View more