Hello All.. As i was going through in data step processing and testing some sample SAS programs to check the way of datastep processing. As i read in the SAS documentation .. " the variable values in the program data vector are re-set to missing.". But I am bit confused after looking the olg for bellow program ,the variable count value was retaining ,since i am not using RETAIN statement for that variable. here i am posting my code and log as well.. CODE:           Data test;           Put _all_;           Input ID fee Name $;           Count+1;           Put _all_;           Cards;           100 1500 Sanju           100 2000 kuridi           100 3000 kumar           102 4000 sri           102 5200 nath           103 9512 sree           ;           run; LOG: ID=100 fee=1500 Name=Sanju count=1 _ERROR_=0 _N_=1 ID=. fee=. Name=  count=1 _ERROR_=0 _N_=2 ID=100 fee=2000 Name=kuridi count=2 _ERROR_=0 _N_=2 ID=. fee=. Name=  count=2 _ERROR_=0 _N_=3 ID=100 fee=3000 Name=kumar count=3 _ERROR_=0 _N_=3 ID=. fee=. Name=  count=3 _ERROR_=0 _N_=4 ID=102 fee=4000 Name=sri count=4 _ERROR_=0 _N_=4 ID=. fee=. Name=  count=4 _ERROR_=0 _N_=5 ID=102 fee=5200 Name=nath count=5 _ERROR_=0 _N_=5 ID=. fee=. Name=  count=5 _ERROR_=0 _N_=6 ID=103 fee=9512 Name=sree count=6 _ERROR_=0 _N_=6 ID=. fee=. Name=  count=6 _ERROR_=0 _N_=7 Could any one explain me why Count variable still have some value when all other variables having missing values in the log. Seeking for experts explanation.. Thanks&Regards. Sanjeev.K ... View more

Hi.. My requirement sounds pretty simple  but i am finding some difficulties to resolve. I have two Datasets A and B. Dataset A:                         Dataset B: ID           Visit               ID          Amount 100           I                    100          2000 100          II                    100          2500 100          III                   100          3050 102          I                     102          4000 102          II                    102          2000 103          III                   103          7000 If i merge above two datasets using Megre statement in Datastep,the output coming exactly what  i want ,so no problems here. But if i merge (Join) these two datasets with using SQL  joins(Full Join),SQL  creating Mess due to nature of SQL language. My big question is how can we achieve the same output produced in dataset with joins?? could  you please guide me how to do.?? Regards. Sanjeev.K ... View more

Hello Everyone. I am getting little Confused while converting Numeric to Character Format. I am having Data Like.. Data Test; input ID Start Date9. End Date9. Amount; Format Start End Date9.; datalines; 1 01Jan2012 1Jan2013 5000 1 01Feb2012 1Jan2013 5000 . 01mar2012 1Jan2013 5000 0 01apr2012 1Jan2013 5000 ; run; Data h; set test; x=put(ID,8.); run; Above Code Working Perfectly but i am getting confused with 3rd observation in above data. Normally as per my knowledge Missing Values in Num variables shows As ' . ' and in Char values shows as Blank ' '. But in above Data Empty value in X(3rd OBs) showing as ' . ' Why this is behaving like this??? Regards. Sanjeev.K ... View more