SAS

changing proc format to if-then-else
Hi All, Can anyone let me know how to write a perl script or ksh script to change proc format in SAS to if-then-else. Please see below for example. Thanks for your help. /*old file*/ %let _V0 = var1; /* xnbntl75_n */ %let _V1 = var2; /* pct_pay_bal_cyc_1 */ proc format; value V_0_f /* var1 */ ... 21 Jun 2010 12:26

SAS Technical support
Dear Friends, I am a freelancer having over 5 years of professional experience (US & India) in SAS Clinical, SAS BI & Oracle Clinical. I provide On-Line training in SAS/Base, SAS Clinical, SAS Finaicials, SAS BI along with projects. Can give guidence in SAS Certification & job oppurtunities. Details are as follow... 20 Jun 2010 14:33

Import Excel - DBMS
Hi, I am new to SAS 9.1, and in attempting to import an Excel file, I get an error message in the Log that Excel is not valid for DBMS. It makes no sense. Please assist with the following code: proc import DATAFILE= "C:\Documents and Settings\gshrivi\My Documents\V \Test.xls" OUT= WORK.SAS_Import_Te... 21 Jun 2010 05:52

Duplicate Observations
Dear All: I have this data below data have; input name $ dep $ age marks ; cards; JOHN DMA 30 29 AMAR CLI 29 49 NAGI SAS 11 19 BILL PRO 19 11 JOHN DMA 30 29 AMAR CLI 29 49 JOHN DMA 00 00 ; run; This the dataset i want NAGI SAS 11 19 BILL PRO 19 11 JOHN DMA 00 00 i.e remove all the data poi... 21 Jun 2010 06:57

A faster way to do what this line of code does
Both data sets CO and EA are about a million observations and this line of code below is taking forever to finish. I wonder how to do what I want to do below any faster: PROC SQL; CREATE TABLE home.matches AS SELECT * FROM home.CO as b where EXISTS (SELECT * FROM home.EA as a WHE... 26 Jun 2010 09:43

about sheet= statement in proc export
Hi SAS experts, I am trying to export the summary results to excel and create each table names based on plan names. However, I am having trouble creating table names with SHEET= statement in proc export step. The main sas structure has been illustrated here. Any help are very appreciated. Thank you! %macro de... 21 Jun 2010 10:12

Datastep --- Comparision
Dear all: This is the dataset i have and data have; input name $ deg $ dep $ res test $ temp bp1 bp2 ds $ ; cards; BHA SSP DMA 12 BUN 89 12 12 AE BHA SSP DMA 11 BUN 11 19 11 AE BAR DCO CLI 18 BUN 11 19 98 AE MEL DMS DMA 11 BUN 98 10 17 AE BHA SSP ADN 12 BUN 89 12 12 SN BHA SSP ACN ... 18 Jun 2010 21:16

Categorical Data Analysis Using SAS, Seminar July 12-16
CATEGORICAL DATA ANALYSIS USING SAS A SHORT COURSE TAUGHT BY PAUL D. ALLISON On July 12-16 in Philadelphia, I will teach my 5-day course on Categorical Data Analysis. This seminar covers material equivalent to a full semester's work and includes such topics as binary logistic regression, probit regression, or... 18 Jun 2010 12:25

plot from proc Freq output
Hi, My proc freq output is as below. I just want a simple line plot: percent*fgroup, but by group Gender, and overlay in one plot. But I cann't do this in gplot. Also I've tried plot in proc freq, and only bar plot and dot plot available, and not what i want. Gender fgroup COUNT PERCENT 1 0 1 0.574712644 1 1 6 3.... 18 Jun 2010 12:25

How can I remove the ""
Hi, I have a large csv file. But each record is quoted by ", for example, "name1, address1, city1, state1, zip1,,,,,,,,,,,,," "name2, address2, city2, state2, zip2,,,,,,,,,,,,," I use file import and sas treat all the string as one single variable. Since the file has more than 200K records, I cannot use ex... 18 Jun 2010 13:32