Search results for query: *

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

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

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

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

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

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.

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

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

I have two tables--TableA and TableB. I want the records from TableA that does not match TableB. Below is my query. What am I doing wrong? proc sql; create table NewTable/*name*/ as select distinct a.id,a.* from /*table name*/TableA a left join TableB b on a.id=b.id where a.id <> b.id ; quit...

I cannot join the two tables because of the following problem: Table 1 Table 2 Code Code Description AA AA Blue 002 002 Red Do not care BB BB Purple 048 048 White 678...

I cannot join the two tables because of the following problem: Table 1 Table 2 Code Code 001 1 002 2 048 48 678 678 How do I remove the zero placeholders in Table 1? Any suggestions Thank you for your time.

I’m having a problem with missing values and columns. I want to create another column using the two existing columns – ed1 and ed2 to create ed3. This following does not work. Should I use . to represent a missing value? Can I create another column this way? What am I doing wrong? Thank you for...

I need help on quartiles. Where do I start? I have the mean. I need the 25% and 75% range. Thank you in advance for your time.

The two queries below work; however, is there a way to combine the two queries? proc sql; select term, count(id)as Applicants ,avg(GPA)as AvgGPA from SAMPLE where level="H" group by term; quit; proc sql; select term, count(id)as Admits, /*this gives you the Admit count*/ avg(gpa) as...