Hi Mate,   I need help from you guys. Let me explain you my problem firtst. I have created a single variable dataset (All the observation of this dataset are variables for my other programming.). Now i need to use the observations in a sequence like 1st observation and 2nd observation will be considered as Macro variables "START" and "STOP" in another programe and once the macro finishes forst ittration then 2nd observation should be "START" and 3rd observation should be "STOP" variable. Like this, the entire observations need to be used as derived Macro variables in another programme.   Example: Dataset_1 obs Title 01 Name 02 age 03 sex 04 address 05 language   Programme:   %macro test (Start= , Stop= ); if var1= &START then Seq+1; if var1= &STOP then seq+1; if seq=1 or var1= &STOP; %mend test;   Please provide me a solution to use the observation of dataset_1 as macro variables in the above programe in the above specified sequence.   Thanks     ... View more

Hi all, i am facing a problem while importing data from excel 2010 in SAS Datasets. The data is present in different sheets and in each sheet headers are there till some rows i.e the original data starts from different rows in each sheet. i can import the data by specifying RANGE option. But without RANGE option i wanna import each sheet into a single dataset. i tried DATAROW option, FRISTOBS option but they didn't worked. Please help me in this. Thanks ... View more