The final table I try to produce is a piece of a bigger decision making picture and its not really related to frequency. All we care about is weight that each unique value has in the variable column. We have mixed data in the table and instead of picking continuous variables by hand I just want to just go for it. This code will have to run through out the night anyway. The final table then is told to keep only 1000 obs. I made this SAS script previously but it was quite manual as I had to write 600 %let statements and then call those 600 %let multiple times. Therefore the goal here is to make it work automatically. Take all the variables that exist in any dataset we use and produce the table I need. ... View more

I am not an experienced SAS user, I know what the final result should look like and I build a road map of steps on how can I get there. My code that I have written so far is how my brain works. Im sure there are plenty of solutions to get to the desired result, but I guess this is something that will come with experience. And yes, my code does not pull another variable to do the calculation. I tried your suggested line %let var=%scan(&variables_to_run, &i, %str()); but there seem to be a mistake somewhere as it still calculates the first var in the list. ... View more

This actually worked, and finally got some results.    Could this be rearrange differently? Currently I have  Variable Variable value Frequency var1 A 1 var1 B 1 var1 C 1.5 var2 A 1 var2 B 2 var3 C 3 var3 D 1   There are many continuous variables with many unique values and I am worried that since this have to be exported to Excel to share with managers etc, I will hit Excel limits in terms of rows. Would it be possible to rearrange the table to look like below? Var1 var1_measure var2 var2_measure var3 var3_measure A 1 A 1 C 3 B 1 B 2 D 1 C 1.5           Thanks, J ... View more

Hello,   Thanks for this, this looks very advanced. I tried your solution, but it doesn't work and I can not fix it because I don't really understand it.   After whole day of research and testing, I finally ended up somewhere (but there's still a long way to go at this pace).   First of all I run proc contents  to get the variable names:   proc contents data=have1 noprint out=col_name (keep=name); run;   I then run the following statement to put those vars in some kind of macro i guess?    Proc sql; select * into :vars_to_run from col_name; quit;   And finally i get to the stage where I could calculate proc freq for every var in the dataset   %macro test; %do i=1 %to %sysfunc(countw(&variables_to_run)); proc freq data=have1; tables var_name / norow nocol nopercent nocum missing out=var_name; weight measurevar; %end; run; %mend; %test; var_name - system should automatically select all available variables in the dataset   I just need to find a way of telling SAS to run this for every var in the dataset and output as a separate dataset with var_name as a table name.   Thanks, J   ... View more

in this case I am using same measuring variable to measure varname1, varname2 etc. If i dont change measurevar into ex_varname1, ex_varname2, in later stages when I want to stick everything into one big table later on, I would end up with same var name (the measurevar). ... View more

Hi, I edited my code to have measurevar instead of exposure. Hopefully makes more sense now. Thanks ... View more

Thanks everyone for your responds.    So currently I have:   proc summary data=datatouse nway; class varname1; var measurevar; output out=varname1 (drop=_FREQ_ _TYPE_ rename=(measurevar=ex_varname1)) sum=; run; the reason im using proc summary instead of proc freq is so i could use exposure as a measuring variable.      The idea later is to have one excel sheet with all variables which would allow for quick search later on. varname1 ex_varname1 varname2 ex_varname2 unique_val1 100 unique_val1 200 unique_val2 150 unique_val2 150 missing 200 missing 100   I would usually write a macro for this and call a macro for each variable, but when there are 600 variables its hard to understand what is happening in the SAS file itself.   I want SAS automatically perform summary to every variable in the dataset without specifically naming it, so i do need to find a way  to change varname1 to varname2 etc.   I will later need to take all these var names and stick it into one big table. Hence I was thinking about something similar to python lists, as I will need var names in later stages.   Thanks, J   P.S. sas eg 8.1   ... View more

I will have to export this into Excel worksheet later on, so no report needed at this stage ... View more

It says its 47kb size. I dont have any control of the latest updates etc. Thanks, just turned. ... View more