Hi SAS Forum, I wanted to pull the records from my warehouse table that are satisfying below criteria: C_Code = 123 or S_CODE IN ('WANT','NEED') S_IND = 'N' OPEN_DATE >= 01MAR2013 This is the code I attempted but doesn't seem pulling correct records that satisfy our conditions above. proc sql;    create table k as      select                 ,ACCT_NUM                 ,OPEN_DATE                 ,C_Code                 ,S_CODE                 ,S_IND            from warehouse_table                       where  C_Code IN (123) OR S_CODE IN ('WANT','NEED') and S_IND IN ('N') and oPEN_DATE >= '01MAR2013'd; quit; Q: Could some one help me to correct the logic or suggest an alternative code? Thanks Mirisage ... View more

Hi SAS Forum, /*Hi SAS Forum, I have this data set. It shows the postal codes of each account. But the postal_code field has a mix of values. Some are correct, some are strange, some are wrong. */ data have; input account_number postal_code $ 6-12; cards; 1111 T2H 1B5 2222 T9E 6C8 3333 01000 4444 1097C7 5555 123 7777 A0A 1K0 9999 J0N 1G3 8888 11654-2011 1234 T9W 3H2 ; run; /* I wanted to create a new variable called "Validation" with following rules. If a postal code start with T, and it has 6 chractoers, and first charactoer is a letter, second is a numeric, third is a letter, fourth is a space, fifth is a numeric, sixth is a letter, 7th is a numeric then validation = 'correct' If a postal code starts with a letter which is not T, and all the other conditions above are satisfied, then validation = 'wrong' Else validation ='strange' */ /*For clarity, I have indicated below the values of variable "Validation" in front of each record*/ data have; input account_number postal_code $ 6-12 validation; cards; 1111 T2H 1B5      /*correct*/ 2222 T9E 6C8      /*correct*/ 3333 01000        /*strange*/ 4444 1097C7       /*strange*/ 5555 123          /*strange*/ 7777 A0A 1K0      /*wrong*/ 9999 J0N 1G3      /*wrong*/ 8888 T1654-2011   /*strange*/ 1234 T9W 3H2      /*correct*/   ; run; Q: Could someone help me how to do this. Thanks for your time. Miris ... View more

Hi SAS Forum, I took the attahced two data sets from "SUGI 27 Paper 70-27 An Introduction to SAS PROC SQL by Harrington, T. J. (Acknowledged thankfully). I first ran the proc SQL inner join with "inner join" phrase. Then ran without "inner join" phrase. Then compared the two output files using "proc compare". Results show both produced identical results. Question: For the given small two data sets, both appraoches produced identical results with "inner join" phrase or without it. Can I however generalize this conclusion for other situaitions invovling large data sets? Thanks Mirisage ... View more

Hi SAS Forum; Could you please help me on this layman question. I ran the below code for my large data set to see how many records are there. Proc contents data=huge_data_set varnum; run; The output table generated has a dot in front of the "number of observations" and it does not show the real number of observations in the data set. Q:Why Proc contents doesn't provide the "number of observations" ? Thanks for your time Mirisage ... View more