Search results for query: *

Hi, I'm writing a macro that needs to use various different random seeds for different invocations of a subroutine, but I only want to enter one as an argument in the main macro. I have some code, but I'm not sure if it's working. Here's what the code looks like: %macro test1(seed)...

I don't know if this is your problem, but try setting up your %let statement as follows: %let=%STR(1243.txt);

Hi Chris, thanks for the input. If I didn't have missing values that I wanted to tabulate as well, then your solution would be the ticket. However, I have a work-around that uses sql that might be of interest to others, involving: 1.change missing value code to -1 in original file. (I was...

Hello again, I'm having some problems creating a cross-tabulated frequency table for variables (cesdg242 and mhspec2) with dichotomous values (0 or 1) and two class variables, (ethnic and random). I've been trying to use proc tabulate, because although these values are easy to determine 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...

Thanks a lot for your help! JL

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...

I want to use access reports to create flashcards with an english word on one side and a spanish word on the other. I have a table with corresponding english and spanish words. I have a report set up with 3 columns, where each entry in the column corresponds to a particular spanish word. It...

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){...