Do you mean in SAS? If you have something like an ID that equals 9988 and is formatted as character, you can convert it to numeric with the INPUT function. ex: newID=input(ID,4.);
... View more
The code I gave you will export a text file that you can open in Notepad, or use the import wizard in Excel. If you want csv, you are correct but you'll have to change the extension in the OUTFILE statement to .csv.
... View more
Without seeing any of your data values, I would say export it as a text file if you don't have to have it in Excel. PROC EXPORT DATA = Work.Cr_values OUTFILE = "S:\shared\cmcgath\temp\productivity\Final 2014\CR_Values.txt" REPLACE DBMS = dlm; delimiter='09'x; Run;
... View more
Here's what I have now. It got rid of spaces and punctuation. username=schoolid||compress(compress(lowcase(substr(first,1,1))||lowcase(substr(middle,1,1))||lowcase(last),,'p'));
... View more
I have this: username=schoolid||lowcase(compress(substr(first,1,1),'s'))||lowcase(compress(last,'s')); I thought the 's' would eliminate spaces but it doesn't seem to. (I just realized I don't need it for first names.
... View more
I want a user name and password for each record. The data looks like so: schoolid last first middle studentid 5 Jagger Mick Ron 45678 Username for this record would 5mrjagger >>> schoolid || first initial || middle initial || lastname (all letters in lower case. some names have hyphens and apostrophes so I need those stripped out) Password for this record would mrj5678 >>> first initial || middle initial || last initial || last 4 digits of studentid (Some studentids are longer than 5 characters so I need to start at the end and count back 4 places. All studentids and schoolids are numeric) I want to make sure there are no leading or trailing spaces in the usernames and passwords. Thanks for any help you can provide.
... View more
this will get rid of records with duplicate POL_ID: proc sort data=mydata nodupkey; by POL_ID; run; CAUTION: this will get rid of records that have the same POL_ID even if the amounts are different. Is this what you want to happen?
... View more
Do you want to keep the vars in both data sets? I will assume you do. If you want only those observations where the ID is the same in both datasets: proc sql; create table join1 as select a.*, b.* from dataset1 as a inner join dataset2 as b on a.Uni_id=b.Uni_id quit: You will get a warning saying that Uni_id appears in both data sets and it will the value of Uni_id in dataset1
... View more
I looked at some of my recent rtf output. My title is actually a header. Could this be the issue with placing the cursor under the title?
... View more
Thanks. You actually touched on the real problem -- I need to learn more about using tagsets. I've done some reading on them but haven't gotten a handle on it. Any readings you can suggest would be greatly appreciated. Gregg
... View more
