Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. janelange

    help with macro debugging

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

    Macro Advice

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

    proc freq or proc tabulate for cross-tab table

    ...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_...
  4. janelange

    proc freq or proc tabulate for cross-tab table

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

    SQL code for frequencies of all variables in table

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

    SQL code for frequencies of all variables in table

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

    SQL code for frequencies of all variables in table

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

    SQL code for frequencies of all variables in table

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

    proc frequency output

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

    proc frequency output

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

    SQL code for frequencies of all variables in table

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

    SQL code for frequencies of all variables in table

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

    Selecting variables by label status

    Thanks a lot for your help! JL
  14. janelange

    Selecting variables by label status

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

    "saving" textarea content so it appears on page refresh

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

    "saving" textarea content so it appears on page refresh

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

    making "flashcards" via an access report

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

    making "flashcards" via an access report

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

    updating form field in popup from parent window SOMETIMES works

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

    updating form field in popup from parent window SOMETIMES works

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

Part and Inventory Search

Back
Top