Hello, everybody! We can create simple indexes using the following statement. Proc SQL; Create Index {Index_name} On {Table_name} (Table_variable) ; Quit; Sometimes we have more than one variable to match data in datasets. .... Where A.Field1 = B.Field1 And A.Field2 = B.Field2 .... To decrease work time it is necessary to create indexes. But in this situation it is not so efficient to create two simple indexes on Field1 and Field2, especially if data in Field1 or Field2 have only two or three variants (1, 2 and 3 for example). In Oracle we can create complex indexes on two or more fields. How can I create complex index in SAS Dataset? ... View more

Hi! I have a script which extracts a set of information from our SAS Database using SAS EG (a combination of Data steps and Proc SQL). If I need to change my input parameters (for examlpe data interval etc.) I must change my script manually. Is there an oppotunity to set variable values using some sort of user forms in VBA when you just submit your script with dialog box appearing. Here you can either confirm your default values or input new ones. It allows to utilize you script for use by ordinary users who are not familiar with SAS programming. ... View more

Hello! One of the variables in my source of data is number of 16 characters. I want this variable to have a numeric format in my dataset. When I import data into SAS, using EG import wizard, I choose numeric format, but only 12 characters appear with trimming 4 last numbers. Can anybody explain how to import long numbers in SAS. ... View more

Hi! I've got problems impoting DOS TXT File to SAS Server using EG Import File Wizard. The problem results in trimming some values of character string. For instance, for a character field SAS assigned field width equaled 25 characters. Performing File import procedure results in creating a SAS Data set. Verifying obtained SAS Data set I've noticed that there were some observations with fields length originally greater than 25 which result in trimming such values from the right side from their initial length to 25 symbols. It's absolutely unclear for me how SAS calculates the maximum width of the character fiels. I never had such problems in Excel or Access. The only understandable way of fixing the problem is to determine somehow the length of the longest string of the field and to correct informat manually prior to start import procedure. In most cases it is hard to accomplish due to giant number of observations. Please help me avoid importing txt data trimming, help me make SAS understand maximum field width. P.S. For Excel Files Import in EG we have special option "Use longest value as column width" (Tools\Options\Perfomance) ... View more

Hello! I've got problems trying to import data from a data file located on my personal computer to the SAS Data set using INFILE statement. If I use Enterprise Guide Import Wizard everything performs perfectrly. I point to my local file using EG file explorer. But the need is to perform this task using SAS Base script. The problem is that the SAS server can not see my local computer. Thus I can't refer the local file such as: FILENAME Data 'c:\info.dat'. Can you tell me If there is a way to make the server "see" my local computer (my local files) to allow me perform the SAS import procedure automatically by means of SAS Base script (avoiding the use of EG Import Wizard)? Thank you for your attention ... View more