Hi, I have a stiuation like , I have a history sas data set. For this week run, i will get 7 days transaction. All i need to append this 7 days transaction dataset to history sas dataset. So the history data set will be grow week by week. i have used the following code. .284 LIBNAME HTRAIL "PROD.ZCAW898F.HIS.TRAIL"; .NOTE: Libref HTRAIL was successfully assigned as follows: . Engine: BASE . Physical Name: PROD.ZCAW898F.HIS.TRAIL ERROR: Library data set PROD.ZCAW898F.HIS.TRAIL cannot be opened because it is resides on multiple volumes. ERROR: Library data set PROD.ZCAW898F.HIS.TRAIL cannot be opened because it is resides on multiple volumes. ERROR: Library data set PROD.ZCAW898F.HIS.TRAIL cannot be opened because it is resides on multiple volumes. Could you please help me how to over come this error? Thanks in Advance, Prabakaran ... View more

Hi, I need a proc sql options that expands table alies to table name in select statement. For example i have a code like, PROC SQL FEEDBACK _METHOD; SELECT A.EMP_ID FROM EMP_TABLE AS A; QUIT; i want to some proc sql option that expands in sas log like below, SELECT EMP_TABLE.EMP_ID FROM EMP_TABLE AS A Could you please provide me the sql option that expands table alies as table name in column present in SELECT statement? Thanks in Advance, Praba ... View more

Hi, I have a dataset with two obs and one varibale. The variable name is A and the values are "USA SAS" & "EARTH WORLD". I need to create a output datset like below. INPUT: A --- USA SAS EARTH WORLD OUTPUT : USA EARTH ----- ---------- SAS . . WORLD The first part of my input variable A should go to output varible and the second part of the input variable will be VALUE of the output variable, Could you please let me know how to do this? Thanks ... View more

Hi, Sas provides layout from cobol to sas convertion (COB2SAS tool). However, i have a situation like, i have sas file layout, i would like to convert this sas layout to COBOL readable lay out. Does sas offer any tool to accomplish this task? Thanks! ... View more

Hi All, I have a excel sheet with one column of data. i have to read this column as Stock_Num to stored process and do the stoking calculation and create the report in EXCEL. Could you please let me know how to read a column with 20 values to SAS EG stored process? ... View more

Hi , I want to create permanent data sets created by my project. I want single node data set names. Is it possible in sasEG. for ex, Data data1; a=1; run; data1 should be created in user library rather than work library. Thanks, ... View more

Hi Team, I have a situation like, One PS file has list of PDS names. In SAS , i want to read this PS file first, and then in first record actually first PDS name, I have to read all the member in the first PDS, after read the second line, which is Second PDS name, then i have to read all the members in the second PDS. I have tried FileVar also, but not working for my scenario. Could you please help me? ... View more

Hi, I have a PDS with 10 members. I have to scan the symbol "&" in every record in these 10 member. If i found, i have to replace with AND. I have a string function to do this, however i have to read the member and update the member, I don't know how to do this. Could you please help me? ... View more

Hi, I have a sas date set with 20 colums, say COL A,B,C... . i want to know the unive value of COL A and unique values of COL B and so on. I have a idea to read the same dataset 20 times and get rid of duplicates, but i think this is not an efficeint way of coding. Could you please help me out of this problem ... View more