About Fersal

RW9 · ‎04-11-2016

Hi, Yes, but my question is, what are these different variables, where do they come from, why do you not know what they are upfront? It sounds like the process has broken further up the chain and now your trying to patch it together again.

Reeza · ‎03-29-2016

Trace your code: Line1 - set macrovar to var3 Line2 - set macrovar to var6 Line3 - set macrovar to var8 Macro variable resolves to var8 -> you've erased the previous values in each iteration. You need to create multiple macro variables or use SQL to select them all into one macro variable. I recommend the SQL solution: proc sql; select variables into :var_list separated by " "; quit; %put &var_list;

Reeza · ‎03-29-2016

I thought it was 0 cells that caused the issue, not 1's?

Fersal · ‎03-28-2016

Thanks, even with my bad explanation of the issue, you were able to understand the essence what I wanted to do, finally I got to combine the datasets using ":" and using some conditional statements, I tried with the append procedure but it doesn't work since the structure of some datasets were not exactly the same (eg. length of some variables).

Online Status	Offline
Date Last Visited	‎07-06-2018 11:39 AM

Re: rename variables automatically before merge datasets

Re: rename variables automatically before merge datasets

Re: rename variables automatically before merge datasets

rename variables automatically before merge datasets

Using values from a dataset as macro variables

Re: dropping data with low freq

Re: dropping data with low freq

dropping data with low freq

Re: Combining data set into a macro

Combining data set into a macro

Re: rename variables automatically before merge datasets

Re: rename variables automatically before merge datasets

Re: Using values from a dataset as macro variables

Re: dropping data with low freq

Re: Combining data set into a macro