I have 2 differentsas dataset. A and B. I am trying to get data from dataset A to dataset B as below proc sql ; create table c as select a.11, a.13, a.14 from A,B where A.1=B.1 and A.2=B.2 and A.3=B.3; quit; Now I am getting empty dataset C. I am sure I have values comman for 1,2 and 3 for A and B . I check formatting and length in both dataset are same. Not sure why not getting records.
... View more
here is dataset no x y z year 1 a 2010 1 b 2010 1 c 2010 1 a 2011 1 b 2011 1 c 2011 2 a 2009 2 b 2009 2 c 2009 How to convert it in below manner no x y z year 1 a b c 2010 1 a b c 2011 2 a b c 2009
... View more
i have dataset as below no x y z date month year 1 a 05/02/2012 5/12 2012 1 b 07/02/2012 07/12 2012 1 a 03/02/2012 3/12 2012 1 a 04/04/2012 04/12 2012 1 a 05/02/2011 5/12 2011 now i want to convert in following way no x y z year 1 b a a 2012 1 a 2011 what logic need to apply here? as i have to keep most recent record as per date for year for client no and need to keep most recent values for x y z.
... View more
Hi I have 2 dataset for example Table 1 a 1 b 2 c 3 Table 2 a 1 b 1 c 1 a 2 b 2 c 2 a 3 b 3 c 3 how can I seperate non matching records from table-2?
... View more
THANKS FOR THE HELP BUT LOOK LIKE THE DATASET TO BEGEN WITH IS CURREPT AND I NEED TO WORK ON THAT DETAILS FIRST TO START WITH ,,,,,AS SO SORRY FOR TROUBLE,,,,,,AND THANKS FOR THE REPLY AND SUGGESTION,,,,
... View more
here i want to merge 2 dataset but with common varibale with matching values record only,,,,,and during this combination ,,I do not want to apply values to missing values for compared columns and want to retain values and apply missing value where value is not available.
... View more
here period indicates continuation,,,,not missing serial no,,,, and i think concept is right but ,,,,union all can not be use as columns in both data set is not same ,,, and not able to get result through it,,
... View more
As i mention i am creating dataset from 2 dataset using serial no as common variable and only values common in both dataset based on serial no will be kept . so i can not use set satement .
... View more
As in result dataset i do not want to modify missing data for start date and end date values as i want to keep both as per timeline and if value do not exit for that perticular month for any of them I want to keep it same way
... View more
Here for example, one dataset is serial no start date 101 jan2008 101 feb2008 101 march 2008 . . . . 102 feb 2007 102 march2007 102 april2007 . . . secon dataset is serial no end date 101 july2007 101 aug2007 101 sept2007 . . . 102 may 2008 102 june 2008 102 july2008 . . . How can I get dataset like bellow from above 2 datasets by using common variable serial no serial no start date end date 101 . july2007 101 . aug2007 101 . sept2007 . . . 101 jan2008 . 101 feb 2008 . 101 march . . . . 102 feb2007 . 102 mar2007 . 102 april2007 . . . . 102 . may2008 102 . june2008 102 . july2008 . . .
... View more
