About awais

rhodesc2801 · ‎02-20-2021

I think this person was looking under the Practices folder and not the Activities folder. Read the instructions carefully. Like Bill Murray says, Baby Steps.

awais · ‎10-10-2019

Hi Patrick, Ditto! Excellent. Never knew that :). thank you for your help! awais

awais · ‎10-09-2019

Hi Patric, yeey. I got it working. you were right it had to do something with format of the macro variable. I modified the code as below and it is working: proc sql; select prodname, prodcost format 32. into: prodname, : prodcost trimmed from procsql.products; quit; %put &prodname and &prodcost; proc sql; select prodname, prodcost from procsql.products where prodname = "&prodname"; quit; /* Resolved now */ proc sql; select prodname, prodcost from procsql.products where prodcost > &prodcost; quit;

PGStats · ‎06-20-2019

Then reading the data along the lines suggested by @andreas_lds is the way to go. Proc import is meant to simplify your life when you meet more complicated situations.

Tom · ‎06-08-2019

I kind of looks like you have at least 13 characters for the name. Why not just use a format to read the name? data bird; input Name $13. Jungle $ Min Max @@; *---+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8; cards; Robin S 28 41 Bald Eagle R 102 244 Barn Owl R 50 110 Osprey R 66 180 Cardinal S 23 31 Goldfinch S 11 19 Golden Eagle R 100 234 Crow S 53 100 Magpie S 60 90 Elf Owl R 15 27 Condor R 140 300 ; But it is really hard to see what you file looks like when you paste it into the body of you question (without using the pop-ups that preserve formatting) because the forum editor thinks you are typing paragraphs and not only uses a non-fixed width font but can remove spaces and end of lines.

Online Status	Offline
Date Last Visited	‎10-31-2020 12:47 PM

Re: How to find the second highest/ lowest values across the column

How to find the second highest/ lowest values across the column

Re: How to recall a macro that holds a numeric value

Re: How to recall a macro that holds a numeric value

Re: How to recall a macro that holds a numeric value

How to recall a macro that holds a numeric value

Re: how to import a tab delimited file with inconsistent tab space?

Re: how to import a tab delimited file with inconsistent tab space?

Re: how to import a tab delimited file with inconsistent tab space?

Re: how to import a tab delimited file with inconsistent tab space?

Re: How to find the second highest/ lowest values across the column

Re: How to find the second highest/ lowest values across the column

Re: I dont seem to find the working files (np summary,eu_occ) o- lesso...

Re: How to find the second highest/ lowest values across the column

Re: How to recall a macro that holds a numeric value

Re: how to import a tab delimited file with inconsistent tab space?

Re: Reading Raw data file using double trailing @@

SAS Analytics Explorers