Hi I need to create a dataset with a variable "datetimestamp" from march 2011 to may 2011.   So the format I need is...   variable name= datetimestamp timestamp format = 01MAR11:00:00:00 ~ 31MAY11:11:59:59   I think this should be pretty simple to do, but I'm stuck.,,,   Any help would be greatly appreciated! Thanks SAS pros in advance!   Chloe ... View more

I want to make a graph showing the effect of both wind speed and wind direction on black carbon concentration - so basically x axis = wind speed y axis = wind direction, and the more red the higher BC concentration etc...   I think I can use proc gam or proc loess.. but not to sure how to code it   Thanks in advance! ... View more

I have posted this question before.. but need a bit more help with it.   I have two large datasets - 1. air concentration data, which includes datetimestamp and air concentrations 2. flight acitivity data, which includes datetimestamp, flight ID, latitude, longitude, altitude.   I need to merge these 2 datasets by datetimestamp, but have to do it for each flight ID.   For example, if I have 1000 time points in air concentration dataset, I need to merge it with flight ID=1 for all 1000 time points, and need to keep all the missings as well. In other words, if the flight activity data only has 500 time points, the outputted dataset should still have 1000 time points after merging.    In the end, I want just one large merged dataset including all flight IDs. In other words, if I have 100 flight IDs in the dataset, and have 1000 time points, then I want my final dataset to have 100,000 observations.    Can anyone help me with this -- not sure if I should use macro vs. array vs. hash table either...   Any help will be much much appreciated!!!     ... View more