SAS Support Communities

mohamed_zaki · ‎10-17-2014

what is the error you are getting? type the log error

mohamed_zaki · ‎10-17-2014

okay input argument to the macro,but share your code to help you further.

mohamed_zaki · ‎10-17-2014

how do you assign the value to the &var. share your code please

mohamed_zaki · ‎10-17-2014

First: Your problem is in your logic. As you know -1 > - 2 so is -.124999999999999 > -.125 that is mean that when you say low - (-0.1) = 'A' -0.2 - (0) = 'B' you will get overlap, so you can not say low - -124999999999999 = 'A' -0.125 - (-0.624999999) = 'B' Second: you do not need () in format Finally: try this, it should work proc format; value V1format low - -0.875 = 'A' -0.874999999 - -0.625 = 'B' -0.624999999 - -0.375 = 'C' -0.374999999 - -0.125 = 'D' -0.124999999 - 0 = 'E' 0-0.1249999999 = 'F' 0.125 - 0.3749999999 = 'G' 0.375 - 0.6249999999 = 'H' 0.625 - 0.8749999999 = 'I' 0.875 - high = 'J'; run;

mohamed_zaki · ‎10-16-2014

What if the data sets have different names not a series like class1 , class2 ...... and i do not know there names in advance_ the data sets i mean_, all what i know is the lib name

mohamed_zaki · ‎10-16-2014

How to delete every observation in each dataset in a specific lib. PROC DELETE delete all the data set, what i need is to delete all the data set observations not the data sets it self.

mohamed_zaki · ‎10-09-2014

This note let you know about the missing values that were created. for example check this 4. Missing values in assignment statements . It give you an example with details about this note.

mohamed_zaki · ‎10-09-2014

What do you mean: Do you want each observation in your data set to printed in separate file, where they are printed in three lines and each variables printed beside the column name as in the example you provided above.

mohamed_zaki · ‎10-06-2014

Did you made sure that the "data" folder exist in "myfoldrs" folder physically? Libname Statement create a short reference to your folder it will not create one for you.

mohamed_zaki · ‎10-06-2014

What do you mean by "how many answers are correct?" The most of the questions have only one correct answers and some questions _which are minority_ have more than one correct answers and you can notice that from the question and the exam system gives you the ability to choose more than one answers.

mohamed_zaki · ‎10-03-2014

Where is the problem? Share your code please. Or check : Inserting Rows into Tables

mohamed_zaki · ‎10-02-2014

How this is not working for you data have; input y; cards; 80 120 1390 2235042 ; run; data want; set have; yy=strip(put(y,8.1)); z= length(yy); v=8-z; x=catt(yy,repeat('0',v-1)); run;

mohamed_zaki · ‎10-02-2014

If you want to deal with char, you can also use the repeat function for example: data want ; y='33.3'; z=length(y); v=8-z; x=catt(y,repeat('0',v-1)); run;

mohamed_zaki · ‎09-29-2014

data want (drop=newV ); set have; by id1 id2; if (first.id2 ) then do; retain newV ' '; if STATUS = ' ' then Do ; STATUS = 'V'; newV=STATUS; End; Else if STATUS in ('C','V') then newV=STATUS; End; Else do; If STATUS in ('C','V') then newV=STATUS; Else if STATUS=' ' then STATUS=newV; end; run;

mohamed_zaki · ‎09-29-2014

Congratulation Dr. Wicklin ... All the best Thanks mohamed

Online Status	Offline
Date Last Visited	‎10-09-2023 04:22 PM

SAS Support Communities

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: macro variable in oracle libname issue

Re: using macro variables in imagename

Re: using macro variables in imagename

Re: Negative values in proc format

Re: Delete all datasets observations in a specific library

Delete all datasets observations in a specific library

Re: SAS CODE

Re: Report display question

Re: Error Assigning a Library

Re: SAS Certification question- Are we allowed to use pc sas /base sas...

Re: How do you add a row with values?

Re: conversion from decimal to characters

Re: conversion from decimal to characters

Re: By Group -- Replace MISSING VALUES ALONG CONSECUTIVE DATES - (Repo...

Re: Congratulations Rick Wicklin on recent Master Level achievement

Follow Us

What is...