Hi,   Im looking for a way to copy over SAS data sets from one location to another location and keep the original date//time stamp. Using proc copy or proc datasets will modify this time stamp with the date/time of execution.  I ould like to avoid this.   Thanks in advance! ... View more

Hi, I would like to create a daily report (.XLS) using  ODS Tagsets EXCELXP and have this report automatically uploaded to a cloud based storage area (Box). Has anyone got some experience with this? Thanks! ... View more

Hi, I want to create a dataset with information coming out of multiple datasets Let me try to explain with an example; Data ONE; infile cards; attrib COUNTRY length=$20 label='Country'; input country; cards; Belgium France Germany ; run; Data TWO; infile cards; attrib STOCK length=$20 label='Stock'; input country; cards; Stock1 Stock2 ; run; Data THREE; infile cards; attrib PRODUCT length=$20 label='Product'; input country; cards; Product1 Product2 ; Run; Now I want to create a dataset with all possible combinations of the above data set. This should look like this. COUNTRY STOCK PRODUCT --------------- ------------- ---------------- Belgium Stock1 Product1 Belgium Stock1 Product2 Belgium Stock2 Product1 Belgium Stock2 Product2 France Stock1 Product1 France Stock1 Product2 France Stock2 Product1 France Stock2 Product2 Germany Stock1 Product1 Germany Stock1 Product2 Germany Stock2 Product1 Germany Stock2 Product2 Not sure how to handle this. Any suggestions? Thanks. ... View more

Hi, Is there any way to retrieve the actual code of a compiled macro? ... View more

I want to create a variable where the name should contain the value of another variable. Example : A=1; Within 1 data step, I want to create variable "SCALE1" where 1 represents the value of variable A. Any suggestion is welcome ... View more

Hi, I'm looking for a simple solution to retrieve all variables from a data set which are empty for all observations. Anyone? ... View more