About mohamed_zaki

mohamed_zaki · ‎02-05-2016

I am not sure what you want exactly. How your table looks is another issue and can be done by different ways. For example you can use PROC REPORT proc report data=have SPANROWS ; column code price; define code / order 'Groups'; define price/ display 'Price'; run;

mohamed_zaki · ‎02-04-2016

proc sql; select "Full Names",sum(COUNTW(name)>1) as N from have ; quit;

mohamed_zaki · ‎02-04-2016

You can use COUNTW() Example: data want; set have; Fullname=(COUNTW(name)>1); run;

mohamed_zaki · ‎02-04-2016

Check this How to Import an Excel File to SAS University Edition Follow the steps mentioned and if you still having problems post again.

mohamed_zaki · ‎02-03-2016

WARNING: The variable county_code in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable country in the DROP, KEEP, or RENAME list has never been referenced. You typed your variables names wrong in the drop statment. They are country code and county not as you added. So you are getting two warnnings for that. Regarding adding or deleting the option DELIMITER=',' . You do not have to add it if you used the option DSD as it by default deal with comma as delimiter. And it handle the comma within qoutes also. Can you post the complete observation mentioned in the log 5 00603,STANDARD,Aguadilla,Ramey,"Bda Caban, Bda Esteves, Bo Borinquen, Bo Ceiba Baja, Ext El Prado, E

mohamed_zaki · ‎02-03-2016

Yes, redirect the Sasuser folder by using the LIBNAME statement first...

mohamed_zaki · ‎02-02-2016

data pei2010 pei2011; set have; wantvar=input(strip(Date_of_Service),mmddyy8.); if wantvar > '31Dec2010'd then output pei2011; if wantvar <= '31Dec2010'd then output pei2010; run; This should work. The rest i think you know what you are doing. Note: mmddyy8. or mmddyy10. , depend on you date if the year is in two digit or four digit.

mohamed_zaki · ‎02-02-2016

@jwill731 wrote: Hello, I'm very new to SAS 9.4 and just started learning to code. I would like to separate the observations in my data by date (specifically year). My 'date_of_service' variable is in the format of mm/dd/yy but it is entered as just numbers, not as a date format. If it is as you said then it is recognized as Date by sas. Could you run : proc contents data=mylib.peinodup; run; And post the output table "Alphabetic List of Variables and Attributes" values. Your code should work fine also if your data is fine. But you should consider that it does not only separate 2010 entry from 2011. But separate (2010 and all before) from (2011 and all after).

mohamed_zaki · ‎02-02-2016

After you add your data to the shared folder. You should be able to see them from SAS Studio "Server Files and Folders". And to access this shared folder from a SAS program, use /folders/myfolders . So for example your path to the data file, should be like INFILE '/folders/myfolders/ToadJump.dat';

mohamed_zaki · ‎01-31-2016

Then kindly if that match your requirements close the thread by marking the reply as "Accepted Solution".

mohamed_zaki · ‎01-31-2016

You can use PROC FORMAT like proc format; value rangefmt 1 -<10 = '01-10' 10 -< 20 = '10-20' 20 -< 30 = '20-30' 30 -< 40 = '30-40' 40 - 50 = '40-50' ; data want; set have; code=put(price, rangefmt.); run; or you can use noraml IF/ELSE statments like data want; set have; if 1 <= price < 10 then code='01-10'; else if 10 <= price < 20 then code='10-20'; else if 20 <= price < 30 then code='20-30'; else if 30 <= price < 40 then code='30-40'; else if 40 <= price <= 50 then code='40-50'; run;

mohamed_zaki · ‎01-30-2016

You posted your same question THREE times in THREE Community !!!!! Why? One possible Solution: data want; set have; by patid date; array Team_[5] $; retain Team_ arrindex; if first.patid then do;arrindex=0; call missing (of Team_[*]);end; if trim(action) eq "added" then do; arrindex = arrindex+1; Team_[arrindex]=team; end; else if trim(action) eq "removed" and arrindex ~= 0 then do; Do i=1 to dim(Team_) by 1; if Team_[i]=team then do; do j=i to arrindex-1; Team_[j]=Team_[j+1]; end; Team_[j]=""; arrindex=arrindex-1; leave; end; end; end; else return; drop i j arrindex; run;

mohamed_zaki · ‎01-30-2016

Kindly close the thread by marking the reply as "Accepted Solution"

mohamed_zaki · ‎01-30-2016

Read more here: DO Statement Performing More Than One Action in an IF-THEN Statement

mohamed_zaki · ‎01-30-2016

I think the title is not matching the decriptions. You are asking about multiple actions not multiple coonditions. For applying multiple actions use Do; END; like if product in ('ABC', 'CDE') THEN Do; Var1=balance; Var2=balance2 ; END; ELSE Do; Var1=limit; Var2=limit2; END;

Online Status	Offline
Date Last Visited	Sunday

Re: Deleting Rows

Re: How to convert numeric variable to character which contains decim...

Re: How do I match IDs from multiple dataset to one dataset

Re: problem using select when

Re: Difference between row values

Re: Extract Week from first.date

Re: ERROR: Output SAS data set must be provided.

Re: Lag function help

Re: Run time error occurred in EM,while creating an ensemble of model

Re: PROC MI, FCS Logistic, WARNING: The maximum likelihood estimates f...

Re: keep variable order when using length statement to merge data sets

Re: How to read Raw data with embedded blank without increasing the sp...

Re: Pick up the date

Re: INFORMAT: How not to read (') ?

Visual Analytics Science and Technology (VAST) Challenge accepted by S...

Re: functions

Re: Filling gap in a panel data

Re: Sum Statement

Re: PROC Export: Replacing sheet error

Re: proc glm: class vs. absorb

Re: breaking a data set

Re: Check if name has first and last name

Re: Check if name has first and last name

Re: ERROR: DBMS type EXCEL not valid for import.

Re: Ignoring comma within quotes - Reading CSV

Re: SAS Certification Prep Base Programming for SAS 9 third edition

Re: How do I split observations by date?

Re: How do I split observations by date?

Re: SAS Studio Import External .dat file under Mac OS System. Report p...

Re: sas data table transformation

Re: breaking a data set

Re: sas data table transformation

Re: Multiple conditions in one if statement

Re: Multiple conditions in one if statement

Re: Multiple conditions in one if statement