cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
VDD
  • 893 Posts
  • 359 Likes Given
  • 58 Solutions
  • 191 Likes Received
This widget could not be displayed.

Re: Forecasting by Weeks

by Calcite | Level 5 in SAS Visual Analytics
‎10-15-2019 12:50 PM
‎10-15-2019 12:50 PM
I had this issue (using v 7.4) and to solve it I created a data variable for the last day of the week.  So in visualizations I can show both (or either) the date or the "week end date" for summaries. I could not find a way to set up weeks as summary periods for doing any periodic comparisons. ... View more

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12...

by Super User in SAS Programming
‎10-08-2019 06:00 PM
‎10-08-2019 06:00 PM
@abdulla wrote: Hi I have date which is in format yymmddn8 and informat yymmdd6. I want to convert them into format Best12 and informat 12. Can anyone help me by giving code for that? I need to merge file by date but my date in two files are formated differently Provide a date Provide the numeric value you expect them to be.   And them answer why this is a critical task.   Formats and informats are variable properties. You can change them with Format or Informat statements. But likely you mean to  change the actual values but you aren't being explicit enough. ... View more

Re: How to sum values in a column and recode the values?

by Diamond | Level 26 in SAS Programming
‎10-08-2019 06:47 AM
‎10-08-2019 06:47 AM
@wernie wrote: I’m just trying to collapse the age groups to get <50, 50-65, 65+ and get the population total for those groups. The GEO_ID a unique ID so each GEO_ID needs to have the age groups collapsed and populations summed. This doesn't tell us anything more than the original message. How do you collapse groups numbered 1 to 10 into <50, 60-65, 65+ ?? ... View more

Re: problem to compare string in loop inside macro

by Lapis Lazuli | Level 10 in New SAS User
‎10-08-2019 03:16 AM
‎10-08-2019 03:16 AM
Hello,   only 123456789 PLNEXTIMP2 PLNEXT PLNEXT are loaded in the table. Inside the dataset step I have coded %if %then and it does not work. by replacing it with if then (without %) then it works ... View more

Re: An efficient debugging?

by Ammonite | Level 13 in SAS Programming
‎10-08-2019 01:04 AM
1 Like
‎10-08-2019 01:04 AM
1 Like
@braam: If your macro code has become too long, your macro has too many parameters, and/or, God forbid, inundated with quoting functions (including those applied to the parameter values to mask what not), you've overstepped the boundaries of the macro language's purpose and utility. Macros are he11 to debug, as one must understand (a) what happens during their compilation, (b) their execution and then (c) what happens during the compilation and (d) execution of the code they have generated.   If you see no alternatives to using macros for SAS code generation (which are plentiful), route your macro-generated code to a text file using the MFILE system option in conjunction with MPRINT. At least then you can run this code stand-alone and see what happens when it executes, rather than guess where in the generated code an array index has run out of bounds because in such a case the only place the SAS log points at is the line where the macro was invoked, so you have no clue.    Kind regards Paul D. ... View more

Re: Structuring multiple code files in a project

by Ammonite | Level 13 in SAS Programming
‎10-06-2019 07:33 PM
‎10-06-2019 07:33 PM
@SASKiwi: It surely looks that way!  ... View more

Re: Conditional formatting within a data step inside a MACRO

by PROC Star in New SAS User
‎10-04-2019 10:15 AM
‎10-04-2019 10:15 AM
One possible key to resolving this:  what is in the data set A1?  If it already contains new_var5 (defined as character) that would cause a problem.  You may need to get rid of any existing variable names that begin with "new_var":   set A1 (drop=new_var: ); ... View more

Re: Proc Export csv file - ending up with unreadable file

by Obsidian | Level 7 in SAS Programming
‎10-03-2019 07:30 PM
‎10-03-2019 07:30 PM
  VDD-   That was the problem.  I was staring at it and didn't register.   Thanks for your help and expertise.   wklierman ... View more

Re: proc format

by Ammonite | Level 13 in SAS Programming
‎10-03-2019 05:47 PM
‎10-03-2019 05:47 PM
well @ambreen there are to many things wrong to point at just one. Try this and see if you can find out what you did wrong.   data fda; *set cdc.hw7; input gender occupation judgedpreviously age; cards; 1 1 1 21 1 1 1 48 2 2 1 54 2 1 2 35 ; PROC FORMAT; VALUE Gender 1= 'Female' 2 = 'Male'; VALUE Occupation 1= 'Mstudent' 2 = 'Nurse' 3-5 = 'Resident' 6-10 = 'Fellow'; VALUE JudgedPreviously 1= 'Yes' 2= 'No'; VALUE Age 20-29 = 'second' 30-39 = 'third' 40 - 49 = 'fourth' 50 - 59 = 'fifth'; RUN; PROC PRINT DATA= fda ;/*cdc.hw7;*/ FORMAT GENDER GENDER. Occupation Occupation. JudgedPreviously JudgedPreviously. AGE AGE.; run; The SAS System Obs gender occupation judgedpreviously age 1 Female Mstudent Yes second 2 Female Mstudent Yes fourth 3 Male Nurse Yes fifth 4 Male Mstudent No third   ... View more

Re: Trouble with substr

by Super User in New SAS User
‎10-03-2019 03:42 PM
‎10-03-2019 03:42 PM
@marleeakerson wrote: I am trying to extract the year from a date variable (in the dataset as MM/DD/YYYY). But every time I use the substr statement, I get random numbers that are not even in the date variable at all. I first converted the original date variable from the number of days passed from Jan 1,1960 format to the MM/DD/YYYY format so i am wondering if that is contributing to it.    Thank you!    data want; set have; Year=substr(Date,7,4); run; You need to show your data.  If DATE is a character string like '10/03/2019'  then you are asking for characters number 7 thru 10 which would be '2019'.  If DATE is number with the MMDDYY10. format attach to it then it will first be converted to a character string using the BEST12. format.  So '03OCT2019'd would be converted to:  " 21825" And then the 7th to 10th characters would be " 218".   So you want a number out?  year=year(date); Or a string? year=put(year(date),4.); ... View more

Re: Seeking advice on developing SAS packaging system

by Lapis Lazuli | Level 10 in Administration and Deployment
‎10-03-2019 12:31 PM
2 Likes
‎10-03-2019 12:31 PM
2 Likes
You got an answer.  You didn't like the answer.  Those are two different things.   You haven't explained why Git and shared libraries won't solve your problem.  With a commitment by your organization to encourage/require their use.   Also, if you are going to set up shared code and libraries it would be best to have a code review procedure in place as well.  ... View more

Re: proc import xlsx secific row

by Opal | Level 21 in SAS Data Management
‎09-28-2019 07:57 PM
‎09-28-2019 07:57 PM
@ubshams  In case you don't need to implement a repetitive process but you just need to read this specific Excel sheet into SAS: I wouldn't bother to write code which can read this messy structure but I would modify the structure so that it's easy to read.   What you could do: 1. copy the sheet 2. get rid of all unwanted rows; have the column headers in row 1 and the data starting in row 2 3. store the sheet as .csv 4. eventually use the EG import wizard to generate the SAS code for reading the .csv 5. modify the generated code as you see fit (i.e. add a label statement, modify formats to whatever you want).   Here the EG generated code reading the attached .csv created from your sample Excel data. I've already added a label statement as well. DATA WORK.sample; LENGTH m2 8 xyz1 8 xyz2 8 xyz3 8 ; FORMAT m2 DATE9. xyz1 BEST6. xyz2 BEST6. xyz3 BEST4. ; INFORMAT m2 DATE9. xyz1 BEST6. xyz2 BEST6. xyz3 BEST4. ; label m2='some label' ; INFILE '/foldername/sample1_csv.csv' DLM=';' MISSOVER DSD; INPUT m2 : ?? DATE9. xyz1 : ?? COMMA6. xyz2 : ?? COMMA6. xyz3 : ?? COMMA4. ; run;   ... View more

Re: Summarization Help

by Diamond | Level 26 in SAS Programming
‎09-25-2019 09:37 AM
1 Like
‎09-25-2019 09:37 AM
1 Like
@anweinbe wrote: I would like them to be easily understood. Exact names do not matter in most cases. It would be great for example if the company name did say “company”. It looks like you should do this via PROC SUMMARY and PROC TRANSPOSE    proc summary data=have2 nway; class company year type; var total; output out=sums sum=; run; proc transpose data=sums out=want; by company year; var total; id type; run; ... View more

Re: Operating System Scheduling: unable to login

by PROC Star in Administration and Deployment
‎09-17-2019 04:12 PM
‎09-17-2019 04:12 PM
@MariaD - By adding @saspw on the end of the user account you are calling the metadata identity of the account not the OS version. Try removing this. ... View more

Re: SASStudio not loading

by Calcite | Level 5 in SAS Studio
‎09-07-2019 02:07 PM
‎09-07-2019 02:07 PM
I am currently facing the same issue. Stuck at Initialing. I change browsers and that did not change anything.    ... View more
Contact Me
Likes given to
Likes from
Quick links