...not sure if it's working.
Here's what the code looks like:
%macro test1(seed);
%macro test2;
%some_macro(&seed);
%let seed =%eval(&seed+2);
*update random seed to new value for use in next invocation of "test2";
%mend test2;
%test2;
%test2;
%mend test2;
%test1(111);
*this should run...
...called count_cesdg242
3. use proc tabulate to make cross tab table with cesdg242 as a class variable and the count variable in the var list.
*converts missing values to -1;
data ypic_06_reg_missing(drop=i);
set month6.ypic06_reg;
array testmiss(*) _numeric_...
...Here's the code of what I have so far:
proc tabulate data=month6.ypic06_reg missing;
class ethnic random;
var cesdg242 mhspec2;
table ethnic*random,
cesdg242*(n mean nmiss) mhspec2*(n mean nmiss);
run;
However, rather than specifiy how many 0 and 1 responses there are for each variable in...
I just wanted to thank all of you for your helpful responses/advice. It turns out that SAS has a transpose utility that accomplishes something similar to the code you gave that collapses many columns into one, so now I have a dataset with 3 columns and 500,000+ entries. It's definitely useful...
Thanks for pointing out the articles--I'll definitely have a read.
I guess my point was that for data manipulation purposes in SAS (which is where I'm doing most of the data management), in which individual variables are used to create derived summary variables--a spreadsheet style structure...
That certainly makes sense, generally, although I inherited this dataset from someone else--and for data manipulation purposes, (summary scores and the like), it is more manageable to treat each of the answers as separate variables.
Thanks for your help.
Thanks for the suggestions!
Do you know if there's any way to adjust the maxium number of fields in a table in Access? (which would allow me to use your code)? Currently the dataset I'm working with has 1300+ fields (it's from a very long questionnaire) and there's no way to actually get the...
Thanks a lot for your help.
When I run the code example that you gave me and open up the output table, it looks something like this:
Table Name Name Freq etc....
Name Alice Alice 1
Name Bob Bob 1
Sex . . 5
Sex . . 9
Age . . 2
Age ...
Hi,
I have a huge dataset with about 1300 variables. I'd like to create a table that lists the information generated in a proc frequency statement for each of the variables in the dataset.
I know it's possible to generate output tables for individual variables, but what about one for all...
That definitely looks like it would work, but I'm trying to actually write this code to use with SAS (which I'm using because my table has too many variables to fit into Access), and am more comfortable with SQL than with SAS syntax, which seems to lack an easy way of exporting the information...
Hi,
I have a table with a large number of columns(>100) and want to use sql to calculate the frequency of particular responses for each column in the list (where these frequencies do not include the missing data in the category).
I know this shouldn't be too difficult, but would prefer to...
I'm fairly new to SAS (but have some programming experience), and have what I hope is a pretty basic question:
I have a dataset with hundreds of variables, some of which have labels, some of which don't. Is there anyway to sort the variables themselves on the basis of whether or not they are...
Thanks for the input.
I don't know if this is out of the scope of this forum, but do you think there might be a way to implement this using a combination of JS and PHP? I'm not sure I want to go with cookies.
Jane
Is it possible to store the value of a textarea (i.e. what's written in it) or other form elements so that they do not "disappear" if the page is refreshed?
Thanks,
Jane L.
Thanks, but I'm not sure how to set up the report
so that all three "cards" in an entry display unique words--
My tentative solution has been to use 3 columns to display the entries (using the page setup) which means I only have one field per entry and thus cannot shuffle them around as you...
...a report set up with 3 columns, where each entry in the column corresponds to a particular spanish word.
It seems reasonable to set up another *practically* identical report for the corresponding english words.
Here's the rub:
I want to print the corresponding words on the opposite side of...
Thanks...this works...
What if I want to load another value to this popup window that I've already opened, without reloading the popup?
I suppose I can use an onClick event like the one I wrote earlier, but I'll need to figure out how to determine if the popup window exists.
JL
Here's what I'm trying to do:
--Create a popup window from the main window.
--Populate a text input field in a form on the popup with a value passed from the main window.
Here's my function, which is called by an onClick event in the main document:
function defineSelectionLimit(input){...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.