Hello,   I would like to rename the following variable in Proc SQL although I know it could be done in SAS data steps.  But I would like to use in PROC SQL, how?  Thanks.   data dataout.rename;       set dataout.test;       rename HAVARTH3=AR _PRACE=RACE _AGEG5YR=AGE _INCOMG=INCOME _HCVU651=INSURANCE _BMI5CAT=BMI             LMTJOIN3=LMTJOIN  DRNKANY5=DRNKANY   DIABETE3=DIABETE _SMOKER3=SMOKER; run; ... View more

Hello:   I would like to use proc sql to create table by using the following variable?  Please let me know how to make SAS recognize the variable names.     proc sql; create table library.text2 as select HAVARTH3 _BMI5CAT _SMOKER3 from library.test1;   The SAS log showes the following error massage: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored.   Please help.  Thanks. ... View more

Hello:   I have the following modeling would like to use proc logistic to analyze.  I don't have SAS in installed in my computer, my data set is mega-dataset.  I am not sure whether the code I write is correct?  Please correct me if I am wrong.  Thanks.   Three categorical response variables: Y1 (normal),  Y2 ( medium), Y3 (Severe)   Explanatory variables:   variable X1 (categorical):  yes or no variable X2 (categorical):  yes or no variable X3 (categorical):  little, medium, most and all.   proc logistic data=test descending; class X1 (ref="no") X2 (ref="no") X3 (ref="little") / param=ref; model Y = X1 X2 X3; format X1 yesno. X2 yesno. X3 degree. ; title3 "Ordinal outcome (cumulative logit)"; run;   ... View more

Assume we would like to investigate if there is a suitable biomarker to detect the progressing of disease A.   We select five biomarkers and 30 participants.  We record the different periods of those biomarker concentrations, which are 0 month, 6 months, 12 months and 24 months.  And the golden standard diagnosis is X-ray ( Yes/No).  To find the best biomarker, what statistical model I should use?  Multilinear regression?  How to write the SAS code?  Please help.  Thanks. ... View more

Hello:   Assume we try to investigate whether there will be potential exposure to toxin A if people have high intake seafood diet. I plan to use Chi square test to compare the urine matabolite with the normal diet and high seafood intake diet in three months.  There will be 30 participants in the normal diet group and 30 participants in the seafood intake group.  And the urine metabolite is the continuous data.   Am I select the right statistical model?  How to write a SAS code?  Is it used Proc freq / Chisq?  But how? Thanks.     ... View more

Hello,     Due to I don't have SAS at home, I wish someone could help me out for two questions below.  Many thanks.   1.  Which one is not right based on the following two PROC SQL program?  Why?  In my opinion, both are not correct. A. proc sql; select product.*, cost.unitcost, sales.quantity from product p, cost c, sale s where p.item = c.item and p.item = s.item; quit; B.  proc sql; select p.*, cost.unitcost, sales.quantity from product , cost , sale where product.item = cost.item and product.item = sales.item; quit;   2. Why the PRINT procedure fails? 229 data sasuser.ranch sasuser.condo / view = sasuser.ranch; 230 set sasuser.houses; 231 if style='RANCH' then output sauser.ranch; 232 else if style='CONDO' then output sasuser.condo; 233 run; NOTE: DATA STEP view saved on file SASUSER.RANCH. NOTE: A stored DATA STEP view cannot run under a different operating system. 234 235 proc print data = sasuser.condo; ERROR: File sasuser.condo data does not exist. 236 run; NOTE: The SAS system stopped processing this step because of errors. ... View more

Hello:   I have the following dataset.   After I import them into SAS, the variable "coverage" become characterized.   I would like to replace the asterisk * with -99.  I wrote a quote below.  But one error message was shown in the log page,  It said that the "Coverage1" was uninitiated.  Why won't it happen?  How to resolve it?   Jurisdiction-Level Coverage Alabama                  3 Alaska                     1 Arizona                    3 Arkansas                 3 California                 1 Colorado                 1 Connecticut             1 Delaware                 1 District of Columbia 1 Florida                     * Georgia                   *   459 data test (drop=coverage); 460 length coverage $4.; 461 set test; 462 coverage=tranwrd(coverage1,'*','-99'); 463 coverage=input(coverage1, 4.); 464 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 462:33 463:25 463:31 NOTE: Variable coverage1 is uninitialized. ... View more

Hello, all: I have the following variable "organization".   I would like to extract the city and state into different variables.  How to do it?  Please help.  Thanks.   YT   Organization Abounding Prosperity (Dallas, TX) Asian Pacific Islander Coalition on HIV/AIDS (APICHA) (New York, NY) My Brother’s Keeper (Ridgeland, MS)   Organization                                                                                                    Cities                                States Abounding Prosperity                                                                                      Dallas                                TX Asian Pacific Islander Coalition on HIV/AIDS (APICHA)                                   New York                          NY My Brother’s Keeper                                                                                        Ridgeland                         MS     ... View more