Re: Repeat Steps >1 Data Set #4020 (2/5/2010 10:52:48 PM) comp.soft-sys.sas Thanks everyone for your suggestion, will try the Macro example. - swamy On Fri, Feb 5, 2010 at 5:08 PM, Matthew Pettis wrote: > Below is an example using the %for Macro, which can be downloaded as > directe... sasswamy
Repeat Steps >1 Data Set021 (2/5/2010 8:58:10 PM) comp.soft-sys.sas Hello, Can someone suggest SAS logic for the following I have a data set , say DataSetA I will perform several data steps , which Includes Loop , Sort , Proc Freq …etc Once all steps are done with the Dataset... sasswamy
Re: Simple Sequence in SAS #2019 (1/29/2010 7:41:32 PM) comp.soft-sys.sas Thanks Mark, Method 3 works , Is there a way to start from value 0. I mean first observation with 0 , then 1 , 2 .... n based on my requirement , some of data will contain 0 weeks , so this would help to have ... sasswamy
Simple Sequence in SAS037 (1/29/2010 7:14:35 PM) comp.soft-sys.sas All, Can someone tell me the easiest way to Increment a variable in SAS say I have 3 field , week , freq . total in a table week freq total D 20 3 3 1 21 4 7 ... sasswamy
Re: Data Sets - Split #3021 (1/29/2010 6:11:39 PM) comp.soft-sys.sas Yes , this will be a regular exercise , data will be changing every week. Here is example and the outcome I am looking for : Week frequency Cumulative Frequency 1 2 2 3 3 5 4 2 7 5 3 10 8 4 1... sasswamy
Re: Simple sum in proc sql #2021 (1/29/2010 5:28:16 PM) comp.soft-sys.sas You can try the NVL function in PROC sql On Fri, Jan 29, 2010 at 12:18 PM, SAS_learner wrote: > data t; > input t $2. x y ; > A 20 30 > B 30 20 > C 30 . > ;;; > Run ; > > Output dataset is sum of ... sasswamy
Data Sets - Split032 (1/29/2010 4:43:44 PM) comp.soft-sys.sas Hello, I have a data sets with 10 observation : Week frequency Total_count 0 1 1 11 3 4 22 6 10 15 2 12….. I wanted to create each observation as one data set , I mean Week_0 , will contain the obs... sasswamy
Re: Delete Datasets - More than one #3024 (1/28/2010 5:18:05 PM) comp.soft-sys.sas Thanks Joe, I have 9.1.3 with SP 4 , suprise this still works ,. I mean when i tired in PROC datasets PROC DATASETS NOLIST LIBRARY =3D WORK; DELETE WEEK_:; QUIT; - swamy. On Thu, Jan 28, 2010 at 12:12 PM, Joe... sasswamy
Delete Datasets - More than one033 (1/28/2010 5:05:31 PM) comp.soft-sys.sas Hello, I have to delete bunch of data sets from the WORK library , before starting the next Iteration from the Loop , I know the following some of the ways to delete single data sets : PROC DATASETS NOLIST LI... sasswamy
sasswamy's replies:
Items(2) /1
Dynamic data set-Loop8106 (12/14/2009 7:44:39 PM) comp.soft-sys.sas Hello everyone,
Can someone help me out with the following I am trying to dynamically
combine few data sets and create one final data sets.
Let say , If I have the following data sets – State wise
State_il... sasswamy(42)
IN - Option5131 (1/21/2010 7:20:36 PM) comp.soft-sys.sas All,
Can someone please let me know , What exactly would be the use for using
IN option in data set
For e-g
data vacdata;
length src $1.;
set datasetA (in=in1)
datasetB (in=in2);
if in... sasswamy(42)