Home

Ronein

Hello There is an error in this code that create format. What is the way to solve it? proc format; value Fmt -999='(a) A=0 AND B not 0' -888='(b) A=0 AND B=0' -777='(c) B=0 AND A not 0' 0='(d) A>0 AND B=0' 0<-25='(e1) Ratio till 25%' 25<-50='(e2) 25%<Ratio<=50%' 50<-75='(e3) 50%<Ratio<=75%' 75<-85='(e4) 75%<Ratio<=85%' 85<-95='(e5) 85%<Ratio<=95%' 95<100='(e6) 95%<Ratio<100%' 100='(e7) Ratio=100%' 100<-105='(f1) 100%<Ratio<=105%' 105<-115='(f2) 105%<Ratio<=115%' 115<-125='(f3) 115%<Ratio<=125%' 125<-150='(f4) 125%<Ratio<=150%' 150<-HIGH='(f5) 150%+' other='(g) Negative Ratio' ; Run; error 1 The SAS System 10:31 Monday, May 27, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (2)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 proc format; 27 value Fmt 28 -999='(a) A=0 AND B not 0' 29 -888='(b) A=0 AND B=0' 30 -777='(c) B=0 AND A not 0' 31 0='(d) A>0 AND B=0' 32 0<-25='(e1) Ratio till 25%' 33 25<-50='(e2) 25%<Ratio<=50%' 34 50<-75='(e3) 50%<Ratio<=75%' 35 75<-85='(e4) 75%<Ratio<=85%' 36 85<-95='(e5) 85%<Ratio<=95%' 37 95<100='(e6) 95%<Ratio<100%' ___ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ',', -. ERROR 76-322: Syntax error, statement will be ignored. 38 100='(e7) Ratio=100%' 39 100<-105='(f1) 100%<Ratio<=105%' 40 105<-115='(f2) 105%<Ratio<=115%' 41 115<-125='(f3) 115%<Ratio<=125%' 42 125<-150='(f4) 125%<Ratio<=150%' 43 150<-HIGH='(f5) 150%+' 44 other='(g) Negative Ratio' 45 ; NOTE: The previous statement has been deleted. 46 Run; 2 The SAS System 10:31 Monday, May 27, 2024 NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 73.81k OS Memory 27300.00k Timestamp 05/28/2024 07:26:06 AM Step Count 157 Switch Count 0 Page Faults 0 Page Reclaims 7 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 NOTE: The SAS System stopped processing this step because of errors. 47 48 GOPTIONS NOACCESSIBLE; 49 %LET _CLIENTTASKLABEL=; 50 %LET _CLIENTPROCESSFLOWNAME=; 51 %LET _CLIENTPROJECTPATH=; 52 %LET _CLIENTPROJECTPATHHOST=; 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 %LET _SASPROGRAMFILEHOST=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62

HeatherNewton

Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need to setup schema for showing data via ODBC or there is specific settings required dealing with?

jnivi

Hi there, I have a quick question about manipulating a dataset in SAS. I have included a sample dataset below. Date Country Weekly Cases 2021-08-09 United States 500 2021-08-10 United States 0 2021-08-11 United States 0 2021-08-12 United States 0 2021-08-13 United States 0 2021-08-14 United States 0 2021-08-15 United States 325 2021-08-16 United States 0 2021-08-17 United States 0 2021-08-18 United States 0 2021-08-19 United States 0 2021-08-20 United States 0 2021-08-21 United States 0 2021-08-10 United Kingdom 100 2021-08-11 United Kingdom 0 2021-08-12 United Kingdom 0 2021-08-13 United Kingdom 0 2021-08-14 United Kingdom 0 2021-08-15 United Kingdom 0 2021-08-16 United Kingdom 400 2021-08-17 United Kingdom 0 2021-08-18 United Kingdom 0 2021-08-19 United Kingdom 0 2021-08-20 United Kingdom 0 2021-08-21 United Kingdom 0 What I am trying to do is report the number of cases by week for each country in my dataset. However, what I noticed is that countries did not always report on the same day of the week. I was wondering if there was a way for me to manipulate the data so that I could divide the weekly count into daily counts (important to note that a weekly count might not always represent a 7 day reporting week, in my example below the first weekly count for US represent 6 days and the 2nd weekly count represents 7 days). Ideally every time a weekly count is presented for each country, I would like that number to be divided equally until the next weekly count is present for that country. I have included what I would like my data to look like instead. Date Country Weekly Cases Daily Cases 2021-08-09 United States 500 83.3 2021-08-10 United States 0 83.3 2021-08-11 United States 0 83.3 2021-08-12 United States 0 83.3 2021-08-13 United States 0 83.3 2021-08-14 United States 0 83.3 2021-08-15 United States 325 46.4 2021-08-16 United States 0 46.4 2021-08-17 United States 0 46.4 2021-08-18 United States 0 46.4 2021-08-19 United States 0 46.4 2021-08-20 United States 0 46.4 2021-08-21 United States 0 46.4 2021-08-10 United Kingdom 100 16.7 2021-08-11 United Kingdom 0 16.7 2021-08-12 United Kingdom 0 16.7 2021-08-13 United Kingdom 0 16.7 2021-08-14 United Kingdom 0 16.7 2021-08-15 United Kingdom 0 16.7 2021-08-16 United Kingdom 400 66.7 2021-08-17 United Kingdom 0 66.7 2021-08-18 United Kingdom 0 66.7 2021-08-19 United Kingdom 0 66.7 2021-08-20 United Kingdom 0 66.7 2021-08-21 United Kingdom 0 66.7 I have a pretty large dataset (400k observations) with 230 unique countries that span a few years. Again the countries did not always report their weekly count on the same day, and the weekly counts don't always represent a 7 day count. If there is a way I can easily manipulate the dataset to do the above daily count, I would really appreciate it! Thank you so much for any advice that you can provide!

NahidSultanakmc

Hello, I am working on repeated logistic regression using proc genmode. In the model, I used interaction term. In the result file, I am able to make the following lists for the file using this code: data parameter1; set CpG; if Parm = "Intercept" then delete; if Parm = "MO_SPT_12m" then delete; if Parm = "gender" then delete; if Parm = "p0_sesc_5_r" then delete; if Parm = "P10_Q5BirthWeight" then delete; if Parm = "P10_Q5BirthWeight" then delete; if Parm = "Time" then delete; run; rcg00026290 rcg00026290*Time rcg00041989 rcg00041989*Time rcg00085123 rcg00085123*Time rcg00119811 rcg00119811*Time rcg00281977 rcg00281977*Time But I need the values with interaction only. Is there any code that will delete the values without interaction term? Thanks.

r3570

Hi All, Could anyone help me with the below requirement? I have 3 variables SUBJ CODE TRT which have values as following. SUBJ CODE TRT 1001 AB A 1001 AB B 1002 CD C 1002 CD C 1003 EF E 1003 EF F In the above data for each SUBJ there is a specific code which have corresponding TRT vales as A and B. Example, for SUBJ 1001, code is AB and TRT is having 2 records for same SUBJ and CODE with A in 1 row and B in next row. If it is 1002 then the 2 TRT records should be C and D, but if it C and C then it should be flagged. See below expectation. SUBJ CODE TRT FLAG 1001 AB A 0 1001 AB B 0 1002 CD C 0 1002 CD C 1 1003 EF E 0 1003 EF F 0 1004 AD A 0 1004 AD A 1 Can anyone help me achieve this?