03-08-2019
daisy6
Quartz | Level 8
Member since
06-14-2017
- 113 Posts
- 1 Likes Given
- 4 Solutions
- 0 Likes Received
-
Latest posts by daisy6
Subject Views Posted 6419 01-31-2019 03:01 PM 6437 01-31-2019 12:24 PM 6449 01-31-2019 11:58 AM 3257 01-28-2019 02:22 PM 989 01-23-2019 01:55 PM 1020 01-23-2019 10:47 AM 3160 11-30-2018 09:26 AM 3185 11-29-2018 04:30 PM 3192 11-29-2018 02:26 PM 3211 11-29-2018 12:32 PM -
Activity Feed for daisy6
- Posted Re: Retain leading and trailing spaces when import the csv files into SAS on SAS Programming. 01-31-2019 03:01 PM
- Posted Re: Retain leading and trailing spaces when import the csv files into SAS on SAS Programming. 01-31-2019 12:24 PM
- Posted Retain leading and trailing spaces when import the csv files into SAS on SAS Programming. 01-31-2019 11:58 AM
- Posted how to automatically halt the SAS program if detecting the error message on log window on SAS Programming. 01-28-2019 02:22 PM
- Posted Re: how to get bold bottom border when using proc report to export the data on ODS and Base Reporting. 01-23-2019 01:55 PM
- Posted how to get bold bottom border when using proc report to export the data on ODS and Base Reporting. 01-23-2019 10:47 AM
- Posted Re: How to know the variable name in the output dataset of Proc compare output on SAS Programming. 11-30-2018 09:26 AM
- Posted Re: How to know the variable name in the output dataset of Proc compare output on SAS Programming. 11-29-2018 04:30 PM
- Posted Re: How to know the variable name in the output dataset of Proc compare output on SAS Programming. 11-29-2018 02:26 PM
- Posted Re: How to know the variable name in the output dataset of Proc compare output on SAS Programming. 11-29-2018 12:32 PM
- Posted How to know the variable name in the output dataset of Proc compare output on SAS Programming. 11-29-2018 11:38 AM
- Posted Re: how to concatenate the values with two macro values as variable names in data set on SAS Programming. 05-15-2018 09:27 AM
- Posted Re: how to concatenate the values with two macro values as variable names in data set on SAS Programming. 05-10-2018 11:14 AM
- Posted how to concatenate the values with two macro values as variable names in data set on SAS Programming. 05-10-2018 10:36 AM
- Posted How to fill the sequential alphabet letter to survey questions on SAS Programming. 05-01-2018 11:06 AM
- Posted Re: how to deal with two rows header data from survey monkey when imported into SAS on SAS Programming. 05-01-2018 10:58 AM
- Posted how to deal with two rows header data from survey monkey when imported into SAS on SAS Programming. 04-30-2018 04:26 PM
- Posted Re: How to delete a string of special character in character variables on SAS Programming. 04-30-2018 03:25 PM
- Posted Re: How to delete a string of special character in character variables on SAS Programming. 04-30-2018 03:15 PM
- Posted Re: How to delete a string of special character in character variables on SAS Programming. 04-30-2018 03:00 PM
-
Posts I Liked
Subject Likes Author Latest Post 2
01-31-2019
03:01 PM
I cann't provide you the exact data for private information. However, I believe that you already gave me a good idea to deal with the leading and trailing space problem. Thank you for the reply.
... View more
01-31-2019
12:24 PM
Thanks for the help. But for the trailing space, how to deal with that? like: "ItemKey","Response","Iscorret' "4615313059","contribution","correct" "4615313067","contribution ","not correct" because I keep these two different response If using dsd, the import dataset is the same as using proc import. If not using dsd, the dataset will keep the quote symbol. Is any better way to deal with my case? Thanks a lot.
... View more
01-31-2019
11:58 AM
Hello, I would like to keep the leading and trailing spaces when import the csv files into SAS. For example, hoping SAS treat the below response as different. "ItemKey","Response", "4615313059","contribution " "4615313067"," contribution" however, when I use: filename xfile "datadir\test.csv" encoding="utf-8" lrecl=532767; proc import datafile=xfile out=test1 dbms=csv replace; getnames=yes; datarow=2; guessingrows=592767; run; SAS treat them as the same. Can somebody help me out?
... View more
01-28-2019
02:22 PM
Hello SAS guys, Could somebody help me out? When running SAS program, if there is any error message showing on the log window, SAS program halt immediately. How to write code to get the result? Thanks
... View more
01-23-2019
01:55 PM
It works.Thank you very much!
... View more
01-23-2019
10:47 AM
Hello SAS experts, I want to get a report which has the bold bottom border when a column value changes. For example, data want; set sashelp.class; run; proc sort data=want; by sex name; run; ODS noresults; ODS listing close; ods Excel file="&dir.\test_&mon..xlsx" options (Embedded_titles = 'yes' sheet_name= "Class" frozen_headers= '2' frozen_rowheaders="9" row_heights="16pt,16pt,16pt,16pt" absolute_column_width= '8,8,8,16,8,8,8,8,8,8,8,8,8,8,8'); title1 j=l height=8pt font=Verdana color=CX000000 "Class by Gender "; options missing=" "; proc Report data=want NOWD style(header)=[vjust=m font_weight=bold foreground=white background=CX007FA3 FONT=(Verdana, 8pt, BOLD)] style(column)={vjust=m FONT=(Verdana, 8pt)}; Column name sex age weight height; define name / center display "Name"; define sex / order order=data noprint; define age / center display "Age"; define weight / center display "Weight"; define height / center display "height"; compute name; count+1; if (mod(count,2))=0 then do; call define(_row_,"style","style=[background=CXD4EAE4]"); end; endcomp; compute after sex / style=[borderbottomwidth=1pt borderbottomcolor=black]; endcomp; run; ods _all_ close; ODS listing; When the gender changes from Female to male, I want the excel output of the last person Mary to have bold black bottom border. But my SAS code doesn't work. Could someone help me out? Thanks a lot!
... View more
11-30-2018
09:26 AM
It is the problem which the Vars is empty. Got it and appreciate your help.
... View more
11-29-2018
04:30 PM
Hello Tom, The log window shows summ dataset is created there are 46 observations and 2 variables, while the vars dataset has 0 observations. If the two datasets are small, your code : ods output CompareSummary=summ; proc compare data=class compare=sashelp.class listequalvar outnoequal out=dif; run; may work well. However, for the large datasets with millions observations, I prefer noprint option. noprint option conflicts with listequalar, how do you solve it? I attached the capture of Summ dataset here, please tell me whether it is the same as yours. Thank you very much
... View more
11-29-2018
02:26 PM
Thank you for your reply. I tried running your code and what I got is the empty vars dataset. Is anything wrong with my SAS version?
... View more
11-29-2018
12:32 PM
I do need the compare output dataset, but I don't want to open it to check whether there are some discrepancy in individual variable or which variables have the discrepancy. I prefer to save the variable name as macro then export to excel file. When I open the excel file, I know the variables in two original datasets have discrepancies.
... View more
11-29-2018
11:38 AM
Hello SAS guys, I usually use proc compare to compare two large data sets. I only care about the no equivalence, so I use outnoequal option. My question is how can I know the variable names in the output data set. For example, the proc compare output data is the follows: id v1 v2............v30..............v50 I1 .. .. ............. X ............. X I2 ......................... X .............. X I3 ....... ...... I67894 ........ How can I know the variable V30 and V50 contians X which means different without opening the output dataset. Thank you very much
... View more
05-15-2018
09:27 AM
PaigeMiller, thank you for your suggestions. I used your method to solve that problem.
... View more
05-10-2018
11:14 AM
I want a table as data set. The percents and pass number in the exact same cell of the dataset. Thank you
... View more
05-10-2018
10:36 AM
Hello guys, I have a table like the below, var1 var2 var3 var4 var5 npass 23 34 27 43 nfail 20 18 37 16 npper 23/43 34/52 27/64 43/59 nfper 20/43 18/52 37/64 16/59 what I want is : var1 var2 var3 var4 var5 npass 23 (53.4%) 34 (65.4%) 27 (42.2%) 43 (72.9%) nfail 20(46.6%) 18 (34.6%) 37 (57.8%) 16 (27.1%) npper is passing percent , nfper is failing percent. the Var2 var3 var4 var5' s names are macro values. those macro values changes month by month. Thanks a lot!
... View more
05-01-2018
11:06 AM
Hi SAS experts, Here is another problem I try to solve. V1 V2 V3 survey_1 age Under 21 survey_1 age 21 - 25 survey_1 age 26 - 30 survey_1 age 31 - 40 survey_1 age 41 - 50 survey_1 age 50+ survey_2 Education Some High School survey_2 Education High School Graduate survey_2 Education Some College ....... I need to create V4 then just like: V1 V2 V3 V4 survey_1 age Under 21 A survey_1 age 21 - 25 B survey_1 age 26 - 30 C survey_1 age 31 - 40 D survey_1 age 41 - 50 E survey_1 age 50+ F survey_2 Education Some High School A survey_2 Education High School Graduate B survey_2 Education Some College C ....... How can I get V4 which is what I want. Thank you!
... View more