About mhollifi

ChrisNZ · ‎02-03-2021

Sorry @Tom I awoke this old thread. My mistake

PGStats · ‎11-09-2018

You most likely imported a non-printing character. Try retyping the code (don't cut and paste!)

Reeza · ‎04-09-2018

In addition to @Astounding's suggestion, it's also worth checking the documentation, there's an 'S' modifier in the COMPRESS function to remove all spaces. s or S adds space characters (blank, horizontal tab, vertical tab, carriage return, line feed, form feed, and NBSP ('A0'x, or 160 decimal ASCII) to the list of characters. http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0fcshr0ir3h73n1b845c4aq58hz.htm&docsetVersion=9.4&locale=en#p1v3kt0k9xvlwjn1gvwne2mwuk6f

Reeza · ‎04-09-2018

In addition to @Astounding's suggestion, it's also worth checking the documentation, there's an 'S' modifier in the COMPRESS function to remove all spaces. s or S adds space characters (blank, horizontal tab, vertical tab, carriage return, line feed, form feed, and NBSP ('A0'x, or 160 decimal ASCII) to the list of characters. http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0fcshr0ir3h73n1b845c4aq58hz.htm&docsetVersion=9.4&locale=en#p1v3kt0k9xvlwjn1gvwne2mwuk6f

Tom · ‎04-06-2018

If you want the first sheet then just don't specify anything. Also try just use the XLSX libname engine. libname in xlsx "e:\Users\mhollifi\Desktop\MaxWell read excel\pull08to08.xlsx"; proc copy inlib=in outlib=work; run;

Ksharp · ‎04-06-2018

If you want use these options MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; Try Save As your "test 1.xlsx" into "test1.xls" .

DanH_sas · ‎02-28-2018

The reason that the missing value did not affect your plot is that the column was used only for the data labels. The X, Y, SIZE, and GROUP roles control the actual plotting for the BUBBLE plot. In general, missing values in a DATALABEL column are not drawn. That is how you can control what labels are drawn in your plot.

mhollifi · ‎02-13-2018

I finally figured out. There is a file called "formats" in my work library. I copied it to my hard drive, and read it using R. It worked. Thank you for your help. I figured out the concept.

mhollifi · ‎02-06-2018

Please look at the Total line. I want have percent not frequency in the line. thank you.

mhollifi · ‎01-22-2018

thank you I finally understand what you mean. it worked.

mhollifi · ‎01-22-2018

thank you. it worked.

mhollifi · ‎01-16-2018

Thank you all for help. I found out that both methods works when the number of members in the zip file is small amount. I bombed because I have over 12thausands files in the zip file. I don't think SAS can run through. I guess, I need to print files name to read them all manually...

mhollifi · ‎01-08-2018

thank you for your reply. It getting closer but not quite. Why I got this error message and not be able to use attribute? 5321 data attrmap; 5322 length value $ 9 fillcolor $ 9; 5323 retain linecolor "black"; 5324 input id $ value $ fillcolor $; 5325 datalines; NOTE: The data set WORK.ATTRMAP has 6 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 5332 ; 5333 5334 run; 5335 proc sgpanel data=percent pctlevel=group dattrmap=attrmap sganno=anno; 5336 5337 panelby year / columns=1; 5338 5339 HBARPARM category = penatvty response=percent /group=educ grouporder=ascending 5340 attrid=percent; 5341 HBARPARM category = penatvty response=percent1 /group=educ grouporder=ascending 5342 attrid =percent1; 5343 rowaxis FITPOLICY=NONE discreteorder=data; 5344 format penatvty penatvty. educ educ. ; 5345 keylegend / sortorder=ascending; 5346 run; WARNING: Only one attrid can be assigned to the "EDUC" variable. The additional attrid will be ignored.

Online Status	Offline
Date Last Visited	‎04-19-2020 03:18 PM

proc rank syntax error

How to find hidden character and get rid of it

How to find hidden character and get rid of it

Re: How to import excel which has long text in one cell

Re: How to import excel which has long text in one cell

How to import excel which has long text in one cell

Proc import excel read second row

Re: Import multiple Excel files(xlsx) directly from zip file

Re: Import multiple Excel files(xlsx) directly from zip file

Import multiple Excel files(xlsx) directly from zip file

Re: proc rank syntax error

Re: how to create sas7bcat file?

Re: Import multiple Excel files(xlsx) directly from zip file

Re: proc rank syntax error

Re: How to find hidden character and get rid of it

Re: How to find hidden character and get rid of it

Re: How to import excel which has long text in one cell

Re: Proc import excel read second row

Re: How to eleminate one of annotations for double plot?

Re: how to create sas7bcat file?

Re: proc freq with totpct not print percent. Why?

Re: proc datasets not find the dataset

Re: macro parameter

Re: import xml file compressed into .7z

Re: How to make 2 different colors bar in sgpanel with hbar