About abuanuazu

abuanuazu · ‎03-05-2016

Dear All, Thank you for all help on Data Step question. I made a mistake in formating the real data from .xlsx to csv that cause all the problem. I used the orginal data import to SAS and works fine. Thank you all again. please see the attached result. Abuanuazu

abuanuazu · ‎02-28-2016

Thank you for your prompt response. This is the actual code: Data cancer; Infile "C:\sas\bcancer.csv" dlm="," firstobs=2; Input AJCC $13; Run; Data status; Set cancer; if AJCC="Stage I" then mystage="Stage 1"; else if AJCC="Stage II" then mystage="Stage 2"; else if AJCC="Stage III" then mystage="Stage 3"; else if AJCC="Stage IV" then mystage="Stage 4"; else mystage="Unknown Stage"; Run; proc freq data=status; table mystage/chisq; run; initially to test the data i didn't assign length. After your response, I add length to AJCC $13 and execute the code. The output produce all the data to "unknown" 100% data. Any suggestion?

abuanuazu · ‎02-28-2016

Dear All, The data contains variable called AJCC with the sub-variables: stage I, Stage II, Stage III, Stage IV, and Unknown Stage. But I keep getting missing output "Stage III". see the attached document for detail. Thank you for any help related to the problem. abuanuazu

abuanuazu · ‎02-22-2016

Thank you for your solution to the problem.

abuanuazu · ‎02-20-2016

Reeza, As always, you have a solution to the question. I attached the solution output. Thanks

abuanuazu · ‎02-20-2016

Thank you Reeza for prompt response. To make clear, I want the the output table to produce as coded, White, Black, & Other in a sequence. Thanks

abuanuazu · ‎02-20-2016

I keep getting the output on racegrp, "Other" option displayed either in the middle or at the top of the result. see attached in details for sas code and output. Thanks.

abuanuazu · ‎01-27-2016

The data contains 4 groups of stains 1. FA_ALK (1) 2. Immunhistoochemistry stain(IHC)-26 2. In situ hyberdization stain(IHS)-5 4. Sequence Iron-hematein stain(SEQ)-47 How to use select statement in SAS and compare between stains(FA_ALk, IHC, ISH, & SEQ) and within stains. For all stains, the value is 0 or 1. Please see the attached variables for more informaion. Thank you.

abuanuazu · ‎01-23-2016

Dear All, Thank you for your help. Finally, I got the solution to the problem Data chemo; set adph; select (Chemotherapy); when('"chemoth') chemo='Yes chemo'; when('"recomme') chemo='Yes chemo'; otherwise chemo='No chemo'; end;

abuanuazu · ‎01-23-2016

Dear Reeza, Thank you for prompt response. Still I need more assistance. As per your code, the result attached. It picks all the patients as "No chemo". Please find here is attached the sub-variables under Chemotherapy and the data type is boolean as 1 or 0.Thank you again. Abuanuazu

abuanuazu · ‎01-23-2016

Objective: I was interested to create a new variable "treat" , to read the data, and provide information about cancer patient frequency of those taking chemotherapy or not. data chemo1; set adph; select(Chemotherapy); when(0) treat="No chemo"; when (1) treat="Yes Chemo"; otherwise; end; run; proc freq data=chemo1; table treat/chisq;run; After I ran the above code, produce all the data as missing with the new variable "treat". I need your help.Thanks.

Online Status	Offline
Date Last Visited	‎06-14-2018 11:12 AM

Re: Data step

Re: Data step

Data step

Re: Clustering with both Numerics and Categories data in SAS EM 13.1

Re: sas output

Re: sas output

Control order of values displayed in Proc Freq output

How to create an arrays in SAS

Re: Create a sas variable using select statement

Re: Create a sas variable using select statement

Re: sas output

Re: Create a sas variable using select statement

Re: Data step

Re: Data step

Data step

Re: Clustering with both Numerics and Categories data in SAS EM 13.1

Re: sas output

Re: sas output

Control order of values displayed in Proc Freq output

How to create an arrays in SAS

Re: Create a sas variable using select statement

Re: Create a sas variable using select statement

Create a sas variable using select statement