Hi, I have a dataset(name : new) which has 4 coloumns(c1 , c2 , c3 ,c4). c4 coloumn consists the name of the coloumns ( c2,c1,.......). please see example below: Dataset: New c1 c2 c3 c4 1 2 3 c2 1 3 5 c1 I did as follow: data a; set new; t1 = max(0,c1 - c4); run; Here I want C4 to be replaced with the value. Meaning in the first row , the value for c4 is c2 so I want value of c2(Value of C2 : 2) to be substituted and so on... Please help me . Thanks. ... View more

Hi , I have a requirement in which on daily basis, I have to find if a new record is added in the dataset and if it is added then I have to use that record for further process. Please let me know how can I find this through SAS code. Thanks, SASACC ... View more

Hi, I have a dataset which has one column which has a format ddmmyy . when I am trying to copy to oracle it is creating a problem. Please let me know to which format I should change this field so that oracle support. Please if with any example would be great. Thanks. ... View more

Hi, Please help me with this: FILENAME prep FTP LIST CD="/env/prod" HOST = "xxx.xx.xx" USER = "abcdef" PASS="{sas001}234567ljX3J1bg=="; DATA in_list_file; INFILE prep MISSOVER; FORMAT permission $10.; FORMAT code 3.; FORMAT owner $10.; FORMAT group $10.; FORMAT size 15.; FORMAT month $3.; FORMAT day 2.; FORMAT hour_year $5.; FORMAT file $60.; INFORMAT permission $10.; INFORMAT code 3.; INFORMAT owner $10.; INFORMAT group $10.; INFORMAT size 15.; INFORMAT month $3.; INFORMAT day 2.; INFORMAT hour_year $5.; INFORMAT file $60.; INPUT permission $ code owner $ group $ size month $ day hour_year $ file $ ; RUN; But now we want to remove the ftp path and make to run with out FTP so I changed as FILENAME prep LIST "/env/prod" ; But I got message as ERROR: Invalid file, "/env/prod". I have 3 .txt files (ABC, ABD, ABF) which has to taken into account. Please let me know how can I get list of all files in the location(/env/prod) so that I can use the below macro later to find out if input files are empty or not. %MACRO CheckEmptyFile; PROC SQL NOPRINT; SELECT count(*) INTO :nn_obs FROM in_list_file WHERE file LIKE '%AB%' AND size = 0; QUIT; %PUT *** &nn_obs ***; %IF &nn_obs > 0 %THEN %MailScript(Some SO input files are empty !!!); %MEND CheckEmptyFile; Please let me know how can I get list of all files in filename so that I can use the above macro . Thanks for the help. ... View more

Hi , Please help me in coding below logic: Read the dataset and if dataset contains any numeric column then convert that column into character column. Ex: Dataset has two columns A and B. A numeric 8 ; B character 1 ; so here Column A should become character column with length 256. Please note that we dont have fixed columns meaning dataset is created in a seprate program which doest have fixed columns. Many Thanks for your help. ... View more

Hi, I want to create a script which can load any excel sheet. For example: I have First excel in which I have 10 coloumns and second excel has 20 coloumns which are completey different from other. And so on.... Please let me know if there is any easy method to do through Program. Thanks for the help. ... View more

Hi, When I am importing CSV file into SAS , Junk value is getting inserted in last coloumn of every record. Please let me know if there is any option which remove junk values while importing. I am using Infile statement with following Options dlm=';' TRUNCOVER MISSOVER DSD FIRSTOBS=2 Thanks ... View more

Hi, I copied a file from Oracle to SAS. There is a date field in the data set which is a numeric field with format and informat 23. I tried checking like '01OCT2009'D but this doest work. Please let me know if there is any way to convert this field into sas date. ... View more

Hi, I have two datasets namely A and B. A has 400 columns in which only column number 18 is not filled(Blank). B has 400 columns in which only column number 18 and Key (column 1) is filled and remaining all are missing(numeric) or blank(Char) based on the data type. Now I want new dataset as follow: If match on key between A and B: I want all columns of A with columns number 18 having value of dataset B. If exist in B and not A then I want all records in B.(Meaning columns1 and columns 18 filled and remaining missing or blank). Please let me know how can I do this. Thanks. ... View more

Hi , I have a table as below : a1 a2 a3 a4 a5 a6 a7 a8 ------------------ a20 1 2 3 4 5 6 7 8 ------------------ 100 Say , In my caluculation I got results as 8 then I should display a8(columns name) in new columns as below. a1 a2 a3 a4 a5 a6 a7 a8 ------------------ a20 New_Columns 1 2 3 4 5 6 7 8 ------------------ 100 a8 Please help me in finding columns name from the it's value. Many Thanks.. ... View more

Hi, I have a requirement in which I should find closest value of amount. Ex: Amount col1 col2 col3 col4 col5 col6 col7 col8 col9 col0 -------col100 10 11 12 13 56 60 78 87 9 11 14 ------ 80 Now I should get value from Col8 as it is 9 and closest to 10 (always closest value that is less than the amount value). Please let me know how can I achieve this. I have a table of 100,000 from which i should find closest value of amount in each row. Thanks in Advance ... View more

Pls help me summarising Character Variables. I have a table as below : CON RANK INS1 1 INS2 1 INS3 2 INS5 2 ALC 2 RET 3 I want new table group by Rank. i.e. CON Rank INS1/INS2 1 INS3/INS5/ALC 2 RET 3 I used First. And last. In that case I am missing the middle Value. ... View more