I will look up Proc timeseries and proc expand.Thanks! ... View more

VarA1=lag1(var A); VarA2=lag2(var A); VarA3=lag3(var A); VarA4=lag4(var A); ... View more

Thank you for the insight BallardW! ... View more

Hi,    It seems like there was a problem in raw file, even though the common key of two datasets was converted to character, the length of that variable in raw file was different and due to that merge failed. even though the SAS codes were correct it was actually length of character variable that didn't help merge two datasets.   Thanks! ... View more

Before merging I can see all the data in two files that I am trying to merge. But after merge I don't understand why I am not getting data in output for some of the columns. ... View more

I want a and b but i thought maybe changing selection criteria might help in merge.Thanks! ... View more

I checked both Jan.summtrd09 and Jan.summdtc1 before merging there are no missing data there. please advise why the merge is not successful ... View more

if I run the code below : DATA Jan.masterdata11; MERGE Jan.summtrd09 (IN=A ) Jan.summdtc1 (IN=B ); BY DMA_1 week_nm ; IF A or B; RUN; then I can see all the columns in my dataset but then I have values missing in most of the columns. ... View more

let me try . ... View more

Now that i have tried another join in data merge I am getting an error. codes: DATA Jan.masterdata11; MERGE Jan.summtrd09 (IN=A ) Jan.summdtc1 (IN=B ); BY DMA_1 week_nm ; IF a or b then OUTPUT= Jan.masterdata11; RUN; log : 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 DATA Jan.masterdata11; 57 MERGE Jan.summtrd09 (IN=A ) 58 Jan.summdtc1 (IN=B ); 59 BY DMA_1 week_nm ; 60 IF a or b then OUTPUT= Jan.masterdata11; ________________ 557 ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. ERROR 557-185: Variable Jan is not an object. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds ... View more

Log isn't showing any error. I don't understand why the codes are running fine, the data step is even merging the columns but there is no data in the columns ... View more

The variables I changed are now of same length. ... View more

Now even though I changed the variable to character , I'm not able to merge, codes run fine but I am not getting anything in results section, no rows only columns are displayed in results window. What can be the reason of no rows but only columns in output? codes are below DATA jan.masterdata5; MERGE jan.summtrd09 (IN=A drop= _type_ _freq_ yr wk) Jan.summdtc1 (IN=B drop = _type_ _freq_ yr wk); BY DMA_1 week_nm ; IF A AND B THEN OUTPUT jan.masterdata5; RUN; ... View more

I tried it but SAS UE is forcing the variable to remain numeric, and I tried using SQL too when i do data merge it doesn't give me any rows but only columns ... View more