Hi there   I have some data files in csv and dat formats in my local directory. I need to import them into SAS EM Workstation to perform data mining operations. I don't find any clue on how to do that ? I can't write proc import code in SAS EM. Is there a way around this problem? I would appreciate your help. Thanks ... View more

Hi there I am having issue with SAS EM. When I invoke SAS EM (File>New>Project), It opens the second window with project name and SAS server Directory fields and skips the first window with SAS server field where we see or specify SASApp - Logical Workspace Server. It goes to the second window. It ends with two step process instead of four step process. I do not get to the final window with Name, SAS Metadata location, SAS Application server and server directory fields. When I drag the data table into the workspace area, the data table does not appear or can not be dragged into the workspace area. I am new to SAS EM. I would appreciate if someone can help me resolve this issue.  Thanks. ... View more

Hi there   I have separate adrress fields like Address, City, State and Zipcode but I would like to create a single address fields by combining all these four fields into one field like : 1345 Quail Creek Ln, Alexandria, VA 22039   Address                              City                           State               Zipcode 1345 Quail Creek Ln           Alexandria                VA                  22039 4569 Foxhole Drive            Chantilly                    VA                  22033   Single address field I want to create is: 1345 Quail Creek Ln, Alexandria, VA 22039                                                                4569 Foxhole Drive, Chantilly, VA 22033   I tried using CATX function like this New_address = catx(',',Address,City,State,Zipcode); but it resolves into: 1345 Quail Creek LN,Alexandria,VA,22039 How do I insert space between two elements of the address separated by comma and just the space between state and ziocode as I have shown above ? Please help me. Thanks   ... View more

Hi deal all I have attached an excel file with the original sample data file and the desired data table that I want. I thought I could produce the desired data table with proc transpose but I could not produce it. I am not that good at data manipulation using sas datstep and procs. I have a variable named SP_ID which I want to use that as the ID variable. The ID variable (SP_ID) has three values, L, N, S. There is another variable identifying variable (ID) that I want to use as the by variable. Actually I want to use ID and DATE variable as the BY Vairble like below   Proc transpose data=Have out=trans_have; by ID DATE; var ........; ID SP_ID; Run;   When you take a look at the attacheed excel data file, you will understand what I really want. I think it requires a series of Proc transpose to get to the desired data table that I want which I have included in the excel file. Please help me on this. I would greatly appreciate your kind assistance in this regard. I think there are number of different techniques in SAS that one can use to get to the desired data table that I want. Please include all those dat step and procs that can be used to produce the desired data table. Thanks   Very Respectfully   Chandra            ... View more

Hi there   I have a dataset that contains both character and numeric variables. I need to validate the values of both the character and numeric variables including nulls, missing values, the range of values and the outliers (outside the range of values) if there are any.  If anybody can help me with a macro that I can customize to serve my purpose, I would greatly appreciate your kind assistance in this regard. Thank you very much.   Chandra ... View more

Hi I need some help on SAS macro. Let me state the problem.   I have a data table that has name, date, salary columns. The salary is missing for some names in some dates. I would like to produce a report in which I want to include the footnote that says "Salary is missing for Name=&name in date=&date. Here is the sample data table   Name Date Salary Robert 01Feb2017 5000 Shyam 01Mar2017 2000 Dinesh 01May2017 3000 Shou 01Jul2017  . Rishi 01Sep2017 4000 Noral 01Dec2017 . ; Please help me on this. Thanks ... View more

Dear all   I have large zipped data files on SAS Server. I would like to unzip them in the SAS server instead of downloading zipped files to the local machine, unzipping and uploading them again into SAS Server. Is there SAS codes or macros that can be used to perform unzipping zipped files on the SAS Server ? I would really appreciate your assistance in this regard. Thanks   Chandara ... View more

PROBLEM STATEMENT    I have 4 large data tables from which I have to create a random sample of certain sizes from each data table. Each data table has a field called COMMAND.  The values for the COMMAND field are as follows: DC, TX, FL and GL. Each data table has only one command value eg either DC or TX or FL or GL. Each data table has more than 5 million records.  The sample sizes are as follows for each COMMAND:   Data Table     Command           Sample size Table_1             DC                      1000 Table_2             TX                       1500 Table_3             FL                        2000 Table_4             GL                      1400   What I want to do is a MACRO that creates a series of random samples using PROC SURVEYSELECT from those 4  data tables based on the values of COMMAND variable in those tables.   I need to create a random sample for each of these command (DC, TX,FL and GL) with the sample size of 1000, 1500,2000, and 1400 respectively as shown ABOVE. I need a macro that can do this using PROC SURVEYSELECT . What I want is, a random sample of 1000 for DC, 1500 for TX, 2000 for FL and 1400 for GL from those 4 tables . For example, if the command field DC has 4 million records in table_1, I want to create a random sample size of 1000 for DC from that table (table_1) and likewise, 1500 random sample for TX (another table, table_2) and likewise for all(table_3 and table_4). Please help me on this. I really appreciate the kind assistance.    I want to use the following code for random sampling OR ANOTHER CODE IF YOU WANT TO SUGGEST   PROC SURVEYSELECT DATA=ERP_MASTER                                 METHOD=SRS                               REP=1                               SAMPSIZE=&samplesize.                               OUT= &COMMAND._SRS;                               ID _ALL_;     I hope this helpS you understand the problem STATEMENT. I highly appreciate your kind assistance. Thanks   Gopi Upreti ... View more

Hi there   I am facing a problem with cobol comp-3 packed field data. I have not worked with this type of data before. How can I read cobol comp-3 packed field data into SAS ? Can anybody help me with the SAS read in script for such data ? OR how can we conver it into SAS dataset ? Is there a functionality in SAS enterprise guide (EG) that can be used to convert this type of data into SAS ? I would highly appreciate your assistance in this regard.   Chandra ... View more