Hi, My SAS EG user id and password was created yesterday. But when I tried logging onto the SAS EG,it says, "the password has expired & must be changed". Is there anyway I can change the password. Or the SAS EG Adminstrator will change the password. ... View more

I have a dataset like this: data hello; input id var1 var2; datalines; 1 3 5 1 3 7 2 2 4 2 2 7 2 2 9 3 4 6 3 4 9 ; run; I want to output only one row where the difference beetween var1 and var2 is lowest for the particular id. Any help. ... View more

Is there any format to write the numeric variables with the +ve or -ve sign and with leading zeros e.g if its 3.5, it should be +0003.5 if its 23.6, it should be +0023.6 if its -23.6 it should be -0023.6 The Zw.d format is used to add leading zeros and it works for negative numeric values but how to assign the +ve sign before the positive numeric data. ... View more

I want to create a .CSV file from SAS dataset with ';' as the separator. I tried both the folloiwng options with all the delimiters, it works fine for all other delimiters except ";" data _null_; set sashelp.class; file "C:\temp\test1.csv" dsd dlm="," ; put name sex age; run; and PROC EXPORT DATA= work.saroj OUTFILE= "C:\temp\test1.csv" DBMS=CSV REPLACE; delimeter = '|'; RUN; My output should be the following with ; as the separator. Alfred;M;14 Alice;F;13 Barbara;F;13 Carol;F;14 Henry;M;14 But the above values are displayed in separate columns as Alfred M 14 Alice F 13 Barbara F 13 Carol F 14 Henry M 14 James M 12 Jane F 12 Janet F 15 Any help on this. ... View more

I have a mainframe file as in the example below: 123-4567890-12;2009-07-26;2009-07-26; 123-0987654-32;2010-08-30; 234-5678901-23;2009-03-31;2009-12-29 345-6789012-34;2009-05-20; 456-7890123-45;2010-03-20;2009-09-15 567-8901234-56;2009-09-11; ....... ....... I want to read it in DI Studio in UNIX but I am not getting the correct result. I am using the code as below. Can anyone help on this. data A; infile '" / "' lrecl = 256 firstobs = 1 missover RECFM = F; attrib ID length = $14 informat = $ebcdic14.; attrib DT1 length = $10 informat = $ebcdic10.; attrib DT2 length = $10 informat = $ebcdic10.; input @ 1 ID $ebcdic14. @ 16 DT1 $ebcdic10. @ 27 DT2 $ebcdic10.; run; ... View more

I have two datasets.I have to create an output dataset from these two with the condition that var2 of dataset1 should match the var2 of dataset2. Only concern is Var2 is $9 here and $32 in the second dataset. Example: var1 var2($9) ----------------------- 1 0000283 2 731823 3 1073388 4 12 varX var2($32) ----------------------- 1 000002837 2 000731828 3 001073388 4 000161499 How to get the result as : var1 varx ========== 3 3 I tried left, trim, input and put fuctions but i am getting absurd results. Thats becaue when I convert the character to numeric for comparasion purpose, the values wiht more than 8 characters are trimmed and so wrong matching ouptut is generate. Is there any way I can compare this two variable. Note : Size of both vairbles are $9 and $32 and the values in this are starting from 1 character to any. Thanks for your help... ... View more