Search results for query: *

It works. Thank you very much!

I want to create a new F key(shortcut key)using F12 or AltF12 to do the following: copy a line, move selected line to the end of the line, and paste. This will save me time so that I do not have to highlight the line, click on copy, go to next line, click on paste. Once the line is pasted...

Thank you. I solved my problem. proc sql; create table Test1 as select *, case when confidentiality is null then Firstname else "." end as fname from TEST ; quit;

I want to blank out only some fields from a record, but do not know how. I tried case statements and if statements but am running into a wall. I would appreciate your help. For those records with a confidentiality code=X, I want to blank out the names, but want to leave the other fields...

Thank you very much. This is exactly what I wanted.

Sample of the SAS view table, I ranked the following: obs fruits response 1 apples 100 2 peaches 90 3 pears 90 4 grapes 85 5 nectarines 80 6 watermelon 80 7 catalope 75 8 strawberries60 9 managoes 60 10 bananas...

Hi, I created a table to rank the TOP 10 var1. Now I want to create a new primary variable for the Top 10 var1. Ideally I want to use the same numbering as seen in the SAS view table. Can you help? Thank you for your time. DonaZ

Chris, I am not understanding this. My file is the libaries/work/imported. How do I use this code? proc sql; create table cols as select name ,type ,length from dictionary.columns where memname='WORK' and libname='OLD' ; quit; Thank you for your time.

Hi Sometimes the variables that I import from Excel are character format and should be numeric format. Rather than run PROC CONTENTS DATA=test1 Each time I used the following: If year=2000 then do; if var1=’’ then var1=’.’ Var1_num=input (var1,4.); Drop var1; Rename var1_num=var1; Label...

Thank you alunbrain and Chris for your response. Have a good weekend. DonaZ

I'm sorry, my query is not working. What am I doing wrong? I meant to say that the field is currently a numeric that needs to be converted to a text. The field needs to accommodate the leading zeros.

This question is in reference to thread376-1455435 which is now a closed thread. This code worked before Data TABLEA; set Table2...

I just renewed the license with the new number. I want to know more about the optional items.

I renewed my current SAS 9.1.3 standalone; however, I noticed now Service Pack 4 is available and another disk---DISK 5. What did you do with the Service Pack 4? Should I install DISK 5? Suggestions? Please see list below. Has anyone used the Optional items on this list? If so, which...

Hi How do you select the top N records using Proc SQL in SAS? Thank you in advance for your time.

Thank you Chris.

I have the following fields: ID Level Invites Attends NoShows Region City I want totals of invites, attends, no shows by region and by city. I am having problems. This worked and returned the correct total: proc sql; create table DR2008TEST as select level, sum(invites) as invites...

Thank you everyone for all your responses! Have a good weekend.

I forgot to ask if there is a proc SQL version for this query. What would be faster? Once I total the fields, I want the overall of all the records. Example: Total number of Attendance, Total Number of fields with a positive variable (this number would be from adding up the number of fields...

Hi, I need help. I want to count all the fields on a record that have a value. I do not want to count the fields with a null value. I want to add up all the NonNull fields on a single record in one new column. Any ideas? Thank you for your time